Edit

Share via

Known issues in SQL Server Management Studio

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

This article lists known issues for SQL Server Management Studio 22.

Feature Details Workaround
Analysis Services After adding a new role, or when opening properties for an existing role, you can't use Search by name or email address to add a user. Add users with the Manual Entry option.
Arm64 There is no support for SSAS, SSRS, and SSIS on Arm64 devices. Run SSAS, SSRS, or SSIS on a device that isn't Arm64.
Arm64 - Data Classification A LoadLibrary failure error message is displayed if you try to set Microsoft Information Protection Policy. There's no workaround.
Arm64 - Profiler Trying to run Profiler results in an exception. Run Profiler on a device that isn't Arm64.
Arm64 - Replication Trying to bring up the "Distributor Properties" form results in an exception. Run SSMS on a device that isn't Arm64.
Available Databases Menu A transient issue can cause the Available Databases dropdown menu to render incorrectly. Change context to a different database with USE <DatabaseName> in the query editor.
Connection You can't import connections from a previous version. This issue will be resolved in a later preview. There's no workaround.
Connection Trying to connect to a SQL Server instance using Strict encryption through shared memory generates the error Request is not supported. See "Shared Memory Provider, error: 15 - Function not supported" with Encrypt=Strict. Retry the connection. This error will be addressed in a future release of SSMS 22.
Designers The JSON data type isn't available for columns when creating or editing a table in Table Designer. See SSMS 21.0 Preview 2.0 - Table Designer missing the "json" datatype. Use T-SQL to add columns with the JSON data type, this functionality is planned for a later release.
Designers Unable to use SSMS after closing the New View pane when the Add Table dialog is left open. See SSMS 21 Preview 1: New View window "Add Table" not aware I closed out of New View. Close the Add Table dialog before closing the view pane.
Extended Events The Specify Data Storage page is truncated in the Extended Events Wizard. See Extended Events Wizard is cut off on Specify Data Storage page. Use the New Session... option to create an Extended Events session.
Generate Scripts Wizard When using the Generate Scripts wizard, the Set Scripting Options section generates the error Object reference not set to an instance of an object. Use an earlier version of SSMS.
GitHub Copilot in SSMS (Preview) Selecting F5 or Execute executes all T-SQL queries in a query editor, when reviewing code suggestions. Don't select F5 or Execute when reviewing code suggestions.
Menu Opening a folder from File > Recent Projects and Solutions generates one of the following errors: System.InvalidOperationException: Can't enqueue project dependencies calculation before starting solution load or An exception of type NullReferenceException has been encountered. if opening the folder also opens one or more files that were open in the editor when the folder was last closed. Closing the error allows work to continue. Alternatively, close all files in the editor before closing a folder.
Modern Connection Dialog (Preview) Trying to change the password for a newly created SQL login with the MUST_CHANGE property enabled generates the error "Login failed for user. Reason: The password of the account must be changed. (Microsoft SQL Server, Error: 18488)". See Instead of Change password dialog an error pops up. Use the Classic connection dialog to change the password.
Offline installation Installing an offline instance of SQL Server Management Studio 21 silently fails, with a certificate is invalid error message in the installation log. Download and install the Microsoft Windows Code Signing PCA 2024 certificate. For more information, see Create an offline installation of SQL Server Management Studio.
Options Enabling Per Monitor Awareness (PMA) by checking Optimize rendering for screens with different pixel densities (requires restart) within Tools > Options can cause issues with dialogs not rendering. Don't enable Optimize rendering for screens with different pixel densities (requires restart) within Tools > Options.
Options Enabling Unified Settings Experience (requires restart) within Tools > Options > General > Preview Features can cause issues with dialogs not rendering. Don't enable Unified Settings Experience (requires restart) within Tools > Options > General > Preview Features.
Options Changing the default value for options within Tools > Options > General > Preview Features can cause unpredictable behavior, both in terms of visual display and functionality. Don't change the default value for any option within Tools > Options > General > Preview Features.
Query Store When you use any of the Query Store reports, the Replica dropdown menu option might not populate with the correct replica name when the Query Store for readable secondaries is enabled. Use Transact-SQL to query the Query Store data for a readable secondary where the replica_group_id for a secondary can be mapped using the sys.query_store_runtime_stats system catalog view, which has a foreign key relationship with the sys.query_store_replicas system catalog view.
Results Pane When you switch themes, if the output is set to Results to Text, the Results pane doesn't switch to the new theme. To apply any theme changes to the Results pane, restart SSMS.
Solution Explorer SQL connections are no longer being saved in the Connections entry in the Solution Explorer. Use an earlier version of SSMS.
SQL Server Integration Services (SSIS) Maintenance Tasks (including Back Up Database Task, Check Database Integrity Task, Execute SQL Server Agent Job Task, Execute T-SQL Statement Task, History Cleanup Task, and Maintenance Cleanup Task) aren't supported by Execute Package Utility (dtexecui). Use dtexec Utility to run packages including these Maintenance Tasks or use Execute Package Utility (dtexecui) in SSMS 20.
SQL Server Integration Services (SSIS) SSIS Integration Runtime creation wizard isn't supported. Use Azure Data Factory portal to Create an Azure-SSIS integration runtime.
SQL Server Integration Services (SSIS) Using the Execute Package Utility (dtexecui) to run Integration Packages with Script Task fails. Manually download and install Microsoft Visual Studio for Applications 2022 first, before running package execution.
Vector Renaming a vector index using T-SQL or in Object Explorer generates the error Invalid EXECUTE statement using object "IndexOrStats", method "SetName". There's currently no workaround.

Related content

  • Last updated on