Remote Maintenance Plans in SQL Server 2008

Question

I've set up a maintenance plan in instance #1 of SQL Server 2008. In theory, it will connect to instance #2 and back up those databases to the hard drive of instance #1.

I have:

• Created a login on instance #2
• Given that login the correct permissions needed to back-up a database (I tested it)
• Created a working connection in the maintenance plan to instance #2 (I tested it)

However, the plan will not execute and the only error that I get is "The maintenance plan failed." Is there something that I'm missing?

Any help is greatly appreciated. Thanks in advance!

UPDATE: I created a maintenance plan on instance #2 that would back up instance #2's databases and then ship them over to the machine that instance #1 is installed on. This did not work either!

Answer 1

if it's sql server agent executing the maintenance plan check its permission instance #2 or use a proxy account for SSIS exectuion.