Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 29 replies
  • Subscribers 1 subscriber
  • Views 25675 views
  • Users 0 members are here
Options
Suggested
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

Transfer SophosDB to remote server

tedz

Hi,

Need advice to transfer my sophosDB in a central console to remote server. 

Running SEC 4.7 

updrage to SEC 5.1 

what is the steps to do this? 

Regards,

tedz

:28377


This thread was automatically locked due to age.
Parents
  • 0

    Hi Jak,

    i am sorry for the confusion. i did configure everything from sratch doing it in a pilot network before implementing it this week making sure im doing the right thing. i appreciate your help.

    • Domain: RSA.com
    • SQL Server: SQLSERV
    • Both the management server and SQLServer are in the same RSA domain
    • SophosManagement is a domain account that can therefore be referenced RSA\SophosManagement
    • ran sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERV\Sophos DB Admins'"

    C:\>sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERV\Sop
    hos DB Admins'"
    LoginName                                        SID
                                                             DefDBName    DefLangNam
    e          AUser ARemote
    ------------------------------------------------ -------------------------------
    -------------------------------------------------------- ------------ ----------
    ---------- ----- -------
    SQLSERV\Sophos DB Admins                         0x01050000000000051500000041DE8
    9D282EEB6FB08C41F9AF4030000                              master       us_english
               yes   no

    (1 rows affected)
    LoginName                                        DBName           UserName
                                       UserOrAlias
    ------------------------------------------------ ---------------- --------------
    ---------------------------------- -----------
    SQLSERV\Sophos DB Admins                         SOPHOS47         Sophos DB Admi
    ns Role                            MemberOf
    SQLSERV\Sophos DB Admins                         SOPHOS47         SQLSERV\Sophos
     DB Admins                         User

    (2 rows affected)

    Sophos DB Admins is a local group on SQLSERV

    • 2 computers are in a domain then typically you would used a domain account.
    • SEC server and the SQL server is a member server in RSA domain and created "SophosManagement" account and entered the same account when running both installers."Sophos Management" account is member of "Sophos DB Admins" local group in the SQLSERV (SQL SERVER).

    heres the result from the cmd command i run from the SQLSERV

    C:\WINDOWS\system32>SQLCMD -E -S .\sophos -d SOPHOS47 -Q "exec dbo.SDDMBootstrap
    DataGet"


    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    ----------------
    <bootstrapData xmlns="http://www.sophos.com/xml/msys/bootstrapdata.xsd"><bootstr
    apCommand publisher="e6561447-b027-4bb9-a021-ba177a5c6287" subscriptionGroupId="
    9859529D-C32C-456B-9791-AE5F9AFB8C1B" siteId="DEFAULT" address="\\SECCONSOLE\Sop
    hosUpdate" addre

    currently the management service wont start. :(

    tried to do a UDL test from SQL SERVER to Management Server and its success.

    Thanks

    :29049
Reply
  • 0

    Hi Jak,

    i am sorry for the confusion. i did configure everything from sratch doing it in a pilot network before implementing it this week making sure im doing the right thing. i appreciate your help.

    • Domain: RSA.com
    • SQL Server: SQLSERV
    • Both the management server and SQLServer are in the same RSA domain
    • SophosManagement is a domain account that can therefore be referenced RSA\SophosManagement
    • ran sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERV\Sophos DB Admins'"

    C:\>sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERV\Sop
    hos DB Admins'"
    LoginName                                        SID
                                                             DefDBName    DefLangNam
    e          AUser ARemote
    ------------------------------------------------ -------------------------------
    -------------------------------------------------------- ------------ ----------
    ---------- ----- -------
    SQLSERV\Sophos DB Admins                         0x01050000000000051500000041DE8
    9D282EEB6FB08C41F9AF4030000                              master       us_english
               yes   no

    (1 rows affected)
    LoginName                                        DBName           UserName
                                       UserOrAlias
    ------------------------------------------------ ---------------- --------------
    ---------------------------------- -----------
    SQLSERV\Sophos DB Admins                         SOPHOS47         Sophos DB Admi
    ns Role                            MemberOf
    SQLSERV\Sophos DB Admins                         SOPHOS47         SQLSERV\Sophos
     DB Admins                         User

    (2 rows affected)

    Sophos DB Admins is a local group on SQLSERV

    • 2 computers are in a domain then typically you would used a domain account.
    • SEC server and the SQL server is a member server in RSA domain and created "SophosManagement" account and entered the same account when running both installers."Sophos Management" account is member of "Sophos DB Admins" local group in the SQLSERV (SQL SERVER).

    heres the result from the cmd command i run from the SQLSERV

    C:\WINDOWS\system32>SQLCMD -E -S .\sophos -d SOPHOS47 -Q "exec dbo.SDDMBootstrap
    DataGet"


    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    ----------------
    <bootstrapData xmlns="http://www.sophos.com/xml/msys/bootstrapdata.xsd"><bootstr
    apCommand publisher="e6561447-b027-4bb9-a021-ba177a5c6287" subscriptionGroupId="
    9859529D-C32C-456B-9791-AE5F9AFB8C1B" siteId="DEFAULT" address="\\SECCONSOLE\Sop
    hosUpdate" addre

    currently the management service wont start. :(

    tried to do a UDL test from SQL SERVER to Management Server and its success.

    Thanks

    :29049
Children
No Data