I get the provider error in my host

Question

1.00/5 (1 vote)

See more:

Hi I create asp.net core mvc project with .net core 7.
now I want put my site on host. I do this and configure the Plesk but i get this error:

An unhandled exception occurred while processing the request.
Win32Exception: The system cannot find the file specified.
Unknown location

SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

What I have tried:

my connection string in appsetting.json is:

"data source=.\MSSQLSERVER2022;Initial Catalog  = myddb; User ID = myuser; Password = mypass;MultipleActiveResultSets = true;"

how can fix this? please help.

Posted 6-Dec-23 18:21pm

Member 11400059

Add a Solution

2 solutions

Solution 1

Call your hosting provider and bring the error up with them. The error means your code cannot connect to the SQL Server because there's no server to be found. You might want to make sure the name is correct as you put ".\MSSQLSERVER2022". The "." portion of the name means the SQL Server is expected to be on the same machine as your web server code. That is rarely ever the case.

Posted 6-Dec-23 18:50pm

Dave Kreskowiak

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2023-12-06T20:32:00

The error message is very clear. An instance of MS SQL Server named ".\MSSQLSERVER2022" does NOT exist on server machine or is NOT accessible from the WAN.

You can resolve your issue by doing the following:
1) check connection string, especially the name of MS SQL Server instance
See the examples of proper connections strings: SQL Server connection strings - ConnectionStrings.com[^]
2) If it's correct, configure MS SQL Server to be visible from outside
See: Lesson 2: Connecting from Another Computer - SQL Server | Microsoft Learn[^]
3) If you can NOT use your machine to act as an sql server, you'll need to find a service (provider).

BTW: if you store the connection string in your code, i'd strongly recommend to move it into configuration file. Please read this:
Connection Strings and Configuration Files - ADO.NET | Microsoft Learn[^]
Connection Strings - EF Core | Microsoft Learn[^]