June 11, 2012 at 5:55 pm
Hi,
We have SQL Server 008 R2 failover clustered instance.
Installation and everthing went smooth. But I'm getting a weired error
Unable to connect to SQL Server clustered instance from one of the nodes
When SQL Server Resources are on sql1:
Connect from SSMS from sql2--> NOT Able to connect to SQL instance (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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2))
Connect from SSMS from sql1-->Working fine
When SQL Server Resources are on sql2:
Connect from SSMS from sql1-->Working fine
Connect from SSMS from sql2-->Working fine
Please advise.
June 12, 2012 at 1:25 am
When SQL Server is running on node 1, ensure that the SQL Server Browser is started, and that SQL Server Browser traffic is allowed through windows firewall (UDP 1434). As you connect using named pipes, I would also ensure that NetBIOS (tcp 445) is opened in the firewalls.
June 12, 2012 at 9:39 am
Windows Firewall service was already disabled on both nodes.
Please advise what else I need to verify?
June 12, 2012 at 9:54 am
Issue fixed.
Actually, on one of the nodes Firewall is running.
Disabled the firewall and it's working fine
Thanks
May 1, 2015 at 6:58 am
Thanks Gary.
My issue fixed today after reading this thread.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply