How can we help you today? How can we help you today?

AD Login Fails after password update

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?
cjbaum
0

Comments

2 comments

  • 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.
    Dan B
    0
  • 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.
    DonFerguson
    0

Add comment

Please sign in to leave a comment.