April 15, 2015 at 12:40 pm
This is likely a simplistic question but I'm having trouble finding explicit documentation on this:
Say I have 2014 AlwaysOn setup and working:
SQLNode1 ->Instance01
SQLNode2 ->Instance02
When I setup my listener: ListenerA
Do I need to use the instance name in it?
ListenerA\Instance01 or ListenerA\Instance02 depending on which SQLNode is the "active" availability group?
Am I better off to use the same instance name for both nodes, since my goal is to have all databases on both instances in the same availability group and sync'd?
When SQLNode1 migrates over to SQLNode2 I will need to update the instance name in my connection string on the listener from ListenerA\Instance01 to \Instance02?
When I connect with SSMS do I just use: ListenerA\Instance01 (or 02)?
April 15, 2015 at 2:04 pm
Maxer (4/15/2015)
This is likely a simplistic question but I'm having trouble finding explicit documentation on this:Say I have 2014 AlwaysOn setup and working:
SQLNode1 ->Instance01
SQLNode2 ->Instance02
When I setup my listener: ListenerA
Do I need to use the instance name in it?
No, the listener has a DNS name, IP and port number
Maxer (4/15/2015)
ListenerA\Instance01 or ListenerA\Instance02 depending on which SQLNode is the "active" availability group?Am I better off to use the same instance name for both nodes, since my goal is to have all databases on both instances in the same availability group and sync'd?
When SQLNode1 migrates over to SQLNode2 I will need to update the instance name in my connection string on the listener from ListenerA\Instance01 to \Instance02?
When I connect with SSMS do I just use: ListenerA\Instance01 (or 02)?
The listener is independent of the individual instance names. You just require a DNS name, IP address and port number
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 2:21 pm
So the listener is "for the availability group" not the instance itself, which makes sense if I think about it that way.
Is that correct?
it has no concept of instance name?
April 15, 2015 at 2:35 pm
Maxer (4/15/2015)
So the listener is "for the availability group" not the instance itself, which makes sense if I think about it that way.Is that correct?
correct
Maxer (4/15/2015)
it has no concept of instance name?
correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply