October 10, 2006 at 3:11 pm
we plan to move our sql server from one place to another place. It's IP has to been changed, yet the hostname can be kept. I need to access the possible impact of this move. Our application server query the datababase by server name. Apart from changing the DNS, what else I have to pay attention ?
October 10, 2006 at 4:05 pm
if you use hostname in the connection strings, than all you have to do is update DNS. Just make sure you identify all connection strings DSN's etc.
October 10, 2006 at 11:48 pm
thanks Vik.
October 11, 2006 at 7:19 am
Don't forget to go into SQL ServerConfiguration manager and make sure the "Listen on" settings under protocols, tcpip, properties reflect the proper IP address(es). Should be fine for most folks, but in our case we had bound SQL to only one of the network cards in the server and when changing the IP address, we had to change these settings.
Student of SQL and Golf, Master of Neither
October 11, 2006 at 10:23 am
It will also depend on if you are using IP address for your link server. Note all other machines Host files will need to be updated to the new address also.
Also, if your users/developers have the IP address hard coded for SQL Server Management Studio, then they will have to change also.
Good Luck
Eric
October 11, 2006 at 2:06 pm
Since Windows caches DNS information you may have to resort to some specific windows level actions on your machines in addition to the abovementioned items.
For the clients this would be:
IPCONFIG /FLUSHDNS
For the SQL Servers this would be:
IPCONFIG /RENEW
IPCONFIG /REGISTERDNS
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply