SQL Registration

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eric,

On ServerA SQL Server 7.0 is running, i cahaged the Server name to ServerB. I tried to register with the new name (ServerB) in SQL Server 7.0, it is not registring.

what is the process, if chanage the server name to re register with the new name in SQL Server.

Thanks, Ravi.

-- Anonymous, November 27, 2001



Re-run setup and chose "upgrade" which is a fast operation that corrects some entries, then makes SQL Server start again. (You won't lose your databases.) Then use:

EXEC sp_dropserver EXEC sp_addserver , LOCAL

to reflect the new name in system tables.

Good Luck,


-- Anonymous, November 27, 2001

Moderation questions? read the FAQ