Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Computer name Change

    Newbie Question. Please help.

    I need to change the computer name on the sql server 2000.
    What steps are involved after the computer name change.
    Thanks a bunch.

  2. #2
    Join Date
    Oct 2001
    Naples, FL
    If you use a domain account that has restricted login ability, you will need to add that account to the new computername to be able to login in AD.

    You will need to run sp_dropserver and sp_addserver (look in BOL for syntax)

    If you created jobs while the PC was named the old name you will need to update the originating server name in sysjobs to your new PC name.

    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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