"Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
news:07FDD247-34D0-4F03-8BFB-E669E8E51829@microsoft.com...
>I am running Windows Small Business server 2003 R2 and I've upgraded the
> Sharepoint from MSDE to SQL 2005.  I'm trying to create a Database
> maintenance plan to backup the Sharepoint database but I'm getting an error
> message.  I've pasted the messaged below:Create maintenance plan failed.
>
> TITLE: Maintenance Plan Wizard Progress
> ------------------------------
>
> 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
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
> ===================================
>
> 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
>
> ------------------------------
> Program Location:
>
>   at
> Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection
> localConnObj, String proxyName)
>   at
> Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String
> subplanName, String proxyAccount, Package package, ServerConnection
> localConnObj)
>   at
> Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String subplanName,
> String proxyAccount)
>   at
> Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
>
> ===================================
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> Program Location:
>
>   at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
>   at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
> sqlCommands, ExecutionTypes executionType)
>   at
> Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
>   at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean
> includeDbContext)
>   at
> Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery,
> ScriptingOptions so)
>   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
>
> ===================================
>
> The specified '@subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
>
> ------------------------------
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>
> ------------------------------
> Server Name: SERVER1\SHAREPOINT
> Error Number: 14234
> Severity: 16
> State: 1
> Procedure: sp_verify_subsystem
> Line Number: 28
>
>
> ------------------------------
> Program Location:
>
>   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
>   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
>   at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
>   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
>   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> methodName, Boolean async)
>   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> result, String methodName, Boolean sendToPipe)
>   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>   at
> Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> sqlCommand, ExecutionTypes executionType)
>

"Tibor Karaszi" wrote:

> Did you install Integration Services?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
> news:07FDD247-34D0-4F03-8BFB-E669E8E51829@microsoft.com...
> >I am running Windows Small Business server 2003 R2 and I've upgraded the
> > Sharepoint from MSDE to SQL 2005.  I'm trying to create a Database
> > maintenance plan to backup the Sharepoint database but I'm getting an error
> > message.  I've pasted the messaged below:Create maintenance plan failed.
> >
> > TITLE: Maintenance Plan Wizard Progress
> > ------------------------------
> >
> > 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
> >
> > ------------------------------
> > BUTTONS:
> >
> > OK
> > ------------------------------
> >
> > ===================================
> >
> > 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
> >
> > ------------------------------
> > Program Location:
> >
> >   at
> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection
> > localConnObj, String proxyName)
> >   at
> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String
> > subplanName, String proxyAccount, Package package, ServerConnection
> > localConnObj)
> >   at
> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String subplanName,
> > String proxyAccount)
> >   at
> > Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
> >
> > ===================================
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > ------------------------------
> > Program Location:
> >
> >   at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> > sqlCommand, ExecutionTypes executionType)
> >   at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
> > sqlCommands, ExecutionTypes executionType)
> >   at
> > Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
> >   at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean
> > includeDbContext)
> >   at
> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery,
> > ScriptingOptions so)
> >   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
> >
> > ===================================
> >
> > The specified '@subsystem' is invalid (valid values are returned by
> > sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
> >
> > ------------------------------
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> >
> > ------------------------------
> > Server Name: SERVER1\SHAREPOINT
> > Error Number: 14234
> > Severity: 16
> > State: 1
> > Procedure: sp_verify_subsystem
> > Line Number: 28
> >
> >
> > ------------------------------
> > Program Location:
> >
> >   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> > Boolean breakConnection)
> >   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection)
> >   at
> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> > stateObj)
> >   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> > bulkCopyHandler, TdsParserStateObject stateObj)
> >   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> > methodName, Boolean async)
> >   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> > result, String methodName, Boolean sendToPipe)
> >   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> >   at
> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> > sqlCommand, ExecutionTypes executionType)
> >
>
>

"Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
news:BDC49606-300E-4BEA-8CE1-083026C6C00F@microsoft.com...
> no, I didn't.  I did some more searches and found some fixes for it.
>
> Actually what fixed it for me was SQL 2005 SP1.
>
> "Tibor Karaszi" wrote:
>
>> Did you install Integration Services?
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
>> news:07FDD247-34D0-4F03-8BFB-E669E8E51829@microsoft.com...
>> >I am running Windows Small Business server 2003 R2 and I've upgraded the
>> > Sharepoint from MSDE to SQL 2005.  I'm trying to create a Database
>> > maintenance plan to backup the Sharepoint database but I'm getting an error
>> > message.  I've pasted the messaged below:Create maintenance plan failed.
>> >
>> > TITLE: Maintenance Plan Wizard Progress
>> > ------------------------------
>> >
>> > 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
>> >
>> > ------------------------------
>> > BUTTONS:
>> >
>> > OK
>> > ------------------------------
>> >
>> > ===================================
>> >
>> > 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
>> >
>> > ------------------------------
>> > Program Location:
>> >
>> >   at
>> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection
>> > localConnObj, String proxyName)
>> >   at
>> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String
>> > subplanName, String proxyAccount, Package package, ServerConnection
>> > localConnObj)
>> >   at
>> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String
>> > subplanName,
>> > String proxyAccount)
>> >   at
>> > Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
>> >
>> > ===================================
>> >
>> > An exception occurred while executing a Transact-SQL statement or batch.
>> > (Microsoft.SqlServer.ConnectionInfo)
>> >
>> > ------------------------------
>> > Program Location:
>> >
>> >   at
>> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> > sqlCommand, ExecutionTypes executionType)
>> >   at
>> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
>> > sqlCommands, ExecutionTypes executionType)
>> >   at
>> > Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
>> >   at
>> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries,
>> > Boolean
>> > includeDbContext)
>> >   at
>> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery,
>> > ScriptingOptions so)
>> >   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
>> >
>> > ===================================
>> >
>> > The specified '@subsystem' is invalid (valid values are returned by
>> > sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
>> >
>> > ------------------------------
>> > For help, click:
>> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> >
>> > ------------------------------
>> > Server Name: SERVER1\SHAREPOINT
>> > Error Number: 14234
>> > Severity: 16
>> > State: 1
>> > Procedure: sp_verify_subsystem
>> > Line Number: 28
>> >
>> >
>> > ------------------------------
>> > Program Location:
>> >
>> >   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>> > Boolean breakConnection)
>> >   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> > exception, Boolean breakConnection)
>> >   at
>> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>> > stateObj)
>> >   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> > bulkCopyHandler, TdsParserStateObject stateObj)
>> >   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
>> > methodName, Boolean async)
>> >   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
>> > result, String methodName, Boolean sendToPipe)
>> >   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>> >   at
>> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> > sqlCommand, ExecutionTypes executionType)
>> >
>>
>>

"Tibor Karaszi" wrote:

> > Actually what fixed it for me was SQL 2005 SP1.
>
> Interesting. A Maint Plan in 2005 is an SSIS package, so I would expect a requirement for using 2005
> Maint Plans is to have SSIS installed. Perhaps they did some special handling of Maint Plans SSIS
> packages...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
> news:BDC49606-300E-4BEA-8CE1-083026C6C00F@microsoft.com...
> > no, I didn't.  I did some more searches and found some fixes for it.
> >
> > Actually what fixed it for me was SQL 2005 SP1.
> >
> > "Tibor Karaszi" wrote:
> >
> >> Did you install Integration Services?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
> >> news:07FDD247-34D0-4F03-8BFB-E669E8E51829@microsoft.com...
> >> >I am running Windows Small Business server 2003 R2 and I've upgraded the
> >> > Sharepoint from MSDE to SQL 2005.  I'm trying to create a Database
> >> > maintenance plan to backup the Sharepoint database but I'm getting an error
> >> > message.  I've pasted the messaged below:Create maintenance plan failed.
> >> >
> >> > TITLE: Maintenance Plan Wizard Progress
> >> > ------------------------------
> >> >
> >> > 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
> >> >
> >> > ------------------------------
> >> > BUTTONS:
> >> >
> >> > OK
> >> > ------------------------------
> >> >
> >> > ===================================
> >> >
> >> > 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
> >> >
> >> > ------------------------------
> >> > Program Location:
> >> >
> >> >   at
> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection
> >> > localConnObj, String proxyName)
> >> >   at
> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String
> >> > subplanName, String proxyAccount, Package package, ServerConnection
> >> > localConnObj)
> >> >   at
> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String
> >> > subplanName,
> >> > String proxyAccount)
> >> >   at
> >> > Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
> >> >
> >> > ===================================
> >> >
> >> > An exception occurred while executing a Transact-SQL statement or batch.
> >> > (Microsoft.SqlServer.ConnectionInfo)
> >> >
> >> > ------------------------------
> >> > Program Location:
> >> >
> >> >   at
> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> >> > sqlCommand, ExecutionTypes executionType)
> >> >   at
> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
> >> > sqlCommands, ExecutionTypes executionType)
> >> >   at
> >> > Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
> >> >   at
> >> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries,
> >> > Boolean
> >> > includeDbContext)
> >> >   at
> >> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery,
> >> > ScriptingOptions so)
> >> >   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
> >> >
> >> > ===================================
> >> >
> >> > The specified '@subsystem' is invalid (valid values are returned by
> >> > sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
> >> >
> >> > ------------------------------
> >> > For help, click:
> >> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> >> >
> >> > ------------------------------
> >> > Server Name: SERVER1\SHAREPOINT
> >> > Error Number: 14234
> >> > Severity: 16
> >> > State: 1
> >> > Procedure: sp_verify_subsystem
> >> > Line Number: 28
> >> >
> >> >
> >> > ------------------------------
> >> > Program Location:
> >> >
> >> >   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> >> > Boolean breakConnection)
> >> >   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> >> > exception, Boolean breakConnection)
> >> >   at
> >> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> >> > stateObj)
> >> >   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> >> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> >> > bulkCopyHandler, TdsParserStateObject stateObj)
> >> >   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
> >> > methodName, Boolean async)
> >> >   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
> >> > result, String methodName, Boolean sendToPipe)
> >> >   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> >> >   at
> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
> >> > sqlCommand, ExecutionTypes executionType)
> >> >
> >>
> >>
>
>

