Renaming a SQL Server

When you rename a computer where SQL Server is installed, clients can use the new name without any further reconfiguration, but sys.servers still contains the old name, and if you SELECT @@SERVERNAME you also get the old name. This causes problems with the BizTalk backup job. So you have to change the server name like this:

sp_dropserver ‘old name’
sp_addserver ‘new name’, ‘LOCAL’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s