Home > IT Answers > SQL Server > Add/Rename SQL Server 2005 Server Name
itspirit
45 pts.
 Add/Rename SQL Server 2005 Server Name
SQL Server, SQL Server 2005, SQL Server name
Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ' for seeing current server name step 2. sp_dropserver 'ray' ' for deleting current server step 3. sp_addserver 'raynew', local ' for adding new servername step 4. select @@servername ' for seeing new servername added or not i am getting new server name but unable to login with this new server name i restarted sql services and restart system also but unable to login please help. Thanks Pardeep

Software/Hardware used:
ASKED: September 21, 2011  7:33 AM
UPDATED: March 31, 2012  3:49 PM
RELATED QUESTIONS
Answer Wiki:
What shows up when you query the sys.servers catalog view?
Last Wiki Answer Submitted:  September 21, 2011  8:32 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

After executing “Select * from sys.servers” query i am getting following view

1 RAYNEW SQL Server SQLNCLI RAYNEW NULL NULL NULL 0 0 0 1 1 0 0 1 NULL 0 0 0 0 0 0 2011-09-20 15:05:12.937

itspirit
 45 pts.
 

It didn’t get added as the local server. Are you sure to ran the sp_addserver with the ‘local’ parameter? Run the following then restart the SQL Server instance. That should do the trick. The server is added correctly when it has a server_id of 0.

exec sp_dropserver 'RAYNEW'
GO
EXEC sp_addserver 'RAYNEW', 'LOCAL'
GO
Denny Cherry
 64,505 pts.