Installation of 10.2 blocked on Windows 2019 Standard server

SamJ

I'm getting the message "Problem connecting to SQL Monitor repository data store".  I have upgraded SQL Monitor at least a dozen times over the past 18 months.  I've confirmed connectivity info is correct.  I've even created a System DSN on the server to double check.  The current installed version is 10.1.3.  I didn't have any problems with the installer then.

Russell D

If you right click the installer and check 'Unblock' does that work?

SamJ

Russell, when I reclick on the Installer, nothing happens.

Russell D

When you get the "Problem connecting to SQL Monitor repository data store" message, can you click the top left corner of the installer and view the log file? And send that in to Support?

SamJ

I left clicked and right clicked every pixel of the installer.  There was never an indication to view the log file.  However, I resolved the problem by clicking on the "Edit connection properties..." link and checked the "Trust server certificate" which was unchecked.  I have never checked or unchecked this in prior installations.

SamJ

After the upgrade, none of the monitored servers would connect.  I had to go to each, edit the connection properties, and click "Trust server certificate".  Now its working normally.  

Russell D

Ah that is familiar, it's due to a change by Microsoft in the sql connection client.