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?
· Share on Twitter

Comments

  • Options
    Dan BDan B Posts: 287 Gold 5
    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
    · Share on Twitter
  • Options
    DonFergusonDonFerguson Posts: 196 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.
    · Share on Twitter
Sign In or Register to comment.