Share via

SQL Server 2025 Public Preview Maintenance Wizard plan runtime error

Shervey, Jeff 1 Reputation point
2025-07-01T20:39:25.7266667+00:00

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

SQL Server Database Engine
0 comments

Answer recommended by moderator

Lakshmi Narayana Garikapati 1,315 Reputation points Microsoft External Staff Moderator
2026-01-19T09:39:12.7666667+00:00

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.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator
    2025-07-01T21:17:57.7066667+00:00

    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.

    Was this answer helpful?

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.