connection to sql server error 40 and 53

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hi, i have just installed sql server 2005 in my windows 7.
with instance name sachin and with mixed authentication.
but now i am not able to connect to the sever.

this error window shows whenever i try to connect.

"Cannot connect to sachin.
Additional information:
A network-related or instance-specific error occurred while establishment a connection to SQL server. The Server was not found or was not accessible. Verify that the instance name is correct and that sql sever is configured to allow remote connections. (provider: Named pipes provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL sever, Error: 53)

Posted 13-Aug-11 9:28am

Sachin gulati

Updated 30-May-19 0:55am

Add a Solution

4 solutions

Solution 1

There may be many reasons, read this

SQL SERVER connection problem[^]

Posted 13-Aug-11 9:31am

thatraja

Comments

Wendelius 13-Aug-11 15:58pm

OP's comment:
i have newly installed my sql.
and never run it before on my pc...
is dis information sufficient??

do i need to configure it before running it?
i just installed it but its not connecting.

Wendelius 13-Aug-11 16:00pm

Exactly, my 5

Sachin gulati 13-Aug-11 16:41pm

hey i checked out d link u gave me..
after reading it.
i turned on my ip/tcp protocol n other service, my firewall is off.
but they said that it will not take effect until this services will b restarted.
so i stop every service and now i m not able to start them againg.
i have restarted my computer. but they r not starting again.
what to do? pls help me....

Solution 2

i have newly installed my sql.
and never run it before on my pc...
is dis information sufficient??

do i need to configure it before running it?
i just installed it but its not connecting.

Posted 13-Aug-11 9:44am

Sachin gulati

Comments

Wendelius 13-Aug-11 15:59pm

Instead of adding a new solution add a comment to the original solution. This way the author of the solution gets notified via email and gets your comment.

Solution 3

If you're having problems to start the SQL Server, the 'best' place to look is the SQL Server error logs.

Go to the SQL Server installation folder for the instance and find the ErrorLog file (no extension). Open it in for example notepad and locate any error messages.

If they aren't understandable, you can post a new question (since this most likely is a different problem than you question in this thread).

Posted 13-Aug-11 11:00am

Wendelius

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)

skb choudhary · Accepted Answer · 2011-08-13T20:26:00

Solution 4

due to some dll file missing, this kind of error occur... Take another setup of sql server

Posted 13-Aug-11 20:26pm

skb choudhary