Thursday, 25 June 2009

Renaming the computer name of a SQL server machine

The name of the computer and the name of the server that SQL has must match. If not there might be some problems (mostly with replication)

To find the server name that is assosiated inside SQL server execute

if that name does not match with the computer name (not description), then we might have to do modify that in the SQL server. To do this,

sp_dropserver 'old_name'
sp_addserver 'new_name', 'local'

No comments:

Post a Comment