At system start-up the following error messages may be observed in the Sophos Patch Windows Event log:
PID [Number]: TID [Number] Error fetching upgrade status. -- System Exception Details -- Message: Cannot open database "SOPHOSPATCH52" requested by the login. The login failed. Login failed for user '[domain]\SophosManagement'. Type: SqlException Source: .Net SqlClient Data Provider
First seen in Enterprise Console 5.0.0
The Microsoft SQL Server instance used by Sophos has not completed loading the Sophos Patch database before a query is made to it by the Sophos Patch services.
In order to delay the initial queries to the database referenced and give Microsoft SQL Server time to fully load the databases, where possible, using the MMC snap in 'services.msc', change the service 'startup type' to be 'Automatic (Delayed start)' for the following services:
Note: If you are unable to choose 'Automatic (Delayed start)' as a service startup type due to the version of the operating system; providing these error messages only appear following a restart they can be safely ignored.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.