0

We are migrating from SQL Server Fail over Instance to Always On Availability group. The current network name is ABC\ABCTEST where ABC is the SQL server Virtual Name and ABCTEST is the named instance name. In always on availability group all the connection will make connection through the Listener name for example Listerner123 and it will not use any instance name and the replicas are standalone.

Now is there any way to have the name as VirtualName\InstanceName or we will simply use the Listener name in the connection strings

1

There is a way: use alias on source machine. Anyway, if possible, I suggest you to correct connection strings.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.