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

    If you add SophosManagement to the local administrators group on SQLSERVER, does the command work and the management service start?  It shouldn't need all those rights but it would at least get you running for the short term while we work out what's wrong.

    Otherwise, the contents of C:\SQLLogins.txt after running


    sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERVER\Sophos DB Admins'" > C:\SQLLogins.txt

    would be interesting to see.

    Regards,

    Jak

    :29037
Reply
  • 0

    If you add SophosManagement to the local administrators group on SQLSERVER, does the command work and the management service start?  It shouldn't need all those rights but it would at least get you running for the short term while we work out what's wrong.

    Otherwise, the contents of C:\SQLLogins.txt after running


    sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERVER\Sophos DB Admins'" > C:\SQLLogins.txt

    would be interesting to see.

    Regards,

    Jak

    :29037
Children
No Data