Maintenance Plan on the second instance

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Maintenance Plan on the second instance

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2009-05-01 : 04:43:35

I have a wired problem that I can't figure out. I have 2 named instances
installed on the same box. I can connect to both of them via Studio. Both
were installed in the same manner. One instance behaves as expected but if I
try to create a Maintenance Plan on the second instance I get the following
error:

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)

I do not understand this as both instances are local. I uninstalled the
second instance and reinstalled it but I get the same result.

Any help would be very much appreciated.

Kind Regards

Pete.

petek
Posting Yak Master

192 Posts

Posted - 2009-05-21 : 06:03:32

problem with user account (domain)

Kind Regards

Pete.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources