Problem:
No matter what type of SQL Server Maintenance Plan you create and no
matter what credentials you use, the plan always fails with "Execution
Failed." There is almost no information to go on either. Event logs, SQL
Agent logs....nothing is reporting a problem.
Are you using SQL aliases?
Solution:
Make sure you've set the alias for both the 32bit and 64bit drivers. We
ran into this exact problem and as soon as we added the alias to the
second section, all the maintenance plans ran fine.
SQL Server Maintenance Plan Execution Failed
Subscribe to:
Post Comments (Atom)
I struggled my head with this problem and couldn't get it solved. I started looking for a freelancer and found a team of friendly people called called ServerBuddies.
ReplyDeleteThey provide quality remote server management, including troubleshooting, Server Management, Plesk Support, Server Maintenance, Server Monitoring, Server Troubleshooting and support at a affordable rates. They also provide Server Optimization, Plesk Support, Linux Support, cPanel Support and Plesk Support.
They are great, I highly recommend to use these guys!