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

• 
  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.

  TheSimmer February 08, 2019 13:13

  - 0 +
• 
  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
  
  

  Rajeev_S May 06, 2019 18:46

  - 0 +
• 
  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.

  TheSimmer May 06, 2019 20:02

  - 0 +
• 
  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.
  

  
  
  

  Russell D May 07, 2019 07:36

  - 0 +

Add comment

Please sign in to leave a comment.