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

Connect to Sophos DB's from remote Management Studio

I've successfully connected to the Sophos MSSQL Express instance running on my server using the domain account I created "domain\endpoint". However, that user doesn't seem to have any permissions to view the actual databases. I've also tried connected to the Sophos instance using SQL Authentication and entering the username and password to the db user initially created during instal, but that doesn't authenticate.

What is the proper way of connecting to the db's? Or how do I reset the db user password to make sure that I'm using the correct one? Is there an SA account in the Sophos instance?

Thanks.

This thread was automatically locked due to age.

0 jak over 10 years ago

Hello,
SQL auth is not secure and isn't used by Sophos components to access the database.
You can reset the sa password if SQL auth is enabled, e.g. the instance is in Mixed mode. A quick google search for reset sa account sql yielded: http://www.wikihow.com/Reset-SA-Password-in-Sql-Server which should help.
SQL auth asside I think the following info should help you
https://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_53_auditeng.pdf?la=en
https://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_sriugeng.pdf?la=en
You could always create a SQL login in the Sophos SQL instance and give it the sysadmin role
Regards,
Jak
:56855
Cancel
Vote Up 0 Vote Down

Cancel
0 QC over 10 years ago

Hello yani1shu,
any particular reason that you want to access to database or are you just curious? On a vanilla installation you shouldn't have to perform any additional steps to be able to access the database with e.g. sqlcmd. As you've said remote Management Studio and successfully connected the issue is perhaps related to the "domain\endpoint" account (I'm not sure whether this is the Database Account for your installation or some additional account). Can you access the database locally with this account?
Christian
:56858
Cancel
Vote Up 0 Vote Down

Cancel
0 yani1shu over 10 years ago

Thanks for the reply Christian. I installed the Managment Studio on the local server and was able to access the db's so that's good enough for me.
The reason I want to access the database backends is for custom reporting. Sophos Enterprise Consol is lacking any reporting regarding the patch assessments it performs. I want to create a report that pretty much shows a summary for every machine including A/V information and patch assessment info. Only way to do this seems to be through the db's.
:56876
Cancel
Vote Up 0 Vote Down

Cancel