Certificate is invalid: RedGate.SqlChangeAutomation.VisualStudio.vsix

Nick_Foster

I've tried installing this multiple times and although it installs ok into Sql Management Studio, it doesn't show up in Visual Studio 2019 Enterprise.  

The machine is a Windows Server 2019 VM behind a proxy server.  

Please help.

Package 'Redgate.ReadyRoll,version=4.3.21271.27462' failed to install.

    Search URL

        https://aka.ms/VSSetupErrorReports?q=PackageId=Redgate.ReadyRoll;PackageAction=Install;ReturnCode=0x80096004

    Details

        Certificate is invalid: RedGate.SqlChangeAutomation.VisualStudio.vsix

    Impacted components

        Redgate SQL Change Automation (Component.Redgate.ReadyRoll,version=4.3.21271.27462)

Victoria W

Hi @Nick_Foster

Please can you try manually installing both the root and intermediate certificate:

The root certificate can be downloaded from the following page (under "Attachments"):
https://support.comodo.com/index.php?/Knowledgebase/Article/View/969/108/root-comodo-rsa-certification-authority-sha-2

The intermediate certificate can be direct-downloaded here:
http://crt.comodoca.com/COMODORSACodeSigningCA.crt

Then follow these steps to install the root and intermediate certificates under the computer account:
https://support.comodo.com/index.php?/comodo/Knowledgebase/Article/View/636/17/

Nick_Foster

Perfect, thank you.  Looks like I already had the root cert, but was missing the intermediate.  Once I had that Change Automation installed just fine.

Cheers.