Scenario: I have a named instance such as SERVER1\NAME.
I need to migrate this instance to an AlwaysON, but I'd like to use the same instance name in the listener. Is it possible?
I was planning a side-by-side migration:
Create 2 new instances. (SERVER2\NAME and SERVER3\NAME)
Create a Listener called SERVER1_NEW.
Once everything is ready for the cut-over, just rename the SERVER1 to SERVER1_old and then rename SERVER1_NEW to SERVER1.
Is that going to work? The plan is to avoid changing the connection strings everywhere.