SQL Server 2025 Public Preview Maintenance Wizard plan runtime error

Shervey, Jeff 1 Reputation point

2 issues with Maintenance Plans - for some reason now I cant modify or create any new Maint Plans. Not available and greyed out.

When creating any Maintenance wizard plans such as "Misc Cleanup" or DB "Integrity check" scans I am getting this error when I execute: Message

Executed as user: NT Service\SQLAgent$SQL2025. Microsoft (R) SQL Server Execute Package Utility Version 17.0.700.9 for 32-bit Copyright (C) 2025 Microsoft. All rights reserved. Started: 11:59:25 AM Error: 2025-07-01 11:59:26.37 Code: 0xC0024102 Source: Reporting Task for subplan-{4FDDD68F-25DA-4E08-9117-DB03F194A2D3} Description: The Validate method on the task failed, and returned error code 0x80070002 (Could not load file or assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' or one of its dependencies. The system cannot find the file specified.). The Validate method must succeed and indicate the result using an "out" parameter. End Error Error: 2025-07-01 11:59:26.37 Code: 0xC0024107 Source: Reporting Task for subplan-{4FDDD68F-25DA-4E08-9117-DB03F194A2D3} Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:59:25 AM Finished: 11:59:26 AM Elapsed: 0.438 seconds. The package execution failed. The step failed.

Note: Ola Hallengren Integrity scan and index optimize jobs have no issues running in SQL Agent Jobs

0 comments No comments
Sign in to comment

Answer recommended by moderator

Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

Hi Shervey, Jeff,

Thank you for your detailed explanation. It looks like you've already followed the recommended steps, but the issue persists.

To help resolve this further, I recommend raising a support ticket so our support team can assist you directly. Please refer to the following link for instructions on how to create a support ticket:

https://support.serviceshub.microsoft.com/supportforbusiness/create

We appreciate your engagement and thank you for being an active part of the community.

Thanks,

Lakshmi.

0 comments No comments
Sign in to comment

1 additional answer

  1. Erland Sommarskog 134.7K Reputation points • MVP • Volunteer Moderator

    Originally, when SSMS 21 was released, support for maintenance plans (and SSIS in generate) were missing. They added it back in SSMS 21.2.5, but it seems that just upgrading is not enough. I'm on later version, and like you I find that the alternatives are greyed out. I investigate this on the SSMS Feedback site. I found that just upgrading to 21.2.5, but you need an extra step when installing, as described here: https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-release-of-sql-server-management-studio-ssms-21-2-5/4422488

    I'm uncertain about the other errors, but try to sort out your SSMS installation first.

    Note: Ola Hallengren Integrity scan and index optimize jobs have no issues running in SQL Agent Jobs

    Of course, less moving parts, greater flexibility. And protection against permission hijacking. No wonder Ola's solution is so popular.

    1. Shervey, Jeff 1 Reputation point

      SQL Server 2025 RTM "Standard Developer" is having the same exact error. Cant run Maint Wizard SQL Agent Jobs.

    2. Erland Sommarskog 134.7K Reputation points • MVP • Volunteer Moderator

      I tested this, and I had no problems of getting maintenance plans to work on SQL 2025 Standard Developer Edition.

      What version of SSMS do you have installed? Have you ensured that you have installed the components for SSIS? Did you include Integration Services when you installed SQL Server?

    3. Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

      Hi Shervey, Jeff,

      I'm following up to check if the response provided below was helpful.

      Please let us know if your issue has been resolved. If you still have any questions or need further assistance, don't hesitate to get in touch we're happy to continue supporting you.

      We appreciate your participation and thank you for being an active member of the community.

      Best regards,

      Lakshmi

    4. Lakshmi Narayana Garikapati 1,330 Reputation points • Microsoft External Staff • Moderator

      Hi Shervey, Jeff,

      I'm following up to check if the response provided below was helpful.

      Please let us know if your issue has been resolved. If you still have any questions or need further assistance, don't hesitate to get in touch we're happy to continue supporting you.

      We appreciate your participation and thank you for being an active member of the community.

      Best regards,

      Lakshmi

    5. Shervey, Jeff 1 Reputation point

      Yes - going back and adding "Integration Services" fixed the issue. Its just that I don't remember having to install Integration Services with older releases...2022,2019,17,16,14,12. And always have used Maint wizard since then.

    Sign in to comment
Sign in to answer

Your answer