SSMS 19 Preview 4 gives error while opening

• 
  Hi Nathan,
  
  Thank you for your post. 
  
  SQL Prompt does not currently support SSMS 19 preview 4. It supports up to preview 2. 
  

  Ben_P December 20, 2022 19:09

  - 0 +
• 
  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.

  DonFerguson December 30, 2022 18:32

  - 0 +
• 
  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!
  

  torsten.strauss January 03, 2023 11:24

  - 0 +
• 
  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

  ostandage January 04, 2023 16:02

  - 0 +
• 
  Thanks ostandage. Will try and will update here.

  NathanSundararajan January 04, 2023 16:51

  - 0 +
• 
  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

  ganners999 January 06, 2023 10:13

  - 0 +
• 
  Hi @ganners999
  
  Yes, if you upgrade to preview 4 it should start working again.
  
  Thanks
  
  Owen

  ostandage January 06, 2023 11:04

  - 0 +
• 

  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)
  

  ganners999 January 06, 2023 11:06

  - 0 +
• 
  Thanks for the update. It works with Preview Version 4!

  torsten.strauss January 06, 2023 11:43

  - 0 +
• 

  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.

  dbc January 11, 2023 11:56

  - 0 +

Add comment

Please sign in to leave a comment.