When performing a UDL database connection test the following error is seen:
Test connection failed because of an error initializing provider. Cannot open database "SOPHOS50" requested by the login. The login failed.
Note: 'SOPHOS50' shown above could be replaced by any of the Sophos database names.
First seen in Enterprise Console 4.5.0Sophos Enterprise Manager 4.7.0Sophos Control Center 4.0.0
There are various reasons for the UDL test to fail. The error seen is a high level error which does not point to a singular problem.
The error generally means the database being tested cannot be contacted. Therefore you must check and confirm the following:
sqlcmd -E -S .\sophos -Q "select name from sysdatabases"
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.