Maintenance Plans Fail on SQL Server 2012 after applying SP2 patch
All maintenance plans on 5 failover cluster instances fail with Failed to acquire connection "Local server connection" after I applied sp2 patch. There is a 2008R2 failover instance on the same cluster that has no problem. There were a lot of security patches (windows 2008 R2) that were applied after sp2. nothing noteworthy other than .NET Framework 4.6. Any help is greatly appreciated!
If you have two instances on the server, to make the connections work correctly all the time, use the named server in your Maintenance Plans, not "Local server". Probably, the default server is the other one. Just use the instance name.