SQL Server Performance Forum – Threads Archive

Is there a way to distribute EM registrations ?

Is there a way to distribute EM registrations ? We are getting all our clients reinstalled [B)] Can I save and recall my EM settings and/or distribute them to other dba-s. [?] I’ve got 100+ registered servers at diffirent (sub)domains (sqlserver groups) and windows-domains. [B)] I’ve tested export of regestry keys "registered servers x" and "MSSQLserver" (with subkeys), but that did not do the trick [<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />] That only gives me the servergroups, but no actual server appears [xx(] tia

What went wrong?
Usually when you export HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server80ToolsSQLEWRegistered Servers X and import it on the target machine it should work.
———————–
–Frank
http://www.insidesql.de
———————–

As specified by Frank save that registry key and restore on the target machine in order to get the server details, I never had such issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I’ll do some more testing.
Until now, it did not work.
I’ll have my dev-machine reinstalled to start with a clean solution.

There is a nice SQLDMO solution which avoids the encrypted registry settings: [^][<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />][8D] http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137167&p=2</a>

Appreciate your interest in sharing the tip, but did you get that SQLDMO script to save the registration. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Cute! Man, how time goes by… Was it really on SQL 7? I thought it was yesterday? [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] ———————– –Frank http://www.insidesql.de</a> ———————–

]]>