SQL Monitor No Longer Respecting "Keep Me Logged In" flag?

josh_smith

Since 9.1.3 or 9.1.4 SQL Monitor is no longer maintaining our sessions and even on occasion logging us out mid-day without having restarted the browser window....

Russell D

Hi @josh_smith  - do you use app pool recycling in IIS at all?

josh_smith

I double checked and looked like some app pool recycling settings had been turned on at some point (1700 mins approx). I've turned the recycling off but we are still prompted to login on browser start (sessions had persisted through machine reboots previously).

yrkr888

Yes, We see the same issue and have a app pool recycling value set to Regular time intervals as 1740 Minutes.

Russell D

1740 is the default in IIS so roughly after a day any active sessions would get killed. Thanks for the additional information thats its still happening despite disabling recycling.
I'm afraid we're still investigating it.

Russell D

We think we've gotten to the bottom of this and it should be in the next release.

josh_smith

Excellent news, thanks!

Oliver_Goldcrest

Glad to see this has been picked up. Has been driving us nuts since we upgraded.

Russell D

We've fixed this behaviour, it will be in 9.2.1.

Russell D

This should be out later today.

xantari

Can't wait for this one! It's annoying to login every morning to our redgate SQL monitoring server so that it shows up on our status board monitor hanging in our area.

yrkr888

@Russell D
We were on .NET Framework 4.5.1 when on SQLMonitor 9.1.3 .
Do we need to upgrade to 4.7.2 for 9.2.1?
I didn't see any announcements on 9.2.1 release.

(SQL Monitor now requires .NET Framework 4.7.2 or later. )

Russell D

https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_9.2.1.23943.exe has been released. Thanks for the patience with this issue everyone.

@yrkr888 yes you will need to update to .NET 4.7.2 as per the release notes.