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

sophos management services fails to start after upgrade from 4.5 to 5.0

kk20

Upgrade appeared to work.   New account created as requested.

Event viewer shows the following chronological errors:

  • Login failed for user '<My new logon created before installing>'. Reason: Failed to open the explicitly specified database. [CLIENT: <server IP address>]
  • There is no database connection. Management Service will be shut down.

  • Initialization failed.

         Step: Creating a database connection

         Error: std::runtime_error

         Cannot open database "SOPHOS50" requested by the login. The login failed

This can be fixed by adding the user to the administrators group.  Management services start correctly.  If the user is removed from the administrators group then the service fails to start.

I didnt think being part of the administrators group was necessary? 

:25207


This thread was automatically locked due to age.
  • 0
    Hello kk20,

    it shouldn't be necessary. I did have a similar problem upgrading from 4.7 though. Can't remember what I did afterwards, guess it was running Repair or unictall/install on the Sophos Database component (note this shouldn't harm your database but be sure you have a backup before doing it).

    Christian
    :25211
  • 0

    Hi,

    Sounds like a mapping problem.  If your db acount is a member of the "Sophos DB Admins" Windows group, then the chances are, that the Windows group to SQL login mapping is broken.  Possibly due to either the Windows group being removed and re-created or the database being restored from another machine in the past

    See:

    /search?q= 24299

    Regards

    Jak

    :25217
  • 0

    Good Day KK20

    Hope you are well.

    the error you are stating, is that the databse cant be open with current logged on user.

    Can we please confirm the following:

    was the upgrade of the databse successful? please open the dat folder of MS SQL, to confirm the databases are the same size?

    the path will be:

    C:\program files\Microsoft SQL server\MSSQL\data

    Please ensure the following databases are present:  Sophos_47.mdf, Sophos_47log.ldf, (New) Sophos50.mdf, Sophos50.ldf, SophosPatch.mdf, SophosPatch.ldf

    If they are the same size, please open SQL management studio, please ensure the revelant user has access to the SOPHOS50 database, and the user mapping is correct.

    once done, please go to the Sophos Mangement service, right click, select properties, log on tab, please specify the account the sophos created, once done, please try start it.

    If the database is not the same size, please run the following upgrade path, which will upgrade the database, so you can assisgnt the rights accordingly:

    Please open command prompt, 

    Please browse to the following path:

    2003: C:\program files\Sophos\Enterprise console

    2008: C:\program files (x86)\ Sophos Enterprise console

    please run the following command:

    upgradedb.exe -debug -sourceVersion=47

    Please use command exactly, as the Upper case V is important.

    once the upgrade is done, try start the management service.

    Hope this helps :smileyhappy:

    Kind Regards

    :25303
  • 0

    Had the same problem,

    Re-installed Enterprise Console and the service still wouldn't start,

    Used the command posted "upgradedb.exe -debug -sourceVersion=47 " and it worked a treat,

    Thanks for the solution,

    Mark

    :25589