Changes in EM registration

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  February 5, 2003 at 1:31 pm

  #58915

  Hi to all:

  I have several SQL Server instances registered in my EM with the sa login and pass. We have to change the pass of the sa in all of our instances, and I want to know if there is a way to register or change a registration with T_SQL. I trace with profiler, but could'n see anything that would help me.

  thanks in advanced

• philcart

  SSC-Forever

  Points: 47794

  More actions

  February 5, 2003 at 2:54 pm

  #448131

  The servers registered in EM are stored in the registry at the following key,

  HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group

  It's a binary value so you probably wouldn't want to spend the time to change it there

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface