Old Instance Name won't go away

• Richard Buchner, Chicago

  Ten Centuries

  Points: 1390

  More actions

  May 12, 2003 at 8:27 am

  #58967

  We moved one of our servers to a different location, store 3 to store 5. We renamed the server to Store5. Changed the SQL server registration in EM to Store 5.

  Some users have trouble getting into apps on store 5, they still see a refence to store5.

  The win2k sysadmin users has no problem.

  Any clues? are the Registry entires that need to change ?

  thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 12, 2003 at 8:32 am

  #456844

  Have you corrected the sysservers system table with procedures after renaming the server?

  sp_dropserver old_name

  GO

  sp_addserver new_name, local

  GO

  Use sp_helpserver to find out the server name.

  Edited by - Allen_Cui on 05/12/2003 08:32:50 AM

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 12, 2003 at 9:16 am

  #456856

  Maybe you should uninstall SQL server, and then reinstall it with the new instance name.