asked
DNS alias for named instances
Hi, I'm in the process of specifying how to consolidate several servers into just a few. We will isolate databases belonging to system groups into their own instances in the machine. Now I'd like to also add some flexibility - being able to move databases between servers and instances without having to redeploy Connection strings in the apps. My idea is this: - Create an IP adress for each instance in a server - In SQL ServerConfiguration Manager, set the instance to listen to a specific IP and port (disable ListenAll and dynamic ports). - Add DNS A records for each instance. - Add an Alias for each system, pointing to the A record for the correct instance. Will this work? If I had a lab environment to test this out I would, but unfortunately I don't.
You'll also need to do the SQL Server Alias work, as outlined in
https://msdn.microsoft.com/en-GB/library/ms190445.aspx
Thanks Thomas. Will I have to create one SQL Server Alias for each DNS Alias? And will this work with OLEDB as well, or am I stuck with Native Client (which I figure would be a problem from UNIX/Linux servers).
I'm rather at the limit of my knowledge on this now! It looks as though the author of this post might be a useful chap to talk to:
http://geekswithblogs.net/twickers/archive/2009/12/08/136830.aspx
17 People are following this question.
