SQL Server System Rename

On the surface, a SQL Server system rename may appear simple. You rename the underlying Windows box and SQL will automatically use the new name.

While that is true for many features in SQL server, there are quite a few items that need help migrating to a new server name. Fortunately many dependencies can be resolved by following instructions provided by Microsoft to update the @@SERVERNAME.

Note that Maintenance Plans are one of the most difficult items to fix. The default “local server” connections will still be hard-coded to point to the old server name. A script is provided in the user comments section of the above Microsoft article to fix these hard-coded “local server” connections. Please make sure that you use the script posted to the article for *your version of SQL Server*. These maintenance plan packages are in different system database locations depending on your SQL Server release.

Good luck with your SQL Server rename troubleshooting! You may also find the following Stack Exchange posts useful.

About notesbytom

Keeping technology notes on WordPress.com to free up my mind to solve new problems rather than figuring out the same ones repeatedly :-).
This entry was posted in Database and tagged . Bookmark the permalink.

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