We had a case where in the domain account which is running SQL server got locked.
Database connectivity through management studio and applciations worked fine.
Report services showed the reports how ever the connectivity failed saying account locked.
Did any one faced these kind of issue before.
I need to identify this issue and alert, if it possible.
second i need to find how many jobs not started on that particular day, if there is an issue as an alert.
Are the above possible if i need to check some thing more please share your suggestions.
our server team havent identified the root cause yet. any suggestion where i can start with.