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?
Comments
2 comments
-
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. -
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.
Add comment
Please sign in to leave a comment.