Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Maintenance Plan problem

Author  Topic 

PeterMcG
Starting Member

3 Posts

Posted - 2013-02-11 : 07:19:50
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

Any help appreciated.

prett
Posting Yak Master

212 Posts

Posted - 2013-02-13 : 06:24:38
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.

Go to Top of Page

PeterMcG
Starting Member

3 Posts

Posted - 2013-02-15 : 09:33:20
The SSIS and SQL Server Agent services are both set to automatic startup and both are started but I am still getting the error.
Go to Top of Page

PeterMcG
Starting Member

3 Posts

Posted - 2013-02-21 : 04:00:18
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
Go to Top of Page
   

- Advertisement -