SQL Server Clustering

Question

SQL Server Clustering

balu.arunkumar

Ten Centuries

Points: 1132
More actions
December 30, 2016 at 1:24 am

#320157

Hi,
I'm new to SQL server clustering. I have two nodes of active-passive clustering.
Node1 IP : 10.XX.XX.XX
Node2 IP : 10.YY.YY.YY
I don't have access
When intial stage SQL service is running on Node1. After fail-over the service is running on Node2. At initial stage i'm able to connect instance via SSMS. But now im not able to connect from SSMS.
Note: I have network access from Node1 only
Pls help me...
January 2, 2017 at 10:36 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

When you attempt to connect, are you supplying the node name (or IP address) or the virtual SQL Server name? If you look in SQL Server Configuration Manager, what network protocols are enabled? What protocol are you using to connect?

John

balu.arunkumar Ten Centuries Points: 1132 More actions · Answer 2

Hi John,

I'm connecting SQL Server instance using IP(10.AA.AA.AA). But we don't have access for Node2 IP(10.YY.YY.YY).

When we ping using Node2 IP its throws "Request timed out" error.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

Where are you connecting from? Are both nodes in the same subnet? It sounds like you need to ask your network people to sort your access.

John

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

John Mitchell-245523 (12/30/2016)
When you attempt to connect, are you supplying the node name (or IP address) or the virtual SQL Server name? If you look in SQL Server Configuration Manager, what network protocols are enabled? What protocol are you using to connect?
John

There will be a common virtual IP and name for you A/P cluster and you can connect that by SSMS. Also, you can connect by node name and IP when it runs under that node.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 5

balu.arunkumar (12/30/2016)
Hi,
I'm new to SQL server clustering. I have two nodes of active-passive clustering.
Node1 IP : 10.XX.XX.XX
Node2 IP : 10.YY.YY.YY
I don't have access
When intial stage SQL service is running on Node1. After fail-over the service is running on Node2. At initial stage i'm able to connect instance via SSMS. But now im not able to connect from SSMS.
Note: I have network access from Node1 only
Pls help me...

Hi Balu,

You can connect using SQL Server service Name\IP from both nodes.

Make sure open SQL Browser port UDP 1434 in local firewall. Let know if you still face issue.