Posts

Showing posts from April, 2026

SOLVED: "New Maintenance Plan" and "Maintenance Plan Wizard" are greyed out for SQL Server 2025 (This feature is not currently available in this version)

Image
In SQL Server Management Studio SSMS you may find that the menu options New Maintenance Plan and Maintenance Plan Wizard  are greyed out and hovering over these menu items displays the tooltip "This feature is not currently available in this version". The menu options New Maintenance Plan and Maintenance Plan Wizard are greyed out To resolve this issue run the SQL Server Management Studio  installation and modify the existing installation. Select the "Business Intelligence" option and ensure that "SQL Server Integration Services" is checked. After updating the installation the menu options will be available.
Post a Comment
Read more

SQL Management Objects (SMO) Error: Could not load type 'Microsoft.Data.SqlClient.SqlAuthenticationMethod' from assembly 'Microsoft.Data.SqlClient, Version=7.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'.

If you're trying to use SQL Managent Objects (SMO) with the latest SQL Client (v7.0.0) then you might notice the following error: Could not load type 'Microsoft.Data.SqlClient.SqlAuthenticationMethod' from assembly 'Microsoft.Data.SqlClient, Version=7.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5'. This is a coding issue that's being tracked here - a new package should be available (currently 9th April 2026). https://github.com/dotnet/SqlClient/issues/4064
Post a Comment
Read more