Is possible to import registered SQL Servers to another Enterprise Manager

Hi,
Is it possible to export registered SQL Server information
and import it to the Enterprise Manager on the other
server?
ThanksHi Alan,
Go to Enterprise Manager>Tools Menu>Options
Clear checkbox for Read/Store user...
Register required servers. Now these registrations can be shared.
From other computer in your network, goto:
Enterprise Manager>Tools Menu>Options
Choose "Read from remote" and enter the name of computer that you registered
servers in step above.
The settings must appear in your Enterprise Manager.
Amin
"Alan" <SQL@.discussions.microsoft.com> wrote in message
news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> Hi,
> Is it possible to export registered SQL Server information
> and import it to the Enterprise Manager on the other
> server?
> Thanks|||Hi Amin,
Thanks. But I need to copy remote registries and store it
locally. I tried exporting from the registry
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X\SQL Server
Group], but only groups show up, not individual sql
server. So there're some other information stored
somewhere needed but I couldn't identify them.
Thanks
Alan
>--Original Message--
>Hi Alan,
>Go to Enterprise Manager>Tools Menu>Options
>Clear checkbox for Read/Store user...
>Register required servers. Now these registrations can be
shared.
>From other computer in your network, goto:
>Enterprise Manager>Tools Menu>Options
>Choose "Read from remote" and enter the name of computer
that you registered
>servers in step above.
>The settings must appear in your Enterprise Manager.
>Amin
>
>"Alan" <SQL@.discussions.microsoft.com> wrote in message
>news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
>> Hi,
>> Is it possible to export registered SQL Server
information
>> and import it to the Enterprise Manager on the other
>> server?
>> Thanks
>
>
>.
>|||Alan,
I exported:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Deleted servers and imported that file. Everything was ok when I opened
EM(individual servers appeared again).
Is it what you need to do?
By the way, have a look to this address:
HKEY_USERS\S-1-5-21-1482476501-842925246-854245398-500\Software\Microsoft\Mi
crosoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
Amin
<anonymous@.discussions.microsoft.com> wrote in message
news:0f0f01c49f37$92cf66e0$7d02280a@.phx.gbl...
> Hi Amin,
> Thanks. But I need to copy remote registries and store it
> locally. I tried exporting from the registry
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group], but only groups show up, not individual sql
> server. So there're some other information stored
> somewhere needed but I couldn't identify them.
> Thanks
> Alan
> >--Original Message--
> >Hi Alan,
> >Go to Enterprise Manager>Tools Menu>Options
> >Clear checkbox for Read/Store user...
> >Register required servers. Now these registrations can be
> shared.
> >From other computer in your network, goto:
> >Enterprise Manager>Tools Menu>Options
> >Choose "Read from remote" and enter the name of computer
> that you registered
> >servers in step above.
> >The settings must appear in your Enterprise Manager.
> >Amin
> >
> >
> >
> >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> >> Hi,
> >>
> >> Is it possible to export registered SQL Server
> information
> >> and import it to the Enterprise Manager on the other
> >> server?
> >>
> >> Thanks
> >
> >
> >
> >
> >.
> >|||Hi Alan
I've got the same problem (empty tree structure after export & import)
If you look in the regesutry you'll see that the individual servers are
listed as keys but the key values are binary values (displayed in hex). I
wonder if these values (server login details) are encrypted and therefore
cant be read when imported to another machine?
Steve
"anonymous@.discussions.microsoft.com" wrote:
> Hi Amin,
> Thanks. But I need to copy remote registries and store it
> locally. I tried exporting from the registry
> [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> Group], but only groups show up, not individual sql
> server. So there're some other information stored
> somewhere needed but I couldn't identify them.
> Thanks
> Alan
> >--Original Message--
> >Hi Alan,
> >Go to Enterprise Manager>Tools Menu>Options
> >Clear checkbox for Read/Store user...
> >Register required servers. Now these registrations can be
> shared.
> >From other computer in your network, goto:
> >Enterprise Manager>Tools Menu>Options
> >Choose "Read from remote" and enter the name of computer
> that you registered
> >servers in step above.
> >The settings must appear in your Enterprise Manager.
> >Amin
> >
> >
> >
> >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> >> Hi,
> >>
> >> Is it possible to export registered SQL Server
> information
> >> and import it to the Enterprise Manager on the other
> >> server?
> >>
> >> Thanks
> >
> >
> >
> >
> >.
> >
>|||I've sussed thats there's 2 seperate sets of entries for server regs in Ent
Manager:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
and
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Any entries in the second location are shown if you untick the "user
independent option" i.e this tick box tells EM whether to look in
HKEY_CURRENT_USER (private) or HKEY_LOCAL_MACHINE (shared).
Question is how do you copy all the entries from the private structure into
the publick one?
Steve
"Amin Sobati" wrote:
> Alan,
> I exported:
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\80\Tools\SQLEW\Registered Servers X
> Deleted servers and imported that file. Everything was ok when I opened
> EM(individual servers appeared again).
> Is it what you need to do?
> By the way, have a look to this address:
> HKEY_USERS\S-1-5-21-1482476501-842925246-854245398-500\Software\Microsoft\Mi
> crosoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group
> Amin
> <anonymous@.discussions.microsoft.com> wrote in message
> news:0f0f01c49f37$92cf66e0$7d02280a@.phx.gbl...
> > Hi Amin,
> >
> > Thanks. But I need to copy remote registries and store it
> > locally. I tried exporting from the registry
> > [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> > Server\80\Tools\SQLEW\Registered Servers X\SQL Server
> > Group], but only groups show up, not individual sql
> > server. So there're some other information stored
> > somewhere needed but I couldn't identify them.
> >
> > Thanks
> > Alan
> >
> > >--Original Message--
> > >Hi Alan,
> > >Go to Enterprise Manager>Tools Menu>Options
> > >Clear checkbox for Read/Store user...
> > >Register required servers. Now these registrations can be
> > shared.
> > >From other computer in your network, goto:
> > >Enterprise Manager>Tools Menu>Options
> > >Choose "Read from remote" and enter the name of computer
> > that you registered
> > >servers in step above.
> > >The settings must appear in your Enterprise Manager.
> > >Amin
> > >
> > >
> > >
> > >"Alan" <SQL@.discussions.microsoft.com> wrote in message
> > >news:1ee101c49ce0$f66a5e70$3a01280a@.phx.gbl...
> > >> Hi,
> > >>
> > >> Is it possible to export registered SQL Server
> > information
> > >> and import it to the Enterprise Manager on the other
> > >> server?
> > >>
> > >> Thanks
> > >
> > >
> > >
> > >
> > >.
> > >
>
>
>