Getting "Certificate is invalid: RedGate.SqlChangeAutomation.VisualStudio.vsix" error

TheSimmer

Trying to install SQL Change Automation VS extension (vsix) version 3.0.19028.4280 for VS 2017 Enterprise and getting "certificate is invalid error". I downloaded the vsix and using VS Installer since it's a box without internet. Any advice to resolve this?

TheSimmer

I was able to resolve this by downloading the certificate manually from another box with internet access, moved the certificate over to the box where I am installing the extension and installed the certificate manually.

Rajeev_S

Hello SimSQL, 

I am having the same issue when installing this SQL Change Automation in my PC which is connected to the network and I am going in circles to fix this issue with no luck. However I managed to install in a sandbox (standalone) environment. 
I am hoping your fix may also work out for me. Would you be able to tell me on where can I find this Certificate?

Thank You
Rajeev

TheSimmer

If your PC doesn't have internet access you will need to download the certificate manually. You can do this by using a tool such as Fiddler to see what URL it is hitting to download the certificate. Copy and paste the certificate URL to your browser to download it. Move the certificate (CRT file) to the PC without internet connection. Start your installation. It should now work.

Russell D

We're unable to help bypass certificates for installing extensions because it is a requirement imposed by Microsoft (see https://developercommunity.visualstudio.com/content/problem/205047/offline-installation-with-vsix-installer-fails.html). As @simsql said you'll need to download the certificate manually.

See https://docs.microsoft.com/en-us/visualstudio/install/install-certificates-for-visual-studio-offline?view=vs-2019 for more on this.