Expolit prevention policy unable to open/edit

Hello Abhijeet,

Came to know
do you have a reference (article, post, whatever)? alter the table is a little bit vague.

How to take database backup
Backing up the database is a good idea, not only before migration or when you want to make chages to it. Unless, of course, you want to start from scratch in case of some incident ...

Christian

Hello Christian,

Thanks for the reply, I was following this thread:
https://community.sophos.com/products/endpoint-security-control/f/sophos-enterprise-console/92582/exploit-prevention-policy-cannot-open-setting#pi2151=2

--Abhijeet

Hello Abhijeet,

thanks. I see, vaguely remembered it but could not find it.

Are you still on SEC 5.5.0? If so, I'd suggest to upgrade to 5.5.1 as it not only fixed this issue but has some enhancements as well. If you don't want to upgrade - the answer is in the thread you referred to. sqlcmd is the program to connect to the database and alter the table.

Christian

Thanks for the reply, Yes we are running 5.5.0 version and I believe upgrade would be the best option.

Can you help me with the best guide/forum to proceed with the upgrade?

Thanks,
Abhijeet

Hello ,

it's basically downloading the Sec 5.5.1 Installer, running the SFX and proceed with the upgrade. It might ask for the database account credentials.
The Upgrade Guide has more detailed information (note that not chapters apply, e.g. dealing with Encryption).

Christian

Thanks for the reply.

Sorry but not clear with the SFX process, kindly confirm.

--Abhijeet

Hello Abhijeet,

you download the installer package and run it. It unpacks itself and starts setup.exe - the same procedure as for the initial install of SEC.

Christian

Hello Abhijeet,

you download the installer package and run it. It unpacks itself and starts setup.exe - the same procedure as for the initial install of SEC.

Christian

Thanks Christian!!!