Renaming SQL Server - SQL Server Forums

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)

Renaming SQL Server

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-24 : 01:24:22

Jason writes "Hello,

Can you please advise how I can RENAME SQL Server. I believe that there are either SQL Admin Tools or SQL Scripts that can allow a DBA to achieve this, please HELP."

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-24 : 08:22:27

You're renaming the server itself not SQL Server

On SQL 7 :
Rename server
Reboot
SQL claims its been "tampered with"

Rerun sql server setup (this won't install anything)
start sql service

run the following in QA

use master
go

sp_dropserver 'oldservername'
go
sp_addserver 'newservername','local'
go

On SQL 2000 :
Rename server
Reboot

run the following in QA

use master
go

sp_dropserver 'oldservername'
go
sp_addserver 'newservername','local'
go

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources