Geeks With Blogs

News





The SharePoint Hillbilly Fewer Big Words... More Pretty Pictures...

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)

image

3) Right click on the SQL Server Service and select “Properties”, then click on the “Log On” tab

image

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. 

Posted on Wednesday, May 13, 2009 8:18 PM | Back to top


Comments on this post: Fun With Changing Service Account Passwords

# re: Fun With Changing Service Account Passwords
Requesting Gravatar...
The POSM (Plain Ole Service Manager) is not what you use. Do use the SQL Server Configuration Manger either directly from the SQL Server start group or though your services folder of Manage Computer (the SSCM will be at the bottom). Account changes made though this method perform additional functionality like checking service logon permission, etc... that the POSM service control interface does not.
Left by MyerTheFlyer on Sep 03, 2009 12:32 PM

Your comment:
 (will show your gravatar)


Copyright © Mark Rackley | Powered by: GeeksWithBlogs.net