SQL Server Performance

Host name

Discussion in 'Analysis Services/Data Warehousing' started by california6, Feb 11, 2008.

  1. california6 New Member

    Is AS - 2000 host name dependent? I.E, If I change the hostname - will AS be able to run after?
    Thanks,
  2. Akthar New Member

    i think you will have to go through
    Sp_dropserver and sp_addserver if you change hostname
  3. satya Moderator

    All of the SQL server services are dependant on the host name that means on the local server name, in this case you have to follow what Akthar referred.
  4. california6 New Member

    Clear SQL Services are name dependent. But not sure, how could we run sp_addserver on a Analysis Server 2000?
  5. satya Moderator

    Ok, I just missed this is analysis services and in your case you have to uninstall and reinstall the AS services for the change of hostname.
  6. california6 New Member

    Thank you Satya for the clarification. Will do the same.

Share This Page