User profile for DBAJohnny

Thanks for getting back to me! / comments

Thanks for getting back to me!

0 votes

Multiple SSMS versions installed - want sql toolbelt in only one

Hi -I have two versions of SSMS installed (19 and 20). I would like my SQL Toolbelt essentials tools to not be available in 19.Is this possible? If so, how do I accomplish it?Thanks,Johnny

2 followers 2 comments 0 votes

Trust Server Certificate

I installed the update to 4.5.4.4597 this morning.On opening my saved package, I needed to check the Trust Server Certificate on the dialog box connecting to the target database.However, the <Gener...

1 follower 1 comment 0 votes

Robyn - Thanks! I now see the "trust server certificate" checkbox, just as you wrote. All's good now. Johnny / comments

Robyn -Thanks! I now see the "trust server certificate" checkbox, just as you wrote. All's good now.Johnny

0 votes

I am using Redgate SQL Compare 15.0.7.23280. I have tried uninstalling and re-installing, but that didn't help. / comments

I am using Redgate SQL Compare 15.0.7.23280. I have tried uninstalling and re-installing, but that didn't help.

0 votes

Yes, that resolved the problem. Thanks for the quick response! / comments

Yes, that resolved the problem.Thanks for the quick response!

0 votes

Certificate error connecting SQLCompare to a server after upgrading to SSMS 19

I am connected successfully in SSMS to an on-prem SQL Server with a windows account from an on-prem domain (which uses an internally-generated certificate). After upgrading to SSMS 19, I'm getting ...

2 followers 4 comments 0 votes

I've started a specific question for the SQL Compare plugin on SSMS 19. See https://forum.red-gate.com/discussion/89890/i-am-unable-to-get-the-sql-compare-plugin-working-with-ssms-19/p1?new=1 / comments

I've started a specific question for the SQL Compare plugin on SSMS 19. See https://forum.red-gate.com/discussion/89890/i-am-unable-to-get-the-sql-compare-plugin-working-with-ssms-19/p1?new=1

0 votes

I am unable to get the SQL Compare plugin working with SSMS 19

I originally posted this as a comment on https://forum.red-gate.com/discussion/89594/is-toolbelt-compatible-with-ssms-19, but I'm starting a new thread as the rest of toolbelt seems to be working.I...

3 followers 3 comments 0 votes

I installed SSMS 19 this morning and downloaded and installed the latest version of SQL Toolbelt Essentials. I'm getting the same error message ("The 'SQLSourceControlPackage' did not load correctly") when going into SSMS. I uninstalled SSMS 18, SSMS 19 and SQL Toolbelt, rebooted, reinstalled. No difference. I need to get SQL Source control working. Please advise, and thanks! The affected section of the ActivityLog.xml file is: <entry> <record>164</record> <time>2023/06/10 12:41:29.999</time> <type>Warning</type> <source>VisualStudio</source> <description>Unexpected system error mode before loading package [SqlSourceControlPackage]</description> <guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid> </entry> <entry> <record>165</record> <time>2023/06/10 12:41:29.999</time> <type>Information</type> <source>VisualStudio</source> <description>Begin package load [SqlSourceControlPackage]</description> <guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid> </entry> <entry> <record>166</record> <time>2023/06/10 12:41:30.130</time> <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.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
 at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
 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.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
 at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
 at RedGate.SQLSourceControl.Extension.SqlSourceControlPackage..ctor()</description> <guid>{29D00CBC-D1F6-4F0A-9418-FC8454E3B4FE}</guid> <hr>80004005 - E_FAIL</hr> <errorinfo></errorinfo> </entry> / comments

I installed SSMS 19 this morning and downloaded and installed the latest version of SQL Toolbelt Essentials. I'm getting the same error message ("The 'SQLSourceControlPackage' did not load correct...

0 votes

How can we help you today?

DBAJohnny

Activity overview