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