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

    Ahh,

    "1385: Logon failure: the user has not been granted the requested logon type at this computer."

    makes more sense now, I assume that SEC is on a DC, as SophosManagement is just a domain user it doesn't have rights by default to logon to a DC as you have to be an admin.

    On the SQL server (SQLSERVER), run:

    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"

    If the dell\sophosmanagement account has the correct rights to the SOPHOS47 database you should get:

    "<bootstrapData xmlns="http://www.sophos.com/xml/msys/bootstrapdata.xsd"><bootstr......"

    If it fails, what is the error?

    Regards,

    Jak

    :29005
Reply
  • 0

    Ahh,

    "1385: Logon failure: the user has not been granted the requested logon type at this computer."

    makes more sense now, I assume that SEC is on a DC, as SophosManagement is just a domain user it doesn't have rights by default to logon to a DC as you have to be an admin.

    On the SQL server (SQLSERVER), run:

    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"

    If the dell\sophosmanagement account has the correct rights to the SOPHOS47 database you should get:

    "<bootstrapData xmlns="http://www.sophos.com/xml/msys/bootstrapdata.xsd"><bootstr......"

    If it fails, what is the error?

    Regards,

    Jak

    :29005
Children
No Data