Re: Migrating to new domain

From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 22:58:40 +0100

GG wrote:

> We are migrating to a new domain. Some clients running SQL
> Enterprise manager have been migrated to a different domain than the
> one the actually SQL server is in. When the clients were migrated
> they had to reregister their servers in Enterprise manager. Where is
> the list of servers stored that the client had registered? Registry
> key perhaps? If so which one? I would like to retain the list that
> the client had registered or at least be able to tell them where they
> can get the list.
>
> I can retrieve a list of servers via sqldmo but only ones that are in
> the new domain because my machine exist in the new domain.

The SQL Servers groups with registered servers lists are usually stored in
HKCU\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered
Servers X

But I am not sure whether you can just export/import the registry keys to
the different domain, never tried this.

sincerely, 

--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Enterprose Manager after user password change
    ... XP client machines with a non-Domain account. ... > registered servers when the user's network password is changed. ... Saving the keys and restoring ... > password should be written to the registry. ...
    (microsoft.public.sqlserver.security)
  • Re: osql -L
    ... My colleague and I had also discussed the possibility of different subnets ... DMO and list the servers. ... > -L will show all server aliases hat are defined on the client using the ... You probably have different lists there.... ...
    (microsoft.public.sqlserver.tools)
  • Re: D-Link: incompetent or evil?
    ... it's only one in a list of servers. ... which they're clearly failing to even contemplate. ... In the design stage, one has to ask ``what does this depend on?''. ... hardcoded lists are clearly failing the test of ``can we easily change ...
    (comp.unix.bsd.freebsd.misc)
  • Re: WINS Setup Issue
    ... First of all if you disable the computer browser service on ... network and get their local lists. ... > all servers such as our WINS, DHCP, DNS etc., are located on the ... > network and the other 2 sites only house computers and printers. ...
    (microsoft.public.windows.server.networking)
  • Re: challenge: end of life for 6.2 is premature with buggy 6.3
    ... They started with shared hosting and moved to a dedicated box when I volunteered to help with the backend work. ... For several years we ran one server hosting dns, imaps, smtps, mail lists and websites. ... We now have the embarrassment of riches of two servers; one for web and the old one for the rest. ... and doesn't guarantee zaroo bugs - just a high likelihood ...
    (freebsd-stable)