Is there a way to rename the default instance

• demonbane1

  Old Hand

  Points: 307

  More actions

  March 22, 2005 at 9:06 am

  #87867

  Hello all,

  I was wondering if there was a way to rename the default instance in MSSQL2000 without renaming the actual server?

• Steve-3_5_7_9

  SSChampion

  Points: 10832

  More actions

  March 23, 2005 at 5:03 am

  #548422

  I'm not sure if this will work.  I don't think so, because

  of the default instance being the servername.

  sp_dropserver 'OLD_NAME' 

  sp_adserver 'NEW_NAME', 'local'

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  March 23, 2005 at 10:21 am

  #548545

  Do not forget to stop and restart the SQL Server services as a last step.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."