Post reply

Change IP Address, Host Name of SQL SERVER 2000

  • November 30, 2007 at 2:26 pm

    #184514

    MY company is going to change the IP address and HostName of Server where SQL 2000 is running. What is the impact to SQL 2000 Server? Will SQL2000 come back sucessfully? :blink: Do I have to do anything before and after? Pls help me, Thanks a lot for your help.

  • November 30, 2007 at 5:58 pm

    #756190

    Is your sql server clustered? or it is a standalone default or named instance?

    Razi, M.
    http://questivity.com/it-training.html

  • November 30, 2007 at 6:20 pm

    #756194

    SQL Server 2000 is a statndalone with default instance. Thank you.

  • December 1, 2007 at 11:50 am

    #756246

    The IP doesn't matter. SQL Server will bind to the host's ip.

    The name does matter. You need to run

    sp_dropserver

    sp_addserver , local

    and then restart SQL server.

  • December 1, 2007 at 12:47 pm

    #756251

    Thanks Steve! I was thinking that if it a clustered server then each individual instance will have its own IP address.

    Regards,

    Razi, M.
    http://questivity.com/it-training.html

  • December 1, 2007 at 2:28 pm

    #756254

    In a cluster, each individual instance needs to be reset if those host names are changing. They will bind to the IP of that server.

    If the IP of the virtual server needs to change, then that would be manually changed.

  • December 1, 2007 at 7:37 pm

    #756265

    Thanks steve.

Viewing 7 posts - 1 through 6 (of 6 total)

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