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 : 12:48:39
|
| 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:39:08
|
| See http://support.microsoft.com/kb/914277 |
 |
|
|
kprasadreddy
Starting Member
41 Posts |
Posted - 2007-02-19 : 13:51:28
|
| Did steps i thru 3 and do not have a windows firewall on the server.I am logging in using dev.xxxurl.com\WDWEBDEV .Can we do this? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-02-28 : 14:22:31
|
| maybe a stupid question... is the server in question member of the domain?have you added your nt account on the dev server? if not, logon locally firstHTH--------------------keeping it simple... |
|
|
|
|
|
|
SQL Server connectivity