"ipconfig2" <ipconf***@discussions.microsoft.com> wrote in message
news:ACB0178F-4294-46AF-943F-1D832A4BC2F8@microsoft.com...
> Hi Tibor
>
> I have an issue on a newly buildt SQL2005 cluster. I didn't install the SSIS
> at first but then added the service. However I still have the same problems
> and I wonder if I need to reinstall the Management Tools in order to get it
> to work?
>
> I have a case with support and we verified that both nodes are running the
> SSIS service but the creation/saving of Maintenance plans fails. Any
> experience with this?
>
> Rune
>
> "Tibor Karaszi" wrote:
>
>> > Actually what fixed it for me was SQL 2005 SP1.
>>
>> Interesting. A Maint Plan in 2005 is an SSIS package, so I would expect a requirement for using
>> 2005
>> Maint Plans is to have SSIS installed. Perhaps they did some special handling of Maint Plans SSIS
>> packages...
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
>> news:BDC49606-300E-4BEA-8CE1-083026C6C00F@microsoft.com...
>> > no, I didn't.  I did some more searches and found some fixes for it.
>> >
>> > Actually what fixed it for me was SQL 2005 SP1.
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> Did you install Integration Services?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Gilbert" <Gilb***@discussions.microsoft.com> wrote in message
>> >> news:07FDD247-34D0-4F03-8BFB-E669E8E51829@microsoft.com...
>> >> >I am running Windows Small Business server 2003 R2 and I've upgraded the
>> >> > Sharepoint from MSDE to SQL 2005.  I'm trying to create a Database
>> >> > maintenance plan to backup the Sharepoint database but I'm getting an error
>> >> > message.  I've pasted the messaged below:Create maintenance plan failed.
>> >> >
>> >> > TITLE: Maintenance Plan Wizard Progress
>> >> > ------------------------------
>> >> >
>> >> > 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
>> >> >
>> >> > ------------------------------
>> >> > BUTTONS:
>> >> >
>> >> > OK
>> >> > ------------------------------
>> >> >
>> >> > ===================================
>> >> >
>> >> > 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
>> >> >
>> >> > ------------------------------
>> >> > Program Location:
>> >> >
>> >> >   at
>> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection
>> >> > localConnObj, String proxyName)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String
>> >> > subplanName, String proxyAccount, Package package, ServerConnection
>> >> > localConnObj)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String
>> >> > subplanName,
>> >> > String proxyAccount)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
>> >> >
>> >> > ===================================
>> >> >
>> >> > An exception occurred while executing a Transact-SQL statement or batch.
>> >> > (Microsoft.SqlServer.ConnectionInfo)
>> >> >
>> >> > ------------------------------
>> >> > Program Location:
>> >> >
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> >> > sqlCommand, ExecutionTypes executionType)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection
>> >> > sqlCommands, ExecutionTypes executionType)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection
>> >> > queries)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries,
>> >> > Boolean
>> >> > includeDbContext)
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection
>> >> > createQuery,
>> >> > ScriptingOptions so)
>> >> >   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
>> >> >
>> >> > ===================================
>> >> >
>> >> > The specified '@subsystem' is invalid (valid values are returned by
>> >> > sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)
>> >> >
>> >> > ------------------------------
>> >> > For help, click:
>> >> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>> >> >
>> >> > ------------------------------
>> >> > Server Name: SERVER1\SHAREPOINT
>> >> > Error Number: 14234
>> >> > Severity: 16
>> >> > State: 1
>> >> > Procedure: sp_verify_subsystem
>> >> > Line Number: 28
>> >> >
>> >> >
>> >> > ------------------------------
>> >> > Program Location:
>> >> >
>> >> >   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
>> >> > Boolean breakConnection)
>> >> >   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
>> >> > exception, Boolean breakConnection)
>> >> >   at
>> >> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
>> >> > stateObj)
>> >> >   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
>> >> > SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
>> >> > bulkCopyHandler, TdsParserStateObject stateObj)
>> >> >   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
>> >> > methodName, Boolean async)
>> >> >   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
>> >> > result, String methodName, Boolean sendToPipe)
>> >> >   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>> >> >   at
>> >> > Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
>> >> > sqlCommand, ExecutionTypes executionType)
>> >> >
>> >>
>> >>
>>
>>