I receive the following error trying to create a maintenance plan in SQL 2008 SP1 on a Windows 2008/R2 server:
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 Microsoft SQL Server Management Tools on the remote computer,
and then try again.
The components that installed are Database Engine Services, Reporting Services, Client Tools Connectivity, Management Tools Basic/Complete, and SQL Client Connectivity SDK. I have another independent SQL 2008 SP1 server running on the same platform
with the same features installed and I have no problem creating maintenance plans there. However, it does have IIS as it was upgraded from a SQL 2005 server which required IIS for reporting services while SQL 2008 does not.
I'm familiar with
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/06c80a78-a877-4a48-a032-b0aef78a598c but that doesn't seem to apply as this was a new SQL 2008 installation on a freshly installed OS. I've seen several other postings of this on the
web but they all appear specific to SQL 2005.
What else could be missing?
View Complete Post