Renaming a SQL 2005 server

32,960 pts.
Tags:
SQL 2005
SQL Server 2005
What considerations and procedures should be followed when renaming a Windows server that is hosting SQL 2005? Previous testing has shown considerable applicaiton problems after a system rename. Thanks for the guidance.
ASKED: April 3, 2009  5:54 PM
UPDATED: September 21, 2011  7:40 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

After you rename the server normally, connect to the SQL Server and run the following.

<pre>exec sp_dropserver ‘OldServerName’
go
exec sp_addserver ‘NewServerName’, ‘LOCAL’
go</pre>

Then restart the SQL Server Service.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Labnuke99
    I knew you would come through for me. Thanks for the help!
    0 pointsBadges:
    report
  • Denny Cherry
    No problem.
    65,450 pointsBadges:
    report
  • itspirit
    exec sp_dropserver 'OldServerName' go exec sp_addserver 'NewServerName', 'LOCAL' go I am trying to rename server name through above to stored procedures but i am unable to login. I rebooted system but unable to log with new server name
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following