Re: Is possible to import registered SQL Servers to another Enterp
From: Steve Morgan (SteveMorgan_at_discussions.microsoft.com)
Date: 11/24/04
- Next message: Uri Dimant: "Re: Transaction Log Size"
- Previous message: Des FitzGerald: "Re: Can't detach database"
- Maybe in reply to: Steve Morgan: "Re: Is possible to import registered SQL Servers to another Enterp"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 06:37:09 -0800
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
> > >
> > >
> > >
> > >
> > >.
> > >
>
>
>
>
>
- Next message: Uri Dimant: "Re: Transaction Log Size"
- Previous message: Des FitzGerald: "Re: Can't detach database"
- Maybe in reply to: Steve Morgan: "Re: Is possible to import registered SQL Servers to another Enterp"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
