Home > IT Answers > SQL Server > Renaming a SQL 2005 server
Labnuke99
32,735 pts.
 Renaming a SQL 2005 server
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.

Software/Hardware used:
ASKED: April 3, 2009  5:54 PM
UPDATED: September 21, 2011  7:40 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 4, 2009  10:55 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I knew you would come through for me. Thanks for the help!

Troy Tate
 0 pts.
 

No problem.

Denny Cherry
 64,550 pts.
 

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

itspirit
 45 pts.