Comments
1 comment
-
I'm having the same issue. I have 2 instances on my local server.- Default:
Microsoft SQL Server 2019 (RTM-CU22) (KB5027702) - 15.0.4322.2 (X64) Jul 27 2023 18:11:00 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19045: ) (Hypervisor)
- Microsoft SQL Server 2022 (RTM-CU7) (KB5028743) - 16.0.4065.3 (X64) Jul 25 2023 18:03:43 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 19045: ) (Hypervisor)
The ActivityLog.xml shows:<entry><record>407</record><time>2023/09/26 11:22:04.736</time><type>Information</type><source>VisualStudio</source><description>Entering function CVsPackageInfo::HrInstantiatePackage</description><guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></entry><entry><record>408</record><time>2023/09/26 11:22:04.737</time><type>Information</type><source>VisualStudio</source><description>Begin package load [SQLTestSSMSPackage]</description><guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></entry><entry><record>409</record><time>2023/09/26 11:22:04.739</time><type>Error</type><source>VisualStudio</source><description>LegacySitePackage failed for package [SQLTestSSMSPackage]Source: 'RedGate.SQLTest.Shell.19' Description: Could not load file or assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.Management.SDK.SqlStudio, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
 at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.HookUpEvents(DTE2 application)
 at RedGate.SQLTest.Shell.SsmsFunctionalityProvider.Initialize(DTE2 dte)
 at RedGate.SQLTest.Shell.SsmsFunctionalityProvider..ctor(DTE2 dte, WrappingFactory wrappingFactory)
 at RedGate.SQLTest.Shell.AddinLoader..ctor(DTE2 dte, ILog log)
 at RedGate.SQLTest.SSMSPackage.SQLTestSSMSPackage.Initialize()
 at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</description><guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid><hr>80070002</hr><errorinfo></errorinfo></entry><entry><record>410</record><time>2023/09/26 11:22:04.739</time><type>Error</type><source>VisualStudio</source><description>SetSite failed for package [SQLTestSSMSPackage](null)</description><guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid><hr>80070002</hr><errorinfo></errorinfo></entry><entry><record>411</record><time>2023/09/26 11:22:04.739</time><type>Error</type><source>VisualStudio</source><description>End package load [SQLTestSSMSPackage]</description><guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid><hr>80070002</hr><errorinfo></errorinfo></entry></activity>
Using SQL Test 4.1
How can this be solved?
Thanks - Default:
Add comment
Please sign in to leave a comment.
SQL Test errors upon load of SSMS and the plugin is not able to load
Here is the error from the activity logs:
<div> <entry></div><div> <record>299</record></div><div> <time>2023/08/02 21:32:52.203</time></div><div> <type>Information</type></div><div> <source>VisualStudio</source></div><div> <description>Begin package load [SQLTestSSMSPackage]</description></div><div> <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></div><div> </entry></div><div> <entry></div><div> <record>300</record></div><div> <time>2023/08/02 21:32:52.211</time></div><div> <type>Error</type></div><div> <source>VisualStudio</source></div><div> <description>LegacySitePackage failed for package [SQLTestSSMSPackage]Source: 'RedGate.SQLTest.SSMS.19' Description: Could not load file or assembly 'RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException: Could not load file or assembly 'RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.
File name: 'RedGate.SQLTest.Shell, Version=4.1.4.2200, Culture=neutral, PublicKeyToken=7f465a1c156d4d57'
 at RedGate.SQLTest.SSMSPackage.SQLTestSSMSPackage.Initialize()
 at Microsoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
</description></div><div> <guid>{F67A15B5-C90B-4EFF-BCD2-4E82D0F403AA}</guid></div><div> <hr>80070002</hr></div><div> <errorinfo></errorinfo></div><div> </entry></div>