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.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-07-08 : 11:39:51
|
| Are there additional steps that need to be taken if I would like to change my Windows Server name which already has SQL2000 installed. I'm sure I can just change the Windows server name and upon reboot SQL will automatically see the change and take upon the new name, however I would just like to confirm this and if there are any additonal steps that I need to take please let me know... I don';t believe I would have to uninstall SQL2000 prior to renaming the Windoes server name..Please let me know..Thanks,Jay999 |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-07-08 : 11:58:36
|
| You need to run the SQL Server setup after changing the OS name. It's not going to install any thing. It will change the files to detect the new name. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-08 : 12:18:51
|
| Actually, you do not need to run SQL Server setup after changing the machine name. You only had to do that in SQL 7. In SQL 2000, you only need to run sp_dropserver followed by sp_addserver.Tara |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-08 : 18:13:09
|
In addition to doing the below to update @@SERVERNAMEsp_dropserver 'oldname' go sp_addserver 'newname','local'go you need to update sysjobs to reflect the new nameif you have any jobs set up. You can use the following procedure to do that [url]http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
|
|
Changing Names