Sql server 2005 express error 40 and 2

Question

0.00/5 (No votes)

See more:

good night

Sorry for a question on my machine I have sql server 2005 express there I have some databases and from one moment to another it does not let me start the server and I mark this error

"Error 40 Can not open a connection to SQL Server, error 2"

Apart from not letting me start the sql server, I delete the databases I would like to retrieve the favor someone knows how to fix the error or recover the databases I have

Thank you

What I have tried:

And try to start it from the "configuration manager" of sql server and in the "services" section but will not let me start it

Posted 31-Mar-17 18:12pm

Member 13098407

Updated 31-Mar-17 18:22pm

Add a Solution

1 solution

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)

Graeme_Grant · Accepted Answer · 2017-03-31T18:22:00

Solution 1

Google Search offered this: SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server. - Journey to SQL Authority with Pinal Dave[^]

More answers for the same question asked here before: SQL SERVER ERROR 40 in C#[^]

Posted 31-Mar-17 18:22pm

Graeme_Grant

Updated 31-Mar-17 18:24pm

v2

Comments

Member 13098407 1-Apr-17 10:55am

thanks for your reply
I'll check it
Thank you