Home Forums SQL Server 2008 SQL Server 2008 Administration Changing NAME and IP ADDRESS of machine where SQL Server is hosted. RE: Changing NAME and IP ADDRESS of machine where SQL Server is hosted.

  • August 7, 2014 at 7:27 am

    #1735957

    anthony.green (8/7/2014)

    Only other one would be to test your TTL on the DNS entry, you will want to flush your DNS cache on all machines so that it picks up the new IP address quickly, otherwise if you can find a way to run "ipconfig /flushdns" on all machines in your environment at once then great, and please do let us know the solution as I have yet to find one.

    You will then need a maintenance window which is larger than your TTL so that all machines in the environment can re-acquire the new IP address from your DNS servers.

    If you have a list of all the machines in your environmet you could script PsExec to run on each machine.

    Or Group Policy with a startup or login script.