When selecting 'New Maintenance Plan' I get the following: "object reference not set to an instance of an object" I can create a plan using the wizard but get the same error when trying to modify it. SQL Server 2012: Microsoft SQL Server Management Studio 11.0.2100.60 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.296 Operating System 6.1.7601
The Maintenance Plan is actually built with few services which Microsoft releases such as SSIS and SQL Server Job Agent, hence if you want to schedule the maintenance plan then your server needs to have SSIS in order to build the maintenance plan, and Job Agent in order to run at regular periods.
This error message "Object reference not set to an instance of an object" occurs because of one of the required component was not available on the server.
I have installed SQL Server 2012 SP1 and this has not helped either.
Microsoft SQL Server Management Studio 11.0.3000.0 Microsoft Data Access Components (MDAC)6.1.7601.17514 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.296 Operating System 6.1.7601
Maintenance Plan problem
Posted - 02/11/2013 : 07:19:50
