Monday, February 20, 2012

Migrating to new domain

We are migrating to a new domain. Some clients running SQL Enterprise manag
er have been migrated to a different domain than the one the actually SQL se
rver is in. When the clients were migrated they had to reregister their ser
vers in Enterprise manager.
Where is the list of servers stored that the client had registered? Registr
y key perhaps? If so which one? I would like to retain the list that the c
lient 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 ne
w domain because my machine exist in the new domain.
Any help would be appreciated.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.|||Thank You Sabastian. That is a start. Much appreciated.

No comments:

Post a Comment