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
Friday, February 24, 2012
Is possible to import registered SQL Servers to another Enterprise Manager
Labels:
database,
enterprise,
export,
import,
informationand,
manager,
microsoft,
mysql,
oracle,
registered,
server,
servers,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment