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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Unable to connect to sql server on my machine

Author  Topic 

reddymade
Posting Yak Master

165 Posts

Posted - 2006-11-29 : 12:14:19
I have two instances on the server MSSQLSERVER and MSSQLSERVER1

would like to connect to MSSQLSERVER1.
Can you please help, i am using windows 2003 server/sql server 2005

*********************************
Unable to connect to server.

an error occured while establishing a connection to server.

when connecting to sql server 2005, this failure may be caused by the fact that under default settings sql server does not allow remote connections.( provider: named pipes provider, error: 40- could not open a connection to sql server)

microsoft sql server error: 2

******************************

Thank you very much for the information.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-29 : 13:03:26
Which tool/application are you using to connect?

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -