SQL Server workaround for creating a maintenance plan failure (SQL server:14234 error) _mssql2005

Start a server, is exactly the cloud host, the environment inside is pre-configured, but in the configuration planning tasks, but found that mssql2005 plan backup can not do, will error:

Copy Code code as follows:

SQL Server Create Maintenance plan failed (SQL server:14234 error) automatic backup database plan

error message:

Copy Code code as follows:

Creation failed for JobStep ' Testbak '. (Microsoft.SqlServer.MaintenancePlanTasks)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The specified ' @subsystem ' is invalid (valid value is returned by Sp_enum_sqlagent_subsystems). (Microsoft SQL Server, 14234 error)

I wanted to compress the file directly, so that I could attach a restore. But every time you compress, you need to deactivate the database, so you are pass.

Do you want to use other software? With Navicat for MS SQL, the result is not very ideal, backup is SQL, not very friendly to transfer.

or fix it, think about it or the function of its own with the best use.

Workaround:
1. Run the SQLSERVER2005 Installation Wizard.
2. On the System Configuration Check page after completing the scan, click Next.
3. In the Name box and company box, enter the appropriate information, and then click Next.
4. Click to select the Integrationservices check box, and then click Next. (This is the key, the rest can be ignored.)
5. Click Next, and then click Install.
6. After the installation is complete, click Next, and then click Finish.
Although the download took a little time, but finally finished, the planning task is done, or to tell the cloud host business? Let me think about it for a moment ....