Only see groups in Enterprise Manager

I have to export the servers registered in Enterprise Manager and import the
servers into another 30 machines. I exported the registry of
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
but when I import it, I only see the groups. Tried install and uninstall
enterprise manager but not helping.
thanks, larryYou may have to do it manually, and if so, the approach you're taking may
not be practical.
You could run profiler while setting up a registration, and see if it would
be possible to replicate the code that EM uses for the wizard and make it
programmable. I'm not sure if that will give you everything you need, since
some things might happen outside of the visibility of profiler.
I believe I read once that the sqldiag utility (located in the BINN folder)
will export registrations, but unless there's some undocumented argument I
haven't tried, I can only get it to store aliases (not registrations).
Do all 30 servers really need registrations to every single server? Are
they all round robin, so when you connect to manage all of them, you could
be on any node?
If not, you might consider reserving one or two "control" servers for
management, and not expecting to manage any server from any server.
If the servers just need to see each other (e.g. for queries) then it might
be better to just create aliases (if they're not DNS'able) and linked
servers (which are programmable) on all of the servers.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"LarryLiMCDBA" <larryliwork@.hotmail.com> wrote in message
news:OAm0Xqt1DHA.2972@.TK2MSFTNGP09.phx.gbl...
> I have to export the servers registered in Enterprise Manager and import
the
> servers into another 30 machines. I exported the registry of
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X
> but when I import it, I only see the groups. Tried install and uninstall
> enterprise manager but not helping.
> thanks, larry
>|||By the way, registrations are user-based. Are you logging into the
destination machine with the same user as the source machine? It might be
that user-specific information is encoded in the data stored in those
registry values... so if you connect to Enterprise Manager as a different
user, or with SQL Server authentication, you might not see those
registrations.
Look in the registry of the destination machine and see which user your
registrations appear under. If the .reg file ran without error, they're
probably there somewhere.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"LarryLiMCDBA" <larryliwork@.hotmail.com> wrote in message
news:OAm0Xqt1DHA.2972@.TK2MSFTNGP09.phx.gbl...
> I have to export the servers registered in Enterprise Manager and import
the
> servers into another 30 machines. I exported the registry of
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X
> but when I import it, I only see the groups. Tried install and uninstall
> enterprise manager but not helping.
> thanks, larry
>|||I tried both HKEY local machine and HKEY current user but couldn't make it
work. I was able to import the alias though and SQL Query Analyzer actually
works. I guess there is a encryption process somewhere for the registered
servers in EM.
tks, larry
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%2300Ai9u1DHA.2328@.TK2MSFTNGP10.phx.gbl...
> By the way, registrations are user-based. Are you logging into the
> destination machine with the same user as the source machine? It might be
> that user-specific information is encoded in the data stored in those
> registry values... so if you connect to Enterprise Manager as a different
> user, or with SQL Server authentication, you might not see those
> registrations.
> Look in the registry of the destination machine and see which user your
> registrations appear under. If the .reg file ran without error, they're
> probably there somewhere.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "LarryLiMCDBA" <larryliwork@.hotmail.com> wrote in message
> news:OAm0Xqt1DHA.2972@.TK2MSFTNGP09.phx.gbl...
> > I have to export the servers registered in Enterprise Manager and import
> the
> > servers into another 30 machines. I exported the registry of
> > HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > Server\80\Tools\SQLEW\Registered Servers X
> >
> > but when I import it, I only see the groups. Tried install and
uninstall
> > enterprise manager but not helping.
> >
> > thanks, larry
> >
> >
>