Post reply

Renaming a SQL Server Instance

  • August 12, 2003 at 11:00 am

    #101619

    First question: Is it possible?

    Second question: How?

    Thank you.

  • August 12, 2003 at 12:22 pm

    #469624

    If it is default instance, you can rename it by change the machine name.

    If it is named instance, you have to uninstall and reinstall.

    Or create server alias (the name you like) in client workstation to point the instance name.

  • August 12, 2003 at 1:29 pm

    #469644

    Renaming a Server (From BOL)

    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

    GO

    sp_addserver new_name, local

    GO

    When you have more than one instance of SQL Server on the computer, change the sysservers system table information by running the stored procedures this way:

    sp_dropserver old_servername\instancename

    GO

    sp_addserver new_servername\instancename, local

    GO

    Also, if you have SQL jobs set up to run, then you need to run the following:

    UPDATE msdb.dbo.sysjobs

    SET originating_server = 'NewServerName'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply