This week I had an interesting question proposed by a customer on how to implement a group policy that would generate the proper SQL Server alias records on all machines in the domain. The desired result was to have users be able to connect to using a simple CNAME that could easily be changed in the future, if needed.
I successfully reproduced this in my lab and confirmed the same process worked for the customer in question. I figured this would be be great walk-through to broadcast to a larger audience. However before we get started, here are some things to keep in mind:
1) We strongly suggest trying this in a test environment before pushing to production
2) Relevant system/environmental information for this repro:
Now that we got that out of the way, let's get started!
Hope this helps!
SQL Server Support Engineer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.