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

Logging in as Administrator but not being "seen" as an admin?

I'm setting up the trial of SQL Monitor in my home lab, prior to our getting it to load up at my work (FINALLY!) so I know the steps involved.  The problem I'm having is, I've got the site loaded (IIS, it's the ONLY site on the server,) I can get the login, the first login makes me set the administrator password and it all seems good.

Until I try to do anything at all.
I can't add users, I can't add servers to monitor, nothing.  Every option like that throws up the pop-up "This feature is only available to Administrators."  I've tried the steps for a forgotten administrator password, which didn't help.  I've even tried setting it up to auto-login as admin which hasn't helped either...

Suggestions, hints, help?

Thank you,
Jason A
JAsh
0

Comments

3 comments

Sort by
  • StefanRADU
    I have the same issue. I've sent an email regarding this problem but no reply. Did you find a solution?
    StefanRADU
    0
  • StefanRADU
    Got this answer "
    Apologies, this has been caused by a bug in version 11.1.7, you can work around this by running the following query on the SQL Monitor database:

    EXEC settings.SetKeyValuePair @KeyName = N'AuthenticationType',
                                  @KeyValue = 1,
                                  @KeyValueType = N'NUMERIC'

    or you can wait until the next version comes out and reinstall SQL Monitor then (I expect this to be out very shortly). "
    StefanRADU
    0
  • JAsh
    One of the Red Gate support folks sent me a link to grab v11.1.8.9619, which resolved the problem for me.

    Now to write up an install guide for work, so we can get this deployed once our purchase goes through.
    JAsh
    0

Add comment

Please sign in to leave a comment.