This topic has 8 replies, 3 voices, and was last updated 1 year, 8 months ago by Mark Garrison.
-
AuthorPosts
-
May 20, 2019 at 6:19 pm #9508
Mark Garrison
MemberOur MSPControl just updated from 2.0.950 to 2.0.953 and although the login screen comes up fine no one can login to MSPControl any longer due to “Too Many Redirects”. The URL & Query String post-login is \Default.aspx?pid=Licensing"aInvalid=MsSQL2017.Databases&localValue=300&licenseQuota=0.
Any ideas how to proceed?
We already tried clearing cookies, but it appears to be an error in the Licensing (again).
MSPControl is totally down for us again, which is becoming a regular occurrence this past year and is proving to be more a liability to doing business than an assistance.
Like0Be the first one to like this.Please wait...May 20, 2019 at 6:52 pm #9510MSPControl
KeymasterTry restarting the server, if that doesn’t work then request a new license.
Like0Be the first one to like this.Please wait...May 21, 2019 at 1:26 am #9511Alexander
MemberSorry, please execute this SQL
DELETE FROM [dbo].[SystemSettings] WHERE [PropertyName]= 'CurrentLicense'
It will drop your license and you will get a new one on Sign In.
Like0Be the first one to like this.Please wait...May 21, 2019 at 12:53 pm #9514Mark Garrison
MemberAlexander,
Thanks. I was trying to find it in MSSQL and the closest I found was [dbo].[SystemSettings].[LicenseSettings] but wasn’t able to delete it. I executed the SQL cmd you provided and that indeed got me in and was greeted with a 5-Step Setup Installer routine (that’s new, never seen that before) that obtained a new license on Step 1. Unfortunately, after finishing the 5-Step Setup it went right back to the same problem…”Too many redirects” trying to redirect to /Default.aspx?pid=Licensing"aInvalid=MsSQL2017.Databases&localValue=300&licenseQuota=0
So promising…so close.
Apparently automatic updates are still working as I got email notification that it upgraded successfully to v2.0.954, but problem still persists and all users are still unable to login.
Like0Be the first one to like this.Please wait...May 21, 2019 at 1:35 pm #9515Alexander
MemberI tested your license – it’s good. What returns this SQL?
SELECT * FROM [dbo].[Quotas] where QuotaName like '%MsSQL2017%' or QuotaName like '%MsSQL2019%'
Like0Be the first one to like this.Please wait...Attachments:
You must be logged in to access attached files.
May 21, 2019 at 2:50 pm #9517Mark Garrison
MemberAlexander,
The results of the query are as follows:
QuotaID GroupID QuotaOrder QuotaName QuotaDescription QuotaTypeID ServiceQuota ItemTypeID HideQuota Editor
780 54 1 MsSQL2017.Databases Databases 2 0 376 NULL NULL
781 54 2 MsSQL2017.Users Users 2 0 377 NULL NULL
782 54 3 MsSQL2017.MaxDatabaseSize Max Database Size 3 0 NULL NULL NULL
783 54 5 MsSQL2017.Backup Database Backups 1 0 NULL NULL NULL
784 54 6 MsSQL2017.Restore Database Restores 1 0 NULL NULL NULL
785 54 7 MsSQL2017.Truncate Database Truncate 1 0 NULL NULL NULL
786 54 4 MsSQL2017.MaxLogSize Max Log Size 3 0 NULL NULL NULL
790 55 1 MsSQL2017.Databases Databases 2 0 380 NULL NULL
791 55 2 MsSQL2017.Users Users 2 0 381 NULL NULL
792 55 3 MsSQL2017.MaxDatabaseSize Max Database Size 3 0 NULL NULL NULL
793 55 5 MsSQL2017.Backup Database Backups 1 0 NULL NULL NULL
794 55 6 MsSQL2017.Restore Database Restores 1 0 NULL NULL NULL
795 55 7 MsSQL2017.Truncate Database Truncate 1 0 NULL NULL NULL
796 55 4 MsSQL2017.MaxLogSize Max Log Size 3 0 NULL NULL NULLLike0Be the first one to like this.Please wait...Attachments:
You must be logged in to access attached files.
May 21, 2019 at 5:32 pm #9519Mark Garrison
MemberApparently non-admin users are now able to login without the session being redirected until it gives a browser error, but instead they are receiving the following error upon successful login:
“Unexpected error. Please try to log out and log in again. Object reference not set to an instance of an object.“
Although they can login they are not able to access any of the functions from their account.
Like0Be the first one to like this.Please wait...Attachments:
You must be logged in to access attached files.
May 21, 2019 at 5:44 pm #9521Alexander
MemberPlease rename quotas with ids 790-796 from MsSQL2017 to MsSQL2019
It will help your issue. Sorry seems it was short bad buildLike0Be the first one to like this.Please wait...1 user thanked author for this post.
May 21, 2019 at 6:06 pm #9522Mark Garrison
MemberAlexander,
Great catch! That indeed did the trick! Have confirmed Admin & User login are functioning properly after renaming the second set of MsSQL2017 to MsSQL2019 in the [dbo.Quotas]. Everything is looking to be back to normal.
Thank you!
Like0Be the first one to like this.Please wait... -
AuthorPosts
You must be logged in to reply to this topic.