SQL Server 2012 Maintenance Plan can't modify
- by Crazyd
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.