Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Changing SQL Server IP address ?

Author  Topic 

kjchaplin
Starting Member

1 Post

Posted - 2004-08-10 : 10:23:41
Hi. I have a NT 4 server with SQL 7. I know its not a good idea to change the server name as SQL uses the computer name internally. Does the same apply to changing the servers IP address ? I have checked TechNet and 'SQL books online' but cannot find anything on this topic. Many Thanks Kevin.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-10 : 10:25:33
Changing the IP address shouldn't be an issue. Anytime you change the name or IP address, just make sure the DNS and WINS servers get updated. Otherwise, you'll be in for a fun night.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -