Server name changed for SQL7

• chantima

  Old Hand

  Points: 351

  More actions

  August 20, 2001 at 8:15 am

  #157665

  I wonder if anyone have ever changed the name of NT4 server with SQL7 running. I stopped sql service and set it to manual. Changed the server name then restart the sql service and got this message " Your SQL Server installation is either corrupt or has been tampered with (unknown package id). Please rerun Setup". If I changed the name back to the old one the service and related application would start just fine. Any Suggestion.

  TIA

  chantima

  chantima

  
  chantima

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736173

  More actions

  August 20, 2001 at 12:09 pm

  #417689

  You need to change the server name in SQL.

  Use sp_dropserver, sp_addserver with the LOCAL option.

  Steve Jones

  steve@dkranch.net