Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    United States
    Provided Answers: 1

    Unanswered: Server re-name ??

    How to RENAME the SQL server if the Work Station name is changed after the SQL Server installation. I have seen ppl. saying that we should use sp_dropserver and sp_addserver, but if the SQL server is not running how can u run these SP's ???
    >> Learn PHP/MySQL for free
    >> Free Web Hosting with PHP, MySQL, Website Builder :

  2. #2
    Join Date
    Jul 2003
    The Dark Planet
    Verbatim from the Holy Book (SQL Server Books Online)
    Renaming a Server
    When you change the name of the computer that is running Microsoft® SQL Server™ 2000, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name.

    You can connect to SQL Server using the new computer name after you have restarted the server. However, to correct the sysservers system table, you should manually run these procedures:

    sp_dropserver old_name
    sp_addserver new_name, local
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Dec 2002
    One other issue that I ran into when doing this (dunno if the sp_dropserver fixes it). All the jobs that I had set up under the old server name became Target Server jobs (MSX/TSX) and I could not modify them. I think I managed to change them back to "normal" jobs by editing the sysjobs table (originating_server) directly.

    It was an unpleasant surprise in an otherwise smooth migration.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts