Error when installing upgrade SQL Monitor

ThomasBE

Both versions 12.1.17 & 12.1.18 gave me the error shown on the screenshot:


Application event log shows me this:


Allready tried rebooting machine. Windows patches are installed up to May 2022.

Victoria W

Hi @ThomasBE

Does the account you're running the installer on have local admin rights? I've seen this issue before where logging in using the service account for the service gets past this error. 
 
You can also try extracting and installing SQL Monitor via the MSI file to see if that works better?
https://documentation.red-gate.com/in/extracting-and-installing-from-the-msi-file

ThomasBE

Hi @Victoria W ,

Logging in as the service account running SQL Monitor is not an option as this will flag a lot of stuff on our security monitoring.

Victoria W

Hi @ThomasBE

Please can you try extracting and installing SQL Monitor via the MSI file to see if that works better?
https://documentation.red-gate.com/in/extracting-and-installing-from-the-msi-file

Alex B

Hi @ThomasBE,

This happens if you have manually updated the password in the Windows Credentials Store with an updated password (in plain text).  SQL Monitor stores it in a obfuscated format, and the error is that it fails trying to undo the base64 obfuscation on a normal string.

If you delete the entry from the Windows Credential Store it and re-run the installer you will be able to re-enter the credentials (and it shouldn't fail with an error) and you should be able to proceed.

Kind regards,
Alex

ThomasBE

@Alex B, 

This worked perfect.
Thanks a lot for the solution!

Kind regards,
Thomas