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

    Hi  I was unable to reply with my account as I kept getting taken to another page helpfully.

    Anyway back to the story..

    Please check that the Sophos Management Host service is running, otherwise see KBA 118513 I got that message originally,  but ater looking at the log I found:


    Login failed for user 'domain\SophosManagement'. Reason: Failed to open the explicitly specified database.

    WHich led me to that previous knowledge base which says:

    Confirm a SID mismatch between the SQL and Windows groups by running the following command (Change DOMAIN to match the location of the Sophos DB Admins group):
    sqlcmd -E -S .\SOPHOS -Q "ALTER USER [Sophos DB Admins] WITH LOGIN = [DOMAIN\Sophos DB Admins]"

    you mentioned

    >>

    >>the alter db command fails

    >>when excuting ResetUserMappings.sql?

    I was not running resetusermappings as that is mentioned further down in the post, but i have not got past point 2. yet

    Thanks for reply

    :41937
  • 0

    Hello hardwork,

    I was unable to reply with my account

    if an (implicit or explicit) Sign In takes you to a "template" My Account page just log out there. You'll then be able to sign in again.

    Seems like the account isn't there - did you run the query (you can leave out the WHERE clause to see all names)?

    luckily my backup worked and I got information back

    The backup was taken from which database? If 5.1 worked and 5.2 never did (are you meanwhile without a running management server)and the 5.1 databases are still here (did you make a final backup?) I'd manually reset/initialize the 5.2 databases which should cause the database upgrade to be (re-)performed. 

    Christian

    :41969