12.3.427 & SSMS 19.1.56.0 error when opening studio

12.3.427 & SSMS 19.1.56.0 error when opening studio

Decided to upgrade my SSMS from 18.12 to the latest 19.1 and now I get an error when open studio:
"ServiceCache class not found in Microsoft.SqlServer.Express.VsIntegration"

I did a reinstall of SQL Assistant and nothing changed

Reinstalling won't help. The error message indicates a missing dependency, likely a change in SSMS. We are investigating.

A few questions first to collect more details for troubleshooting this issue. Is SSMS 18.12 still installed on your system? Does SQL Assistant's add-on work in 18? Do you have Visual Studio installed on the same system and if yes, which version?

If instead of installing an upgrade, you download and install SSMS 19 directly, do you still get the same "ServiceCache class not found in Microsoft.SqlServer.Express.VsIntegration" error?

I have Visual Studio Professional 2022 v17.6.5.
I was unclear a bit.
18 version cannot be upgraded to 19 and they have separate installations.
So before upgrading SSMS, I uninstalled SSMS 18.12 and now I'm on 19.1.

Would it be possible to try installing 18.12 back to check if that resolves the issues with not found class or assembly?

Installed 18 and in this version SA works. 19.1 has the same error

Can you please copy and paste here version info from SSMS Help\About menu, there is Copy Info button for that?

Code:

SQL Server Management Studio                   19.1.56.0
SQL Server Management Objects (SMO)             16.200.48044.0+eeb184ee48a91ebc6a27a5d192c0d67bdfaae8b6
Microsoft T-SQL Parser                   17.0.8.0+3c5555b8bd579d12add8f155f1dbc871e3e734c4
Microsoft Analysis Services Client Tools          16.0.20010.0
Microsoft Data Access Components (MDAC)          10.0.19041.3208
Microsoft MSXML                   3.0 6.0
Microsoft .NET Framework             4.0.30319.42000
Operating System                   10.0.19045

We need to test one more thing

1. Please download and unzip this file https://www.softtreetech.com/sqlassist/diag/sa.ssms19.zip to SQL Assistant's bin folder C:\Program Files (x86)\SQL Assistant 12\bin
2. Start SSMS
3. You're very likely going to see an error message, but the error message text is going to be different this time. Please let us know what's in the error message.

I get the same error.
My SSMS Info:

Code:

SQL Server Management Studio                19.1.56.0
SQL Server Management Objects (SMO)                16.200.48044.0+eeb184ee48a91ebc6a27a5d192c0d67bdfaae8b6
Microsoft T-SQL Parser                17.0.8.0+3c5555b8bd579d12add8f155f1dbc871e3e734c4
Microsoft Analysis Services-Clienttools                16.0.20010.0
Microsoft Data Access Components (MDAC)                10.0.22621.1992
Microsoft MSXML                3.0 6.0
Microsoft .NET Framework                4.0.30319.42000
Betriebssystem                10.0.22621

I copied the file to the SQL Assistant bin folder, but still get the exact error.

Also copied the file and get the same error.

What about Run as Administrator mode? Does it make any difference?

By the way, the file you copied doesn't have the old error message, the format has been changed, the new message should end with DTE version number.

Nope. Started both in admin mode and the message is the same without version.
Here is my log of SSMS, maybe it will be helpful:
https://gofile.io/d/vWt89t