Geeks With Blogs

Disclaimer: The views expressed on this blog are my own and do not necessarily reflect the views of my employer.

Creative Commons License

Check out my profile!

INETA Community Speakers Program

Follow enriquelima on Twitter
Locations of visitors to this page

Intentional Thinking Enrique Lima

Hopefully you don’t deal with this often.  But if it does happen.  A couple of things to keep in mind.  The steps to 1) rename a server 2) potentially needing to transfer logins.  Mind you my reference and examples here are for Stand-alone Instances.

There are at least 2 options for each.  The ones that paid off for me are:


sp_dropserver <old_name>


sp_addserver <new_name>, local


Followed by a:


Reference from:

Transfer of Logins

I found the following article to be helpful and effective.

Posted on Wednesday, June 8, 2011 9:41 PM SQL Server | Back to top

Comments on this post: Dealing with SQL Server renames and moves

comments powered by Disqus

Copyright © Enrique Lima | Powered by: