Red Gate issues with SSMS 18.5

sam_alexander

I upgraded to 18.5 and now nothing works.  Seems like each of the RG extensions fails with this:



Specifics in the log for this one is this:

  <entry>

    <record>287</record>

    <time>2020/04/08 20:32:16.387</time>

    <type>Error</type>

    <source>VisualStudio</source>

    <description>CreateInstance failed for package [SqlSourceControlPackage]Source: &apos;mscorlib&apos; Description: Exception has been thrown by the target of an invocation.&#x000D;&#x000A;System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---&gt; System.InvalidOperationException: Couldn&apos;t load any SSMS library&#x000D;&#x000A;   at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage..ctor()&#x000D;&#x000A;   --- End of inner exception stack trace ---&#x000D;&#x000A;   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean&amp; canBeCached, RuntimeMethodHandleInternal&amp; ctor, Boolean&amp; bNeedSecurityCheck)&#x000D;&#x000A;   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark&amp; stackMark)&#x000D;&#x000A;   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark&amp; stackMark)&#x000D;&#x000A;   at System.Activator.CreateInstance(Type type, Boolean nonPublic)&#x000D;&#x000A;   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark&amp; stackMark)&#x000D;&#x000A;   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)&#x000D;&#x000A;   at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)&#x000D;&#x000A;   at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)System.InvalidOperationException: Couldn&apos;t load any SSMS library&#x000D;&#x000A;   at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage..ctor()</description>

    <guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid>

    <hr>80004005 - E_FAIL</hr>

    <errorinfo></errorinfo>

  </entry>

I also downloaded and installed the latest Red Gate Toolbelt and updated everything, same thing.

Suggestions?  Thanks

Martin_K

Hi Sam,

We've had some compatibility issues with the new SSMS 18.5 release. They should now be fixed, though! Could I ask you to try installing the tool from the below links rather than from the SQL Toolbelt installer?

• SQL Source Control 

Thank you.

spivonious

I experienced the same issues here. The provided installer fixed the issue.

tcs_fs

Same here, fix worked.

mr_gooding

Hi There, had the same issue and this has fixed. Is there a possibility you could make the latest version easier to download than having to find via a forum post?

Dmitry

I get the error when installing that version.



It happens only for SSMS 18.5