how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

Martínez Peña Eusebio II 0 Reputation points
2025-10-24T19:17:53.62+00:00

how to fix maintinence plans wizard for SQL Server 2022 this is unavailable

SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
    2025-10-24T20:50:46.9866667+00:00

    You don't give much details, so I will have to do some guessworks and my answer may not match your situation. If so, please provide more details.

    Originally, when SSMS 21 was released, support for SSIS and maintenance plans was not present. This was added in later releases. However, it is an optional component, so just upgrading SSMS 21 is not enough.

    You need to go to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms to download vs_SSMS.exe (unless you know where you have it locally). Start it, and then select Modify:

    User's image

    In the screen you get, select SSIS:

    User's image

    This will also select SSAS.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.