Sunday, February 26, 2012

Error message when trying to do a maintenance plan

Hi all,

As far as I can tell I have installed all features of SQL2005 but when I try to setup a maintenance plan I am receiving this 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


BUTTONS:

OK

Any ideas on why this is happening?

first of all you must apply sp2 of Mar

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19624

There are many problems related to MP solved in this version. Check whether you have installed Integration services and the services is running

Madhu

|||

First things first, have you applied any service pack after you have installed the SQL 2005 components on thsi machine?

If not try as suggested to take care of such issues with maintenance plans.

No comments:

Post a Comment