Maintenance Plan problem | Microsoft Connect

Maintenance Plan problem by jcl71

Closed

as Fixed

Type:	Bug
ID:	234216
Opened:	11/1/2006 6:00:36 AM
Access Restriction:	Public
Duplicates:	251013

Workaround(s)

view

User(s) can reproduce this bug

Found Forum post that explains my problem at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=815411&SiteID=1

Getting the error on the server after installing SP1. Have a full installation of SQL server 2005 x64

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

Details (expand)

English

SQL Server 2005 SP1 - Standard Edition

Tools

Windows Server 2003 (all x64 editions)

US English

After installation of SP1. Tried to start Maintenance Plan Wizard

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Unable to execute requested command.

------------------------------

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 . (Microsoft.SqlServer.Management.MaintenancePlanWizard)

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

------------------------------
BUTTONS:

OK
------------------------------

Start of Maintenance Plan Wizard

X64

0 attachments

Thank you for reporting your problems creating remote maintenance plans. Here are some steps to guide your investigations:

Maintenance plans rely on the SSIS runtime. If it is not present, the maintenance plan will not run. For the release version of SQL Server 2005, and for SP1, the SSIS runtime is included in the Tools install and in the SSIS install. This means that if your target server has only a relational engine install, a maintenance plan can not be expected to run.

You assert that this problem commenced with SP1, so I don't expect that this is the problem, but I have to rule it out. Is it possible that the target server lacks a tools install and an SSIS install?

Given that SSIS appears on the target machine, make sure that sp1 was actually applied to all the 2005 components, viz. the engine, the tools, and/or the SSIS install.

If you have a cluster, know that SSIS is not cluster aware, and should be installed and serviced on each node.

In SP2, the SSIS dependencies are included in the relational engine install. This should prevent this sort of thing from happening in the future. If you get a chance to try out CTP2 (expected today), I would be happy to learn whether it resolves these issues.

I have not been able to reproduce this in my lab yet. If you can give me some instructions as to how to reliably reproduce the bad behavior, I would be better positioned to tell you whether I have fixed this, or to get the problem fixed if not.

Thanks again,

jkh