SQL Server Performance Forum – Threads Archive
Is there a way to distribute EM registrations ?
Is there a way to distribute EM registrations ?<br /><br />We are getting all our clients reinstalled [B)]<br /><br />Can I save and recall my EM settings and/or distribute them to other dba-s. [?]<br /><br />I’ve got 100+ registered servers at diffirent (sub)domains (sqlserver groups) and windows-domains. [B)]<br /><br />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=’‘ />]<br /><br />That only gives me the servergroups, but no actual server appears [xx(]<br /><br /><br />tiaWhat 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]<br /><br /<a target="_blank" href=http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137167&p=2>http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137167&p=2</a><br /><br />
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!<br />Man, how time goes by…<br />Was it really on SQL 7? I thought it was yesterday? [<img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />]<br /><br />———————–<br />–Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />———————–<br />
]]>