Click on any created Maintenance Plan:
TITLE: Microsoft SQL Server Management Studio
Value cannot be null.
Parameter name: component (System.Design)
BUTTONS:OK
Create a new Plan I get this error:
TITLE: Maintenance Plan Wizard Progress
Saving maintenance plan failed.
ADDITIONAL INFORMATION: The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Unspecified error). The SQL statement that was issued has failed.
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Unspecified error). The SQL statement that was issued has failed.
BUTTONS:OK
Edit an already created Backup Plan:
Error 1 Error loading 'BackupDb' : The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Unspecified error). The SQL statement that was issued has failed. . server=SERVER;package=Maintenance Plans\BackupLeadsDb; 1 1
Attemped Solutions: I've changed password for SA Account; I use Windows Authentication to log in; and I've registered C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTS.dll. Repair SQL Server 2012, Uninstall/ReInstall SQL Server 2012.
Best Answer
Using Microsoft SQL Server Management Studio 2012 on my local machine, I get the same issue trying to modify a backup plan on a SQL2008r2 server.
It works with Microsoft SQL Server Management Studio2008r2 on both my local PC and directly RDPing on to the server and running SSMS2008r2 from there.
Looks like a bug in Microsoft SQL Server Management Studio2012 to me.