SSMS AAG Failover Wizard - Change Connection String

  • We created a SQL AAG and added replica servers on named SQL instances. At the time of creation we had the SQL Browser configured. When we added the replica servers, we did not specify the port for the named instance. Subsequently we have locked down our servers by disabling the Browser and blocking UDP 1434. Now when we use the failover wizard we cannot connect to the secondary replica because you cannot change the server instance name. Is there a way to update the server name to add the port for the named instance so we can use the Wizard?

    Obviously, we can script the failover, however we would like to be able to use the SSMS wizard.

    Has anyone faced, and resolved, this challenge?

  • Edit: I've read this again and I see that you're specifically talking about Management Studio- sorry. Have you tried re-creating the Availability Group. No change?

  • I'm pretty certain rebuilding the AAG will work. But we are trying to avoid the effort of having to rebuild. I am hoping there is a way to modify behind the scenes.

Viewing 3 posts - 1 through 2 (of 2 total)

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