Apply to Target Server error when creating Maint. Plan on SQK 2k5

[Catadmin]

I tried creating a new job that contained a reorganize indexes, clears out the MP history, updates DB stats and the Notify Operator task (set with a fail precendence from the other three tasks) for a user db. I hit save, then the X up in the right hand corner and got the following error message:

"Apply to target server failed for job 'MyJobName' "

When I posted this error to the Microsoft forums, the response that I got was:

The second issue you are seeing is probably
because you are using SQL Server Management studio to connect to a server which is not local. If you terminal service to the machine itself and use sa account to connect to it from there then you shouldn't see this issue. This issue is somehow related to security but haven't found a solution yet.

Has anyone run into this problem yet? Has anyone resolved it?

I think it kind of strange that the only fix for creating a Maintenance Plan through SSMS is to remote into the server and do it from the server's desktop tools. The other option I saw in an article (regarding SSIS and DBMPs with the "GUID should contain 32 digits with 4 dashes" error) was to go into MSDB and make changes to the plan there which is not a true solution as far as I'm concerned.

Thanks in advance for any thoughts.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"