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.
| Author |
Topic |
|
Ambikaa
Starting Member
43 Posts |
 Posted - 2008-11-06 : 01:15:16
|
| Hi,I am getting this error when i connect to the remote computer's sql server. The errror follows-specific error occured while establishinga 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 toallow 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. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-06 : 09:02:22
|
| Did you enable TCP/IP? |
 |
|
|
Ambikaa
Starting Member
43 Posts |
Posted - 2008-11-11 : 00:44:46
|
| Hi,I already enabled TCP/IPie., Surface area configuration for services and connections->Remote Connections->Local and remote connections->enabled TCP/IP.what else i have to do now? |
|
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2008-11-11 : 00:51:06
|
| Is both computer is enabled for remote connection.malay |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-11 : 01:09:47
|
| link below might help youhttp://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/ |
|
|
|
|
|
|
Pls help me