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 |
|
kprasadreddy
Starting Member
41 Posts |
 Posted - 2007-02-19 : 13:15:37
|
| I am trying to connect to my dev Sql server instance remotely from my developer edition and I get the following errorAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)i Made sure that the following are complete# [Link] Enable the TCP/IP protocol using the Surface Area Configuration Utility# [Link] Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility# [Link] Make sure the SQL Server browser is started |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-19 : 13:29:05
|
| Duplicatehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79348 |
 |
|
|
|
|
|
sql server connectivity