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

asked Dec 3, 2018 at 17:00

1 Answer 1

1

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

answered Dec 3, 2018 at 17:39
2
  • How would you do this? Could you perhaps add a bit more information to your answer? Commented Dec 4, 2018 at 8:32
  • Take a look here: dba.stackexchange.com/questions/120306/… Important: whatc the comments' part about 32 and 64 bit version. Commented Dec 4, 2018 at 18:38

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.