Add/Rename SQL Server 2005 Server Name

45 pts.
Tags:
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

Answer Wiki

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

What shows up when you query the sys.servers catalog view?

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
  • itspirit
    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
    45 pointsBadges:
    report
  • itspirit
    [...] 10. Have any help for a member looking to add/rename SQL Server 2005 server name? [...]
    0 pointsBadges:
    report
  • Denny Cherry
    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
    66,070 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