Known issues in SQL Server Management Studio 21 Preview
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
This page lists known issues for SQL Server Management Studio 21 Preview.
Feature | Details | Workaround |
---|---|---|
Analysis Services | There's currently no support for Analysis Services in SQL Server Management Studio 21 Preview. | Use SSMS 20.2 to connect to Analysis Services, we'll bring back Analysis Services in a future preview. |
Arm64 | There's no support for Arm64, and SSMS can't be installed on Arm64 devices. | Run SSMS on a device that isn't Arm64. |
Database Diagrams | Closing a new database diagram before saving generates the error "Object reference not set to an instance of an object. (SqlEditors)". | Save the new database diagram before closing the editor in Database Diagrams. |
Designers | Closing the view editor before saving in the View Designer generates the error "Object reference not set to an instance of an object. (SqlEditors)". | Save the new view before closing the editor in the View Designer. |
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. |
Integration Services | There's currently no support for Integration Services in SQL Server Management Studio 21 Preview. | Use SSMS 20.2 to connect to Integration Services, we'll bring back Integration Services in a future preview. |
Logins | Unable to map a credential for a login. See SSMS v21 Preview 1 - Bug in Login Properties for Credentials. | Use T-SQL to map a login to a credential. |
Maintenance Plans | There's currently no support for creating or editing maintenance plans in SQL Server Management Studio 21 Preview. | Use SSMS 20.2 to create or edit maintenance plans, we'll bring back Integration Services in a future preview. |
Menu | The File > File menu option isn't available. | Use File > New Query with current connection or the New Query button to open a new query editor. |
Menu | Opening a folder from File > Recent Projects and Solutions generates one of the following errors: "System.InvalidOperationException: Can't enque 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. |
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. |
Settings | Changing font settings doesn't persist after a restart. See SSMS 21 Preview 1 - Environment Font Settings Not saving in a particular use-case. | Change the theme at the same time as the font settings. |
Terminal | Using Developer PowerShell or Developer Command Prompt from View > Terminal generates an error. See SSMS 21 Preview - Visual Studio developer prompt options should probably be hidden or removed. | Customize the file that launches through customize what launches in SSMS, through Tools > Options > Environment > Terminal. A fix is expected in a future preview. |