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

upgrade issues 5.2

hardwork

Hi

A while back I updated sophos 4.5 to 5.2, nightmare to put it mildly.

I initially updated to 5.1 expecting problems, but it worked straight away, so i thought that the small step to 5.2 would be no problem, but how wrong was I.

After trying every possible solution on sophos site, I eventually caved and uninstalled all the msql and sophos stuff and did fresh install, and luckily my backup worked and I got information back.

There where of course issues with account passwords and I never really got it back working completly due to some nodes updating with one password and other nodes updating with different credentials.

Anyway long story long, i have the same error appearing again and am almost back to uninstalling and reinstalling as the instructions on sophos site never seem to prevail for me.

Basically the sophos management host service will not start, like this : http://www.sophos.com/en-us/support/knowledgebase/116454.aspx

But the alter db command fails with "cannot alter the user 'sophos db admins' because it does not exist"

I am ready for the wild goose chase of trying to fix sophos!!

Can anyone help me get underway.

Thanks

:41923


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

    Hello hardwork,

    hm, can't figure out your exact problem - you say the sophos management host service will not start whereas 116454 refers to the managemt service (in which case you would be unable to start the console as well). If "only" the mangement host service fails you would be able to open the console but encounter and error with the Patch and Web Control event viewer.

    the alter db command fails

    when excuting ResetUserMappings.sql? - in which case (the username is not hardcoded but set with a SELECT) the remainder of the message (that you've left out) should apply or you do not have permission. Anyway

    sqlcmd -E -S .\Sophos -d SOPHOS52 -Q "SELECT * FROM sys.database_principals WHERE name = 'Sophos DB Admins'"

     shows whether the user exists or not.

    Christian

    :41925
Reply
  • 0

    Hello hardwork,

    hm, can't figure out your exact problem - you say the sophos management host service will not start whereas 116454 refers to the managemt service (in which case you would be unable to start the console as well). If "only" the mangement host service fails you would be able to open the console but encounter and error with the Patch and Web Control event viewer.

    the alter db command fails

    when excuting ResetUserMappings.sql? - in which case (the username is not hardcoded but set with a SELECT) the remainder of the message (that you've left out) should apply or you do not have permission. Anyway

    sqlcmd -E -S .\Sophos -d SOPHOS52 -Q "SELECT * FROM sys.database_principals WHERE name = 'Sophos DB Admins'"

     shows whether the user exists or not.

    Christian

    :41925
Children
No Data