Friday, February 24, 2012

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?
Thanks
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 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[vbcol=seagreen]
>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...
information
>
>
>.
>
|||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...[vbcol=seagreen]
> 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
> shared.
> that you registered
> information

No comments:

Post a Comment