This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Domain name migration questions

Hello Sophos !

In the framework of domain migration, we need to move both Sophos Management server and Sophos database installed on two separate virtual machines.

For now, there is a trust relationship between the two domains.

We "just" want to change domain name, server name and IP address will remain the same for both server.

And, we want to use the same separate virtual servers -> so doesn't want to move from an OLD server to a NEW server.

We found following article regarding "Changing Domain Name"

https://sophos.com/kb/119532

Sophos support also send this but this is not relevant as we do not want to do a server to server migration

http://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_mgeng.pdf?la=en

1/ We will follow steps describe in article ID 119532 by saving CertAuthStor registry key, removing all Sophos components existing on Management Server (including Sophos AV / AutoUpdate / RMS / Update Manager / Sophos Console / Management server) and delete Sophos registry key  (HKLM\Software\[Wow6432Node]\Sophos\)

2/ Regarding Database server (using SQL Server 2005 for info), do we need to follow some specific instructions?

Do we need to remove Sophos Database component and re-install after the change of domain name?

3/ Still regarding the db server, the existing account used by management server to connect to the remote database will need to be changed as well.

In OLDDOMAIN, it is called OPEUSOPHOSADMIN (OLDDOMAIN\OPEUSOPHOSADMIN)

IN NEWDOMAIN, the same account is already created NEWDOMAIN\OPEUSOPHOSADMIN.

Do we need to include the NEWDOMAIN account in some specific group? or/and do we need to do some specifics SQL stuff?

4/ After domain name change applied on both server, we plan to import saved registry key and then to reinstall Sophos Management/Console normally, but using the NEWDOMAIN\OPEUSOPHOSADMIN account for database connection.

Excepted questions raised above, what do you think of this high-level plan?

Thank you for your support!

Regards,

Fabrice.

:53989


This thread was automatically locked due to age.
Parents
  • Hello!

    I was running the following command in order to list all database files

    sqlcmd -E -S (local)\SOPHOS -Q "SELECT name, filename from sysdatabases" > c:\databases.txt

    i got this:

    AuditStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\AuditStore_Data.MDF
    AlertStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\AlertStore_Data.MDF
    GeneralStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\GeneralStore_Data.MDF
    SecurityStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\SecurityStore_Data.MDF
    PolicyStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\PolicyStore_Data.MDF
    ReportStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\ReportStore_Data.MDF
    SavexCnfg E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexCnfg.mdf
    SavexDir E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexDir.mdf
    SavexQuar E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexQuar.mdf
    SavexRprt E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexRprt.mdf
    SOPHOS50 E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SOPHOS50.mdf
    SOPHOSPATCH E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SOPHOSPATCH.mdf

    Except SOPHOS50 and SOPHOSPATCH, are all the others related to NAC product?

    We are not using NAC anymore.

    How can i remove these databases which are taking a large disk space?

    Thank you for your help.

    Regards,

    Fabrice

    :54021
Reply
  • Hello!

    I was running the following command in order to list all database files

    sqlcmd -E -S (local)\SOPHOS -Q "SELECT name, filename from sysdatabases" > c:\databases.txt

    i got this:

    AuditStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\AuditStore_Data.MDF
    AlertStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\AlertStore_Data.MDF
    GeneralStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\GeneralStore_Data.MDF
    SecurityStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\SecurityStore_Data.MDF
    PolicyStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\PolicyStore_Data.MDF
    ReportStore E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\ReportStore_Data.MDF
    SavexCnfg E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexCnfg.mdf
    SavexDir E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexDir.mdf
    SavexQuar E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexQuar.mdf
    SavexRprt E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SavexRprt.mdf
    SOPHOS50 E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SOPHOS50.mdf
    SOPHOSPATCH E:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\data\SOPHOSPATCH.mdf

    Except SOPHOS50 and SOPHOSPATCH, are all the others related to NAC product?

    We are not using NAC anymore.

    How can i remove these databases which are taking a large disk space?

    Thank you for your help.

    Regards,

    Fabrice

    :54021
Children
No Data