Disabling AD Authentication in SQL Monitor


If you are unable to log in to SQL Monitor with your AD credentials, this will help you disable AD authentication.


You will need sufficient permissions to update the SQL Monitor repository.


In SSMS, run the following query against the SQL Monitor repository:

UPDATE [RedGateMonitor].[settings].[KeyValuePairs]
SET [RedGateMonitor].[settings].[KeyValuePairs].[KeyValue] = 0
WHERE [RedGateMonitor].[settings].[KeyValuePairs].[KeyName] = 'ActiveDirectory-Enabled'

You will then need to restart the SQL Monitor BaseMonitor. 

See also

Was this article helpful?

3 out of 6 found this helpful
Have more questions? Submit a request