Renaming a SQL 2K Server?

Question

Post reply

Renaming a SQL 2K Server?

Tyson-633393

Old Hand

Points: 333
More actions
February 19, 2008 at 1:04 pm

#71170

Just a quick question...
I have a SLQ 2K server on W2K. 55 databses. Would renaming the server name in Windows
affect the databases? Would I need to re-register the new name in SQL?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 1

After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.

use master

go

exec sp_dropserver 'old server name'

go

sp_addserver 'new server name', 'local'

go

Tommy

Follow @sqlscribe

Tyson-633393 Old Hand Points: 333 More actions · Answer 2

Tyson-633393

Old Hand

Points: 333

February 19, 2008 at 1:24 pm

#779893

Yes. I did find this in the forums.

Thx.

Tyson-633393 Old Hand Points: 333 More actions · Answer 3

Actually, one more quest...I had to rebuild the server a few weeks ago on a new box.

The new server was built on a node name caled sqltest. After I moved the databases from the old server to the new server, I renamed the node name in Windows (on new server) back to sqlproduction. Do I need to run that query in SQL?

Thanks

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 4

A simple verification - on the server in question, execute a

select @@servername

If this returns the correct server name then you are all done. If not use the sp_dropserver, sp_addserver method to change the name.

Tommy

Follow @sqlscribe

Lester Policarpio SSCertifiable Points: 7109 More actions · Answer 5

Tommy Bollhofer (2/19/2008)
After renaming the Windows server, issue a sp_dropserver, sp_addserver and restart MSSQL services.
use master
go
exec sp_dropserver 'old server name'
go
sp_addserver 'new server name', 'local'
go

Just be aware that your current jobs may not function because of changing the server's name you can verify it with this query

SELECT *

FROM msdb..sysjobs

"-=Still Learning=-"

Lester Policarpio

Tyson-633393 Old Hand Points: 333 More actions · Answer 6

All good, query returned the correct node name.

Now I have an .idc error. When in the app that connects to the sql database, there is a link to IE that users click on to open IE.

The error is: 'unable to open http://servername/idi/scripts/distsumsetdirect.idc? Cannot download the information you requested'

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 7

You talked about node. Did you build your SQL Server on a cluster? A node is different from a name of an SQL Server on a cluster.