Issue regarding DNS Alias

Question

We have migrated several dtabases from 2000 to R2. Everything is fine. But the only problem we have taken the 2000 databases offline but now the DNS alias is unable to redirect the traffic to the new server as the old server is still not shutdown and DNS alias is hitting the old server. As a result the applications are failing. Can we rename the old server to get over this issue?

Answer 1

Please check here

Troubleshooting steps
http://technet.microsoft.com/en-us/library/cc787724(WS.10).asp
configuration steps
http://www.techrepublic.com/blog/datacenter/how-do-i-install-and-configure-a-dns-server-in-windows-server-2008/327

 

hope this helps you

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

Can I go and give an alias name to the server as a old server for time being?would that work?

Answer 3

Hi Steve,

Yes you can rename the Old Server running SQL Server 2000 to SERVEROLD

Also run "ipconfig /flushdns" on webserver or client computer accessing SQL server , so that DNS cache will be cleared as well and resolute to new server properly

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"

Answer 4

Please Use "FQDN" with shutting down old server ....It will grab new server alias automatically.

---

Kuldeep