Red Gate issues with SSMS 18.5

sam_alexander · April 8, 2020 8:39PM

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

Image: https://us.v-cdn.net/6029854/uploads/editor/8i/acavwjb33mqd.png

Specifics in the log for this one is this:

<entry>

<type>Error</type>

<source>VisualStudio</source>

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

</entry>

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

Suggestions? Thanks

Martin_K · April 9, 2020 9:30PM

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 · April 13, 2020 2:51PM

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

tcs_fs · April 13, 2020 8:16PM

Same here, fix worked.

mr_gooding · April 14, 2020 9:45AM

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 · April 14, 2020 10:58AM

I get the error when installing that version.

Image: https://us.v-cdn.net/6029854/uploads/editor/l9/fsjef63a1jgs.png

It happens only for SSMS 18.5

Red Gate issues with SSMS 18.5

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk