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 Server Names for SQL7.0

Author  Topic 

Jay1Jay
Yak Posting Veteran

50 Posts

Posted - 2003-07-02 : 13:51:15
I have SQL7.0 installed on Server (name Accounting), however due to change organizational changes we need to rename this server to Tax. Can I just do this, will SQL still work after I rename the server, or what steps would I need to take.

Thanks,

Jay

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-02 : 13:56:20
The answer is in question 5, the first bullet, in the below article:

[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;195759[/url]

Tara
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-02 : 13:57:02
Just so that you know, for SQL 2000, you only have to run sp_dropserver then sp_addserver. In 7.0, you have to run those plus run SQL setup.

Tara
Go to Top of Page
   

- Advertisement -