Using Microsoft DPM 2012 SP1 with the locally installed SQL 2008 R2 SP2 instance (i.e. the one that DPM installs) once installed, you can’t get into the Maintenance tasks using SQL Management Studio. Clicking on Maintenance Tasks gives you an error:
The task with the name “Task Name XXX” and the creation name “Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintenanceFileXXXTask, Microsoft.SqlServer.MaintenancePlanTasks, Version=XXX, Culture=neutral, PublicKeyToken=XXX” is not registered for use on this computer.
The message may also say you need to install the Management Tools, but when you check they are already installed, repairing the SQL install makes no difference.
Not the best solution adding more permissions than I’d like to a service account, but it at least got it working, check the account you are using for the SQL server service account. In my case to fix it all I had to do was to add the SQL server service account that DPM had used for SQL to the local Administrators group on the server. Then restart SQL server. After this you can access the maintenance tasks without an error.