Service-based database error

Question

1.00/5 (2 votes)

See more:

Hello, what is the reason for this message?

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: sql network interfaces, error: 50- local database runtime error occurred. error occurred during localdb instance startup: sql server process failed to start.

What I have tried:

sqllocaldb.msi was installed and not working

I hope for a solution, thank you

Posted 14-Feb-24 16:17pm

yossef2023

Add a Solution

Comments

Graeme_Grant 14-Feb-24 23:47pm

The error message is very specific. Check that you connection string is pointing correctly at the database.

yossef2023 14-Feb-24 23:49pm

Online. Is there a link to how to solve the problem?

2 solutions

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)

OriginalGriff · Answer 1 · 2024-02-14T19:43:00

Quote:
Online. Is there a link to how to solve the problem?

Read the message carefully: it says that it either can't find SQL server at the address given in your connection string, or the server is hosted on a different computer which is not configured to allow remote computers to access the DB server.

There is no software cure for that that we can give you: you need to check the actual connection string you are using, then check that server at the other end of it - if it is a web-based server address, then the DB admin for that specific server needs to allow remote connections - which he is unlikely to do as they are generally disabled for security reasons.

We can't help you with that: we have no access to either your code, your connection string, or the remote server!

M Imran Ansari · Answer 2 · 2024-02-14T21:51:00

Check the refer article and try to use "(localdb)\mssqllocaldb" as the server name for connecting to the LocalDB instance, for example: SQLCoffee - Breaking Changes to LocalDB[^]

C#

<connectionStrings>
  <add name="yourContext" connectionString="Data Source=(localdb)\mssqllocaldb; ...
</connectionStrings>

Service-based database error

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0