Cannot modify/delete 2005 maintenance plan after hardware migration

  • Had to migrate to new hardware running Server 2003, sql 2005, but keeping same server name. Databases, logins, two SSIS(DTS) packages working great. But, System and User maintenance plans failing since name change.

    So, recreated them, and (with minor problem to be addressed at another time) the recreations are working fine. But, I can't delete (or modify) the old plans or jobs. Get the following error when physically sitting in front of the server logging in "Exception has been thrown by the target of an invocation(mscorlib). An error has occurred while establishing a connection to the server. When connecting to sql server 2005, this failure may be cause by the fact that under the default settings, sql server does not allow remote connecitons. (provider: tcp provider, error: 0 no such host is know) error 11001

    As I said, I've disabled both jobs, but would prefer to delete the plan/jobs. But, it won't let me. Any ideas?

  • Found this and it worked like a charm - hope it helps someone else.

    1. Select the ID with the select statement

    select * from sysmaintplan_plans

    2. Replace with the selected ID and run the delete statements

    delete from sysmaintplan_log where plan_id = ''

    delete from sysmaintplan_subplans where plan_id = ''

    delete from sysmaintplan_plans where id = ''

    3. Delete the SQL Server Jobs with the Management Studio

  • It works, thank you!

  • Worked for me as well, thanks very much! This can't possibly be SOP for SQL 2005, can it?

  • Thank you very much this worked perfectly...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply