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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-03-28 : 08:58:36
|
| guys,I am not able to connect remote sql server 2005 instance in the same domainI get the following error"An error has occured 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)"I have checked the following 1. Remote connection is enable2. In the sql server configuration manager 'shared memory' for sql server 2005 network configuration manager is 'enabled' 'shared memory', 'TCP/IP', 'Named Pipes' for client protocols under sql server native client configuration are 'enabled'Is there anything I am missingAny suggestions/inputs to troubleshoot this issue would helpThanks |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-28 : 14:50:56
|
| If it is not default try to specify the port number along with instance name...servername\instancename,portnumberMohammedU |
 |
|
|
|
|
|
Unable to connect remote SQL Server Instance