Re: Is possible to import registered SQL Servers to another Enterprise Manager

From: Amin Sobati (Amins_at_morva.net)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 23:56:20 +0430

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
> >
> >
> >
> >
> >.
> >

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
    (microsoft.public.security)
  • Minimum rights for SQL Agent
    ... SQL 2000 servers on Win 2000 servers in NT4 Domain ... registries. ... The SQL agent and SQL Server service accounts should NOT be Local or Domain ...
    (microsoft.public.sqlserver.security)