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 2005 Forums
 Transact-SQL (2005)
 Error while connecting to sqlserver2005

Author  Topic 

Ambikaa
Starting Member

43 Posts

Posted - 2008-11-06 : 01:02:24
Hi,

I am getting this error when i connect to the remote computer's sql server. The errror follows
-specific error occured while establishing
a conneciton to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL server us configured to
allow remote connections.(Provider: Named Pipes Provider, error:40-
Could not open a connection to SQL server) (Microsoft sqlserver,Error:5)

I followed the each and every steps that are mentioned for allowing remote connections. for eg surface area configuration->remote connections....

Please help me.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2008-11-06 : 01:48:20
check the below link u may find some information
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

"There is only one difference between a dream and an aim. A dream requires soundless sleep to see, whereas an aim requires sleepless efforts to achieve..!!"
Go to Top of Page
   

- Advertisement -