March 28, 2007 at 6:59 am
guys,
I am not able to connect remote sql server 2005 instance in the same domain
I 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 enable
2. 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 missing
Any suggestions/inputs to troubleshoot this issue would help
Thanks
March 28, 2007 at 7:44 am
Sri,
you need to enable either TCP or Named Pipe as a Server protocol. With shared memory only local clients can connect.
Markus
[font="Verdana"]Markus Bohse[/font]
March 28, 2007 at 8:12 am
A few of things you can try;
- Try changing the default tcp port from 1433
- Disable windows firewall Control panel => Administrative tools => Services and stop windows firewall. Or if you don't want to disable it create an exception (add program => SQL Server / sqlservr.exe). You may also need to add a port. 1433 is usually disabled by default because its a popular port for virus attacks.
- Create an 'alias' on the client machine. Alias name = <server name>, Server = <server IP>, Protocol = <tcp>, port = <default is 1433, but i'd change it>
- Add a ODBC driver; Control panel => Administrative tools => Data sources(ODBC) add SQL Native Client & SQL Server drivers on the client and server respectively
Hope you get a result!!
Toby
March 29, 2007 at 6:41 am
I figured it out sql browser was not enabled, anyways got to know few more things which will help me trouble shoot related issues.
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply