SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Maintenance Plan problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

PeterMcG
Starting Member

3 Posts

Posted - 02/11/2013 :  07:19:50  Show Profile  Reply with Quote
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

USA
195 Posts

Posted - 02/13/2013 :  06:24:38  Show Profile  Visit prett's Homepage  Reply with Quote
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.


Edited by - prett on 02/13/2013 06:27:57
Go to Top of Page

PeterMcG
Starting Member

3 Posts

Posted - 02/15/2013 :  09:33:20  Show Profile  Reply with Quote
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 - 02/21/2013 :  04:00:18  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000