Cannot connect to second cluster node w/instance name
- From: "JPerkins" <joshp@xxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 12:39:02 -0800
I have an active/active SQL2005 cluster. Node1 has a default instance of SQL 2005 installed (i.e. no named instance). Node2 has a named instance of SQL 2005 (i.e. node2\sqlb). I can connect remotely to node1 SQL 2005 without problem. When I attempt to connect to node2 remotely I get an error basically stating "An 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)".
When I connect I am using node2\sqlb as the connection name--this should give me access to the named instance. I can however access node2\sqlb from node2 directly (locally on the server). Yes, I have made sure named pipes and tcp/ip are enabled. Made sure no firewalls, etc. The weird thing is that I was able to make a remote connection for a short time (like two hours) and then I couldn't anymore.
I am using a Windows Vista Ultimate RTM machine with SQL 2005 management console installed locally. Any information would be greatly appreciated.
.
- Follow-Ups:
- Re: Cannot connect to second cluster node w/instance name
- From: Rick Byham, \(MSFT\)
- Re: Cannot connect to second cluster node w/instance name
- Prev by Date: Re: Stop error 0x0000008E when opening database tables with SQL SMS Express.
- Next by Date: Re: Cannot connect to second cluster node w/instance name
- Previous by thread: VB Express can't connect to anything
- Next by thread: Re: Cannot connect to second cluster node w/instance name
- Index(es):
Relevant Pages
|