Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 29 replies
  • Subscribers 1 subscriber
  • Views 25683 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

    Aha, that's the problem, well it's a problem, I can't say it's the only one at this point.

    Can you check that

    1. On the computer: "SQLSERVER", there is a Windows group called "Sophos DB Admins"?
    2. The user "DELL\SophosManagement" is a member of the group.

    If the group didn't exist, you can create it and add 'DELL\SophosManagement" to it.

    Then on "SQLSERVER" run the 3 commands::

    sqlcmd -E -S .\SOPHOS -Q "DROP LOGIN [SQLSERVER\Sophos DB Admins]"

    sqlcmd -E -S .\SOPHOS -Q "CREATE LOGIN [SQLSERVER\Sophos DB Admins] FROM WINDOWS"

    sqlcmd -E -S .\SOPHOS -d SOPHOS47 -i C:\ResetUserMappings.sql

    Note: For the last command, the SQL file can be obtained from here: http://sophserv.sophos.com/repo_kb/111898/file/ResetUserMappings.sql.txt

    If you download that and rename the file to ResetUserMappings.sql and copy it into C:\ the first command will run.

    Once this is done, can you attempt, again on "SQLSERVER":

    runas /user:dell\SophosManagement cmd

    In the command prompt that is launched as dell\sophosmanagement run:

    SQLCMD -E -S .\sophos -d SOPHOS47 -Q "exec dbo.SDDMBootstrapDataGet"

    Does that now work?

    Regards,

    Jak

    :29025
Reply
  • 0

    Aha, that's the problem, well it's a problem, I can't say it's the only one at this point.

    Can you check that

    1. On the computer: "SQLSERVER", there is a Windows group called "Sophos DB Admins"?
    2. The user "DELL\SophosManagement" is a member of the group.

    If the group didn't exist, you can create it and add 'DELL\SophosManagement" to it.

    Then on "SQLSERVER" run the 3 commands::

    sqlcmd -E -S .\SOPHOS -Q "DROP LOGIN [SQLSERVER\Sophos DB Admins]"

    sqlcmd -E -S .\SOPHOS -Q "CREATE LOGIN [SQLSERVER\Sophos DB Admins] FROM WINDOWS"

    sqlcmd -E -S .\SOPHOS -d SOPHOS47 -i C:\ResetUserMappings.sql

    Note: For the last command, the SQL file can be obtained from here: http://sophserv.sophos.com/repo_kb/111898/file/ResetUserMappings.sql.txt

    If you download that and rename the file to ResetUserMappings.sql and copy it into C:\ the first command will run.

    Once this is done, can you attempt, again on "SQLSERVER":

    runas /user:dell\SophosManagement cmd

    In the command prompt that is launched as dell\sophosmanagement run:

    SQLCMD -E -S .\sophos -d SOPHOS47 -Q "exec dbo.SDDMBootstrapDataGet"

    Does that now work?

    Regards,

    Jak

    :29025
Children
No Data