SQL Prompt 10.15.0.12121 Not Working in Visual Studio 2022

DataJedi

I'm running Visual Studio 2022 (Version 17.12.0) with SQL Server Data Tools (Version 17.12.78.0)

After installing the most recent update to SQL Prompt, I started receiving this error message when I open a database project in Visual Studio 2022:



A check of the error log revealed several messages related to UI libraries not loading:

Unable to load extension at: C:\PROGRAM FILES\MICROSOFT VISUAL STUDIO\2022\PROFESSIONAL\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLEDITOR\VSIX\. Exception text: Microsoft.VisualStudio.ExtensionManager.InvalidExtensionManifestException: Element 'Installation' is missing required child element 'InstallationTarget' or child element value is whitespace. at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ExtractManifestData(PackageManifest manifest) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ReadPackageManifest(XmlReader reader) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ReadManifest(Stream manifestStream) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl..ctor(String path) at Microsoft.VisualStudio.ExtensionManager.InstalledExtensionImpl..ctor(String vsixManifestPath, IEngineHost engineHost, Boolean installedPerMachine, CultureInfo preferredCulture, IList`1 extensionPackVsixIds, IList`1 packageGuids) at Microsoft.VisualStudio.ExtensionManager.ScanModule.TryLoadExtension(ExtensionLocations location, String fullPath, String normalizedPath, InstalledExtensionImpl& installedExtension, Int32 retryCount, Int32 retryDelay, Int32 attempts).

Need help troubleshooting this issue. Thanks.

JasonSelburg

Same issue here.

Ben_P

I've been able to replicate the issue locally, and so I've forwarded the issue to the development team for a fix. Once a fix is released, then I'll update this thread. As a temporary work around though, you can roll back to 10.14.23.11448 and this will work with VS 2022. 

10.14.23.11448

HenrikM

Same issue here

VS2022 and using v10.15.1

JasonSelburg

This appears to be resolved with the latest VS update 17.12.1

DataJedi

JasonSelburg said:

This appears to be resolved with the latest VS update 17.12.1

Unfortunately, no. I even uninstalled SQL Prompt, rebooted and reinstalled it. Same error.

Holger

Same problem. The error message appears even after uninstalling sqlprompt

Ben_P

Hi all, This should now be fixed with the latest release, and this also includes a fix for an issue in SSM that caused multiple copies of the same query to be opened from SQL History:

10.15.3.12768 - Released on 26 November 2024

Fixes

• Fixed an issue where multiple instances of the same query tab opened by SQL History in SSMS.
• Fixed SQL Prompt (15.1) that caused an error to appear while opening in Visual Studio.