Error when creating a maintenence plan in SQL 2005

I was making Maintenence plan for backing up CRM databases and I get the following error:

ERROR MESSAGE
—————————————————
TITLE: Microsoft SQL Server Management Studio
—————————————————

The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see “How to: Install SQL Server 2005 (Setup)” in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

Resolution:

Install SSIS on SQL server to make the maintenance plan work.

If still you are getting issues check out this excellent thread on MSDN to resolve your issue:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=234216

Once resolved you can easily backup CRM as discussed in my last blog entry.

Thanks

About this entry

You’re currently reading “Error when creating a maintenence plan in SQL 2005,” an entry on Piyush: Microsoft Tech Blog

Published:
August 7, 2007 / 2:42 am
Category:
SQL
Tags: