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.
| 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.60Microsoft Data Access Components (MDAC) 6.1.7601.17514Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16421Microsoft .NET Framework 4.0.30319.296Operating System 6.1.7601Any 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. |
 |
|
|
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. |
|
|
|
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.0Microsoft Data Access Components (MDAC)6.1.7601.17514Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.0.8112.16421Microsoft .NET Framework 4.0.30319.296Operating System 6.1.7601 |
|
|
|
|
|
|
Maintenance Plan problem