May 13, 2009 at 10:29 am
Hello,
I can't connect from my SSMS 2008 installation to a SQL Server 2005 cluster (64-bit). The error I get is "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"
I can successfully connect to the very same server and instance using SSMS 2005 installed on my machine, so I know it's not a network-related error. In both cases I'm using my Windows login so it's not a permissions issue either.
It's a total PITA to have to switch to SSMS 2005 to connect to just one set of servers. Every other 2005 server I connect to works just fine. I've searched the web for anything that might shed some light on this to no avail. Any ideas?
May 13, 2009 at 12:40 pm
Is TCP/IP enabled in ur client protocols for your SQL 2008 Sql Server Configuration Manager? under SQL Native Client 10.0 Configuration?
May 13, 2009 at 12:43 pm
Yes it is.
As I said, I can connect to a whole bunch of other SQL2K5 servers, it's just this cluster in particular that I'm having trouble with.
May 13, 2009 at 12:55 pm
dwierenga (5/13/2009)
Yes it is.As I said, I can connect to a whole bunch of other SQL2K5 servers, it's just this cluster in particular that I'm having trouble with.
Thanks for that. Can u create an Alias name for ur SQL2k5 server Under SQL Server Configuration Manager and then try to connect to that server using SSMS2K8, Do u get connected through that?
May 13, 2009 at 12:59 pm
Nope, aliases don't work either.
May 29, 2009 at 10:44 am
I got the same error (error: 26) connecting from my desktop SSMS 2008 to a SQL Server 2008 cluster (64-bit).
I am using Alias with different port number than 1433. Its a named instance. I have checked services including browser service are running, protocols (TCP\IP, Shared, Named) are enabled, firewall is enabled. I can telnet , but could not connect from my desktop SSMS 2008.
I can connect to another named instance of SQL 2008 from my desktop using same windows authentication.
Is there anyone who can help me out.
Thanks.
Zillur
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply