Purpose

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

Requirements

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

Steps

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
https://documentation.red-gate.com/sm/troubleshooting/error-messages/can-t-connect-to-active-directory-authentication-service