I have a Job that runs 3 times per day. It's been running perfectly for 8 weeks. Today the 6:00 AM Report ran fine this morning. The 12:00 Noon Report failed with this Message: "Unable to connect to SQL Server '(local)'. The step failed."
As far as I can tell nothing on the Server has changed. I tried the above step 4 times and it failed all 4 times. Anybody have an idea?
Maybe an account password has expired.... That kind of thing doesn't require a human to actively change something.