Home > IT Answers > SQL Server > Add/Rename SQL Server 2005 Server Name
Itspirit
45 pts.
 Add/Rename SQL Server 2005 Server Name
SQL Server 2005, SQL Server, 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
ASKED: Sep 21, 2011  7:33 AM GMT
UPDATED: March 31, 2012  3:49:01 PM GMT
RELATED QUESTIONS
Mrdenny
63,630 pts.
Answer Wiki:
What shows up when you query the sys.servers catalog view?
Last Wiki Answer Submitted:  Sep 21, 2011  8:32 AM (GMT)  by  Mrdenny   63,630 pts.
To see other 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.
 

[...] 10. Have any help for a member looking to add/rename SQL Server 2005 server name? [...]

The Most-Watched IT Questions: October 4, 2011 - ITKE Community Blog
 0 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
Mrdenny
 63,630 pts.