App Control: How to Enable High Server Debugging Through SQL

[#1]

Environment

• App Control (Formerly CB Protection) Server: All Versions
• Microsoft SQL: All Supported Versions

Objective

To enable high debugging when the UI is unavailable.

Resolution

1. Connect to the SQL server.
2. Open SQL Server Management Studio as either the service account or a SQL full admin. 
3. Run the following command: 

   use das; EXEC dbo.UpdateShepherdConfig 'DebugLevel', '6'

4. Collect 5-10 mins of data while reproducing the issue
5. Once collection is complete reverse the change by running:

   use das; EXEC dbo.UpdateShepherdConfig 'DebugLevel', '0'

6. Collect and attach the server log here: "\Program Files (x86)\Bit9\Parity Server\ServerLog.bt9"

Additional Notes

All other steps on data collection for the App Control server can be found in App Control: Collecting Historical Logs for Server Troubleshooting (Remotely)