Change Server Names - 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)

Change Server Names

Author

Topic

Jay1Jay
Yak Posting Veteran

50 Posts

Posted - 2003-03-19 : 14:38:54

I'm new to SQL and would appreciate any help given. I have 2 servers one NT4.0 and one Win2000 both running SQL 7.0, however due to company changes we need to change the NT server names of these servers. For example:

OS Current Server name New Server Name

NT4.0 John Prudo

2000 Tony London

Any suggestions or any problems will be appreciated.... Do I need to stop SQL server and simply change the name of the NT server or is there more involved..

Thanks,

Jay

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-19 : 14:45:38

You will have to run the SQL 7.0 setup to reconfigure the SQL Server name after you have changed the NETBIOS name of the server.

Then run

sp_dropserver oldname
go
sp_addserver newname, local

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources