How can we help you today? How can we help you today?

SQL Prompt 10.15.0.12121 Not Working in Visual Studio 2022

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.
DataJedi
0

Comments

7 comments

Sort by
  • JasonSelburg
    Same issue here.
    JasonSelburg
    0
  • 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

    Ben_P
    0
  • HenrikM
    Same issue here

    VS2022 and using v10.15.1
    HenrikM
    0
  • JasonSelburg
    This appears to be resolved with the latest VS update 17.12.1
    JasonSelburg
    0
  • DataJedi
    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.


    DataJedi
    0
  • Holger
    Same problem. The error message appears even after uninstalling sqlprompt
    Holger
    0
  • 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.

    Ben_P
    0

Add comment

Please sign in to leave a comment.