We had something break yesterday. I'm trying to figure out what happened, in the interest of "Lessons Learned". Here are the facts and background.
1. We use Active Directory.
2. I needed to change the password for the SQL Server account and the SQL Server Agent account. We have three SQL Servers. Base on a response to a post I made in this forum, we decided to use one domain account for the SS accounts and the SS Agent accounts. There was already an account being used for one of the SS Agents. Since no one remembered the password, we decided to change it.
3. We have a weekly maintenance window once a week. I asked the guy who handles the domain accounts to change the password on the account for me. I was going to stop and restart the services during the maintenance window.
4. I was unable to be here during the maintenance window, so I never stopped and restarted the services. I didn't think it mattered, because it is my understanding that the password change does not take effect until the services are stopped and restarted.
5. I was out yesterday. SS Agent jobs that access the servers broke (I don't much, yet, about how those apps are architected). The guys here stopped and restarted the services, and it solved the problem.
So the initial diagnosis in most folks' minds is that changing the password broke the jobs. But I thought that password changes don't take effect until the services were stopped and restarted.
Can someone offer their opinion here?