Had to migrate to new hardware running Server 2003, sql 2005. 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?
This establishes an "alias" that makes the old name refer to the current SQL Server. Once this is in place, I would THINK that you could delete the plans and associated jobs. After you are done, I would delete this alias as quickly as possible.