We have some older maintenance plans that were built with SSMS 2014 on a Sql Server 2014 instance. The connection defined for the plan uses a Sql Server account with sysadmin perms. When you edit with SSMS 2014, all works just fine. On my local box, I have SSMS 2016, also have sysadmin perms. When I edit the plan, the "Notify Operator Task" has a blue indicator that something is wrong
When I try to edit the task, I get the following error:
The sql error log shows the following errors:
Error: 18456, Severity: 14, State: 8.
Login failed for user 'SqlAccount'. Reason: Password did not match that for the login provided. [CLIENT: xx.x.x.x]
The SqlAccount is the one defined in my "manage connections" from the maintenance plan. Is there some new permission that SSMS 2016 needs? Are plans created in SSMS 2014 not fully compatible with the SSMS 2016 editor?
Best Answer
In your maintenance plan's "Manage Connections" define a new connection with integrated Windows authentication. Use that connection with your Notify Operator Task (set it here right-clik->Properties->Connection) and it should work.