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

SEC reinstall over to change db un and pw failing.

S7_Edward

SEC 5.0.0.8

I am trying to reinstall the enterprise console over again to change the user and password used for the db. For some reason the install constantly fails. Any ideas?

:33587


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

    HI,

    Well I think I know what the problem is.

    It's down to the registy key(s) under:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    The installer is trying to de-obfuscate the password as stored in the registry.  Can you check that under:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    That those keys are expected?

    Do you have UseClearText set to 1?

    If your SQL instance is local to the Sophos Management Service, I.e. everything is installed on the same machine, the management service in SEC 4.x doesn't need to impersonate a user to access the database.  It does in SEC 5. but during the upgrade you will be prompted for a database account.  

    So you could, do a backup first of the DatabaseUser key to be safe, then delete:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    then perform the upgrade.  When installing 5 it will just ask you for the account again.

    THis KBA is related:

    http://www.sophos.com/en-us/support/knowledgebase/116519.aspx

    Regards,

    Jak

    :33619
Reply
  • 0

    HI,

    Well I think I know what the problem is.

    It's down to the registy key(s) under:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    The installer is trying to de-obfuscate the password as stored in the registry.  Can you check that under:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    That those keys are expected?

    Do you have UseClearText set to 1?

    If your SQL instance is local to the Sophos Management Service, I.e. everything is installed on the same machine, the management service in SEC 4.x doesn't need to impersonate a user to access the database.  It does in SEC 5. but during the upgrade you will be prompted for a database account.  

    So you could, do a backup first of the DatabaseUser key to be safe, then delete:

    hklm\software\[wow6432node]\sophos\EE\Management Tools\DatabaseUser\

    then perform the upgrade.  When installing 5 it will just ask you for the account again.

    THis KBA is related:

    http://www.sophos.com/en-us/support/knowledgebase/116519.aspx

    Regards,

    Jak

    :33619
Children
No Data