Have I mentioned lately that I’m not the sharpest tool in the shed? It seems I was brilliant when setting up my SharePoint VM and I used my user account when setting up my VM’s service accounts. Smart move? right? At least I won’t forget what username and password I used.
Well…. pretty stupid actually. My password changed on my user account which broke SharePoint on my VM. I couldn’t access any of the sites or Central Administration. Actually, I knew this was going to happen, I was just procrastinating worrying about it, but HEY it gives me an excuse to learn something new!
So, the question becomes, how do you change the passwords for your Service Accounts so things start working again?
Woah.. slow down there slugger. First thing you need to do is change the password associated with your SQL Server Service, otherwise you will get the ever so helpful and annoying error message “Error updating the administration application pool credentials.” when you try to update the passwords. I LOVE SharePoint error messages. Actually, you don’t have to worry about this if that service account password did not change, but I was smart and used the same user account for all of them.
Change Password on SQL Server Service
So, how do you change that SQL Server Service password? Glad you asked! Follow these simple steps:
1) Go to the Services on your computer “Start”->”Administrative Tools”->”Services”
2) Locate your SQL Server Service (It will be stopped)
3) Right click on the SQL Server Service and select “Properties”, then click on the “Log On” tab
4) Change the Password click on “Apply” then start the Service.
There you go, your SQL Server Service is now started, and we are ready to change the Service Account Passwords.
Changing Service Account Passwords
You probably already know you can change your Service Account Passwords using the STSADM utility. You may have even read http://support.microsoft.com/kb/934838 and then came here because you got the aforementioned error? Well, good news, If you have been reading my blog at all you know that I’m EXTREMELY lazy. So, rather than telling you to manually enter the STSADM commands or write your own script I found a GREAT script online for changing all the Service Account Passwords at once:
SharePoint Automation: Change Password Script
Just copy and paste the script, change the Doman, usernames, and passwords to be what they should be and run the script! Super easy, very awesome. I was so happy I had to write a blog about.
So, there you go. Again, nothing too earth shattering, but hopefully helpful nonetheless.