SSMS 19 Preview 4 gives error while opening

NathanSundararajan

SQL Prompt in SSMS 19 preview 4 giving error.
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.

Ben_P

Hi Nathan,

Thank you for your post. 

SQL Prompt does not currently support SSMS 19 preview 4. It supports up to preview 2. 

DonFerguson

Me too.  I was on preview 3 and it was working.  I installed preview 4 and a bunch of the toolbelt tools started reporting errors to include SQL Prompt.  I tried uninstalling SQL Prompt and reinstalling it to no avail.  So in the end I removed preview 4 and reinstalled preview 3 and things went back to normal.   

torsten.strauss

Same here! I had to deinstall all RedGate Tools to fix it. Even after reinstalling SSMS and SQL Toolbet same error. It would be good to get a fix for the issue - thanks!

ostandage

Hi, 

We've released SQL Prompt 10.13.3 which adds support for SSMS Preview 4, you can download it here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.3.32087.exe

Release notes: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes

Thanks,

Owen

NathanSundararajan

Thanks ostandage. Will try and will update here. 

ganners999

Hi

I downloaded SQL prompt 10.13.3.32087 and I am now getting the error with SSMS Preview 2.

Do I need to update to preview 4?

Paul

ostandage

Hi @ganners999

Yes, if you upgrade to preview 4 it should start working again.

Thanks

Owen

ganners999

ostandage said:

Hi @ganners999

Yes, if you upgrade to preview 4 it should start working again.

Thanks

Owen

I've switched back to SSMS 18. The preview 4 version started throwing DLL errors on attempting to connect.

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.Data.SqlClient)

torsten.strauss

Thanks for the update. It works with Preview Version 4!

dbc

ganners999 said:

ostandage said:

Hi @ganners999

Yes, if you upgrade to preview 4 it should start working again.

Thanks

Owen

I've switched back to SSMS 18. The preview 4 version started throwing DLL errors on attempting to connect.

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x86.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) (Microsoft.Data.SqlClient)

I got the same error with SSMS 19.4.
Fixed it by running a repair install.