How can we help you today? How can we help you today?

Red Gate issues with SSMS 18.5

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
sam_alexander
0

Comments

5 comments

  • 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?
    Martin_K
    0
  • spivonious
    I experienced the same issues here. The provided installer fixed the issue.
    spivonious
    0
  • tcs_fs
    Same here, fix worked.
    tcs_fs
    0
  • 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?
    mr_gooding
    0
  • Dmitry
    I get the error when installing that version.



    It happens only for SSMS 18.5
    Dmitry
    0

Add comment

Please sign in to leave a comment.