Click here to Skip to main content
13,793,791 members
Rate this:
 
Please Sign up or sign in to vote.
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 10:28am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

There may be many reasons, read this

SQL SERVER connection problem[^]
  Permalink  
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....
Rate this: bad
 
good
Please Sign up or sign in to vote.

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.
  Permalink  
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.
Rate this: bad
 
good
Please Sign up or sign in to vote.

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).
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 4

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.181207.3 | Last Updated 14 Aug 2011
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100