Blog Post

SQL Server Blog
2 MIN READ

SQL Server Management Studio (SSMS) 19.0 Released!

erinstellato's avatar
erinstellato
Icon for Microsoft rankMicrosoft
Jan 26, 2023

The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!  

 

 

This is the recommended release for SQL Server 2022, and it includes support for combability level 160.  You can review the entire list of new functionality and fixes in the release notes, but we'd like to call out a few highlights here:

 

In addition, we received a lot of feedback about the dialog box, "Querying transaction count", we introduced back in SSMS 18.11.   In 18.12, we added an option to cancel the check if it took more than two seconds, but user comments indicated that was not enough.  Therefore, in SSMS 19.0 you have the ability to disable to dialog box completely.  Within Tools > Options > Query Execution, simply uncheck the option "Check for open transactions before closing T-SQL query windows".  

 

For those who installed a preview version of SSMS 19 (thank you!), it's recommended to uninstall that version before installing SSMS 19.0.  Please note that if you have an earlier release of SSMS (e.g., 18.x), you can install 19.0 side-by-side with that version.

 

We know many of you have been looking forward to this release, and we appreciate your patience.  Please know that we do monitor the feedback you all provide, and items that have steps to recreate (in the case of bugs), real-world examples (in the case of requests), constructive comments, and upvotes are extremely helpful to us.  We have a few tasks to finish up, including making a standalone download for Distributed Replay available, but know that we are already planning for the next release.  We look forward to hearing from you, whether you just want to be on the latest version of SSMS, or you're upgrading to SQL 2022.  And if it's the latter, good luck with your upgrade, and as always, test your backups!

Updated Feb 03, 2025
Version 2.0
sqlserver2022
sqltools

78 Comments

Show More
  • Pablo_Lerner's avatar
    Pablo_Lerner
    Brass Contributor
    Feb 01, 2023

    I use some external extensions which work slowly. The extension developers blame the fact that SSMS is a 32bit application, meaning their code can't get all the necessary RAM memory needed. Is there any plans to compile SSMS as a 64 bit application?

  • erinstellato's avatar
    erinstellato
    Icon for Microsoft rankMicrosoft
    Feb 01, 2023

    Hi SQLBIDEV  - did you take any action based on the information in the error?  It references https://aka.ms/msal-net-iwa-troubleshooting, which includes troubleshooting steps.  You may need to get your network folks involved, there are changes related to Integrated Windows Auth and MSAL that may require updates in your environment.  We have other customers who are able to successfully connect to their endpoint with SSMS 19.0.

     

    Erin

  • SQLBIDEV's avatar
    SQLBIDEV
    Copper Contributor
    Feb 01, 2023

    erinstellato Are you aware of any bugs connecting to the Power BI XMLA Endpoint with SSMS 19.0?

    It works fine in SSMS 18. But when I try to log in to the Power BI XMLA Endpoint in SSMS 19, I get an error. This happens on multiple machines with multiple users.

     

    UNABLE TO OBTAIN AUTHENTICATION TOKEN USING THE CREDENTIALS PROVIDED

    THERE WAS AN ERROR PARSING WS-TRUST RESPONSE FROM THE ENDPOINT

     

    I already tried uninstalling and reinstalling a few times, and reinstalling/upgrading my ADO/OLEDB/ASP components (all the ones required) to the latest versions.

     

    Does SSMS 19 still support connecting to the Power BI XMLA Endpoint that was added in version 18.5?

     

     

     

     

     

  • erinstellato's avatar
    erinstellato
    Icon for Microsoft rankMicrosoft
    Jan 30, 2023

    Hi PatSimo - we don't have plans to add the debugger back to SSMS.  You can use the debugger in the Visual Studio community edition.

    Thanks,

    Erin

  • misiraj's avatar
    misiraj
    Copper Contributor
    Jan 27, 2023

    About Distributed Availability Group, does this SSMS-19 supports to view the Databases or components of it?. Till earlier version 18.x, no object is visible. 

     

    Thank you.