Issue:
Maintenance Plan option greyed out in SQL Server Management Studio version 21.
Fix:
Make sure SSIS is installed and “Business Intelligence” option is selected in the Visual Studio Installer. By default new SSMS 21, this feature is not enabled.
Note: SSMS 21 is based off of Visual Studio and uses Visual Studio Installer to install/modify features.
Note: SSIS feature is an add on to SQL Server Install. For an existing version of SQL Server, use the SQL Server Installer to add on new features to an existing installation.
Note: Just upgrading to the latest version of SSMS is not sufficient to get the SSIS functionality – please follow the instructions outlined in this blog post to learn more about Modifying your SSMS 21 instance to add the SSIS component.
SQL Server Integration Services (SSIS) (Preview)
SSIS is now available in Preview for installation with SSMS 21.2.5. You can install it by selecting Modify in the Visual Studio Installer, adding the Business Intelligence workload, or from the Individual components tab if you only want SSIS. If you are updating a previously installed version of SSMS 21, after the update has finished installing you will need to go back to the Visual Studio Installer and add the SSIS component from the Modify workflow.Add SQL Server Integration Services (SSIS) (Preview) from the Workloads tab in the Visual Studio Installer.
Related Articles:
https://developercommunity.visualstudio.com/t/SQL-Server-Management-Studio-21-no-edit-/10908340
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Comments