Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Problem when connecting to database engine

Author  Topic 

kiranbvsn
Starting Member

11 Posts

Posted - 2011-04-11 : 12:34:53
hi,
i've installed sql server 2005 developer edition on windows 7 64bit and applied sp3,
the problem here is when i am connecting to database engine, it is showing the below error message

An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

please kindly help me, i've googled it but i didn't find the solution
plzz help me

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-04-11 : 12:43:35
see here:
http://support.microsoft.com/kb/914277/en-us


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-11 : 12:59:08
Remote connections is rarely the problem. If what webfred linked to doesn't fix the problem, then see this: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-15 : 14:57:51
Open the SQL Server Configuration Manager and enabled the NAMED PIPE Protocl and then restart the SQL SERVER Services

Regards,
Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA
Go to Top of Page
   

- Advertisement -