Options

AD Login Fails after password update

cjbaumcjbaum Posts: 9
edited January 4, 2016 4:11PM in SQL Monitor Previous Versions
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

  • Options
    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.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Options
    DonFergusonDonFerguson Posts: 198 Silver 5
    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.
Sign In or Register to comment.