It's like this, I have moved my web app Blazor from Windows computer to Mac Pro m4 previously I have not had problems with being able to access sql server but right now I can't in any way get access to the server at all. This is after I have switched to Mac pro m4. I have added my IP to the database. This also allows me to use Azure Data Studio to view and edit data. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 26 - Error Locating Server/Instance Specified)

This error message means that you were not able to reach the SQL Server instance you are trying to connect to. This could be because you have misspelled the server name, there are blocking firewalls etc. As I understand it, you can connect to the database from Azure Data Studio, but your application cannot. That suggests that you need to review the connection string or any configuration file it may be reading from.

A Network-related or Instance-specific error - TCP Provider - Error with Mac m4

Accepted answer

Erland Sommarskog 119K Reputation points MVP

2025-03-01T12:26:24.15+00:00

This error message means that you were not able to reach the SQL Server instance you are trying to connect to. This could be because you have misspelled the server name, there are blocking firewalls etc.

As I understand it, you can connect to the database from Azure Data Studio, but your application cannot. That suggests that you need to review the connection string or any configuration file it may be reading from.
Please sign in to rate this answer.
Jesper Petersen 45 Reputation points

2025-03-01T12:40:55.6333333+00:00

Hi

Thanks for your reply back.

Now I have tried copying Connection strings from ODBC and ADO.net on my database which is on Azure and both fail. And remove the old one which was on the website but then added the one which is from the Azure page.

No I am trying to connect to the database through my Blazor page. But it will not let me do it.

Jesper Petersen 45 Reputation points

2025-03-01T12:49:10.65+00:00

Here are my database information..

Server=tcp:xxxx.database.windows.net,1433;Initial Catalog=sxxx;Persist Security Info=False;User ID=xxx;Password=xxxxxx;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Erland Sommarskog 119K Reputation points MVP

2025-03-01T14:54:01.5+00:00

You might be looking in the wrong place then. From a database perspective, the gist of the error message is very clear. Since I don't know anything about Blazor, I can't help there, but I've changed the tag to Blazor. (And I am sorry if it says Blazor Training, but the new tagging system in Q&A have some imperfections.)

Jesper Petersen 45 Reputation points

2025-03-01T15:49:29.3466667+00:00

Okay. I'm confused about that, because the problem is that on my Windows PC I could access the database, but right now I can't after switching to Mac. But fair enough that you do. I see it more as a problem in relation to Azure Db, that I can't access the database because I'm on my Mac book pro m4.

Erland Sommarskog 119K Reputation points MVP

2025-03-01T18:36:20.75+00:00

Azure does not give care about which hardware you are connecting with. But the Blazor thingie is maybe reading the connection information from some different place than on Windows.

Bruce (SqlWork.com) 72,026 Reputation points

2025-03-01T19:02:38.7933333+00:00

You don’t specify which db access library you are using, so we can’t verify your connect string. If azure data studio can connect from your mac, you application should be able also using the correct db drivers and connection values.

Jesper Petersen 45 Reputation points

2025-03-01T19:54:12.2366667+00:00

Bruce Thanks for tip me back. I access library EF to connect to my database.

Jesper Petersen 45 Reputation points

2025-03-02T10:25:57.8166667+00:00

i have complete this. I have error on my Serilog. Sorry for take u time.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

A Network-related or Instance-specific error - TCP Provider - Error with Mac m4

0 additional answers

Your answer