Problem creating a Maintenance Plan

When trying to create a maintenance plan using the wizard to backup the
system databases in SQL 2005 the following error is displayed.
How can I find what is causing this problem with a simple maintenance
plan?
Maintenance Plan Wizard Progress
- Creating maintenance plan "SystemDBs Backup" (Error)
Messages
* Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "SystemDBs Backup" (Stopped)Did you install Integration Services?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<robin9876@.hotmail.com> wrote in message
news:1165336377.424898.184600@.16g2000cwy.googlegroups.com...
> When trying to create a maintenance plan using the wizard to backup the
> system databases in SQL 2005 the following error is displayed.
> How can I find what is causing this problem with a simple maintenance
> plan?
>
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "SystemDBs Backup" (Error)
> Messages
> * Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "SystemDBs Backup" (Stopped)
>|||Integration Services are not installed on this server but other servers
without it the plans can be created.
Tibor Karaszi wrote:
> Did you install Integration Services?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <robin9876@.hotmail.com> wrote in message
> news:1165336377.424898.184600@.16g2000cwy.googlegroups.com...
> > When trying to create a maintenance plan using the wizard to backup the
> > system databases in SQL 2005 the following error is displayed.
> >
> > How can I find what is causing this problem with a simple maintenance
> > plan?
> >
> >
> > Maintenance Plan Wizard Progress
> >
> > - Creating maintenance plan "SystemDBs Backup" (Error)
> > Messages
> > * Create maintenance plan failed.
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > Create failed for JobStep 'Subplan'.
> > (Microsoft.SqlServer.MaintenancePlanTasks)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> >
> > --
> >
> > An exception occurred while executing a Transact-SQL statement or
> > batch. (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > The specified '@.subsystem' is invalid (valid values are returned by
> > sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> >
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> >
> >
> > - Adding tasks to the maintenance plan (Stopped)
> >
> > - Adding scheduling options (Stopped)
> >
> > - Adding reporting options (Stopped)
> >
> > - Saving maintenance plan "SystemDBs Backup" (Stopped)
> >|||I see... Well, to the best of my knowledge, you need SSIS to execute an MP (in 2005), since an MP is
an SSIS package.
I've heard that you won't need this with sp2, but sp2 is still only in CTP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<robin9876@.hotmail.com> wrote in message
news:1165355311.079516.289340@.j72g2000cwa.googlegroups.com...
> Integration Services are not installed on this server but other servers
> without it the plans can be created.
> Tibor Karaszi wrote:
>> Did you install Integration Services?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <robin9876@.hotmail.com> wrote in message
>> news:1165336377.424898.184600@.16g2000cwy.googlegroups.com...
>> > When trying to create a maintenance plan using the wizard to backup the
>> > system databases in SQL 2005 the following error is displayed.
>> >
>> > How can I find what is causing this problem with a simple maintenance
>> > plan?
>> >
>> >
>> > Maintenance Plan Wizard Progress
>> >
>> > - Creating maintenance plan "SystemDBs Backup" (Error)
>> > Messages
>> > * Create maintenance plan failed.
>> >
>> > --
>> > ADDITIONAL INFORMATION:
>> >
>> > Create failed for JobStep 'Subplan'.
>> > (Microsoft.SqlServer.MaintenancePlanTasks)
>> >
>> > For help, click:
>> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>> >
>> > --
>> >
>> > An exception occurred while executing a Transact-SQL statement or
>> > batch. (Microsoft.SqlServer.ConnectionInfo)
>> >
>> > --
>> >
>> > The specified '@.subsystem' is invalid (valid values are returned by
>> > sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
>> >
>> > For help, click:
>> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> >
>> >
>> > - Adding tasks to the maintenance plan (Stopped)
>> >
>> > - Adding scheduling options (Stopped)
>> >
>> > - Adding reporting options (Stopped)
>> >
>> > - Saving maintenance plan "SystemDBs Backup" (Stopped)
>> >
>