AD Login Fails after password update

cjbaum

I updated my password and now i cant log into the monitor with either my new or old passwords ? I tried resetting the AD login setting with script mentioned earlier and resetting the monitor service but it didnt revert?

Dan B

Hi cjbaum,

Thanks for posting on the Redgate forums.

The script to turn off AD authentication is below, you would then need to restart the SQL Monitor Web Service.

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

If you could confirm this is done and we can then progress this call from there.

DonFerguson

You also need to recycle the SQL Monitor Services. I believe in this case it's the web service, but I would recycle both the web and the base.