SA 12.2.387 v SSMS 19.0.1

SA 12.2.387 v SSMS 19.0.1

Every time I launch SSMS, before I even get the Connect to Server modal window SA is throwing an exception in a bubble popup in my taskbar:

Code:

Context: Loading of Object Explorer add-in SqlAssist.Ssms2022 failed.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'SqlPackageBase, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at SqlAssist.SsmsOE..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.Activator.CreateInstance(Type type)
at SqlAssist.SSMS_IDE.Init(DTE application)

[/code]

Code:

ontext: Loading of Object Explorer add-in SqlAssist.Ssms2022 failed.
System.Reflection.TargetInvocationException: Ein Aufrufziel hat einen Ausnahmefehler verursacht. ---> System.IO.FileNotFoundException: Die Datei oder Assembly "SqlPackageBase, Version=16.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.
bei SqlAssist.SsmsOE..ctor()
--- Ende der internen Ausnahmestapelüberwachung ---
bei System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
bei System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
bei System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
bei System.Activator.CreateInstance(Type type, Boolean nonPublic)
bei System.Activator.CreateInstance(Type type)
bei SqlAssist.SSMS_IDE.Init(DTE application)

I have the same problems with SSMS 19.0.2 and SQLAssistant 12.2.387.

Could you please try installing SqlPackage and see if that fixes the issue?
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver16

	SysOp wrote:
	Could you please try installing SqlPackage and see if that fixes the issue? https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver16

No sir, it did not remedy the error.

Could you please confirm you're running SSMS version 19.0.20200.0

Here is my version stack copied from SSMS Help/About. With that version I'm unable to reproduce your message. Maybe I have something else installed that you don't, which is a required dependency.

SQL Server Management Studio 19.0.20200.0+9286509b
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19970.0
Microsoft Data Access Components (MDAC) 10.0.19041.2604
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044

I'm downloading 19.0.2 now, but here's my info for 19.0.1

SQL Server Management Studio 19.0.20200.0+9286509b
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19970.0
Microsoft Data Access Components (MDAC) 10.0.22621.1265
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22621

Here's 19.0.2's info:

SQL Server Management Studio 19.0.20209.0+f9a9d8f6
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19993.0
Microsoft Data Access Components (MDAC) 10.0.22621.1265
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22621

I still get the same exception popup from the taskbar from SA.

Looks the same as mine. So it got to be some external dependency(ies). We will try to reproduce it on a clean system.

	SysOp wrote:
	Looks the same as mine. So it got to be some external dependency(ies). We will try to reproduce it on a clean system.

Windows OS and MDAC component is different. If memory serves the 10.0.2x branch is Windows 11 (Thanks for that MS) and 10.0.1x is Windows 10?

We managed to reproduce this issue. It could happen in case of upgrades, an old version of SSMS 19 add-on gets installed, a version which was developed for the preview version of SSMS 19.0.0, and not forward compatible with 19.0.1 and 19.0.2. We will have a new setup with the upgraded version published soon. Please stay tuned.

Here is a quick fix for this issue that can be applied now.

Make sure SSMS and SQL Assistant are both closed
Download and unzip the following small file to C:\Program Files (x86)\SQL Assistant 12\bin
https://www.softtreetech.com//support/files/sqlassist/SqlAssist.SSMS2022.zip

This is to replace the Object Explorer add-on for SSMS 19 preview version 19.0.0 with the latest version. The former isn't forward compatible with SSMS 19.0.1 and 19.0.2.

Last edited by SysOp on Tue Mar 21, 2023 10:49 am; edited 1 time in total

Trying now, by the way your link says httpa:// not https:// so the the browser wasn't happy until I manually fixed it.

Thank you. I fixed it. Now it's https.

	SysOp wrote:
	Thank you. I fixed it. Now it's https.

So far so good with the hot patch.