February 7, 2008 at 2:33 pm
I have a Maintenance Plan that is no longer needed. Whenever I try to delete it I get the following error message. Anyone have any ideas? Thanks.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
February 7, 2008 at 5:14 pm
Check if remote connections are enabled. Also check if you have necessary rights to delete the plan.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 8, 2008 at 5:04 am
Remote connections are allowed for TCP/IP and named pipes and I belong to the local administrators group.
February 8, 2008 at 3:13 pm
Do you have the latest service pack installed? The RTM version of SQL 2005 had all sorts of pesky little issues like this with Maint. Plans.
The Redneck DBA
February 15, 2008 at 10:17 pm
Go to msdb database
Look for the Maintenance plan you want to delete
select * from dbo.sysdtspackages90
Then delete it from there.
I got rid of mine this way.
Good Luck
February 18, 2008 at 7:29 am
paramejunk (2/15/2008)
Go to msdb databaseLook for the Maintenance plan you want to delete
select * from dbo.sysdtspackages90
Then delete it from there.
I got rid of mine this way.
Good Luck
That did it! Thanks.
March 18, 2009 at 7:03 am
Had the same problem.
Found that the plan was using local server connection with a server of '.'
Couldn't delete the plan using management studio remotely, but when I logged onto the server itself I could get rid of it from there.
Hope that helps !
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply