Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 4478 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.
Parents
  • 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
Reply
  • 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
Children
No Data