asked
how can i use an Alias for all client connections to a Named instance
I was recently doing a development environment consolidation and had to put 2 instances on one
machine.so the instance in question is the second (Named) instance.lets name default server ABC and the named one is ABC\123, so before ABC\123 was created as named instance its name was 123 (On a different machine) .So i want to create An alias keeping its original name (123) and want all user and client connections to connect to it as 123 and be redirected to the named instance (ABC\123).any help would be appreciated. Thank you
@scorpio_thech There is a [post about alias configuration][1] which might help with setting it up. [1]:
https://blog.mariusschulz.com/2014/02/09/how-to-configure-a-sql-server-alias-for-a-named-instance-on-a-development-machine
18 People are following this question.
