Saturday, September 29, 2012

Updating SharePoint 2010 Managed Accounts & SQL Server Passwords

If you need to update the passwords for your managed accounts in SharePoint, you have a few different options. To check out your settings/options, navigate to:

Central Admin -> Security -> Configure Managed Accounts

  1. SharePoint can manage the password for you and change it automatically on based certain intervals
  2. Update the password directly within Central Admin
  3. Change the password of the account in Active Directory first, then update the account's password via Central Admin
Your organization's policies can determine which option you choose. In my experience, most organizations have a separate team of System Administrators who maintain all accounts within Active Directory and enforce password policies there.

Let's say a new password policy is coming out next week. You will need to get ahead of the curve and update all of your passwords prior to the changes taking place, otherwise you are afraid your farm will come to a sudden halt. Your system administrators will be updating the passwords but are nice enough to tell you what they are for each service account SharePoint uses. In order to update the passwords in SharePoint, navigate to:

Central Admin -> Security -> Configure Managed Accounts -> Change Password Now -> Use Existing Password -> Enter the password provided by your System Administrator -> Ensure that Enable Automatic Password Change is NOT checked-> Click Ok

The SQL administrator password needs to change to, but uh-oh, that's not one of SharePoint's managed accounts (nor should it be). Your System Administrators, have just changed the password in Active Directory and have notified you. To update the SQL passwords related to SharePoint you will need to update 2 services. Follow the steps below:
  1. Log on as administrator to the SQL Server
  2. Click Start and search for Server Manager
  3. Expand Configuration-> Services.
  4. Find the service called SQL Server (MSSQLSERVER) and right-click -> Properties
  5. Log On tab -> Type in new password -> Click OK
  6. Select Yes when a dialog box pops up informing you that services will need to be restarted in order for the changes to take effect
  7. Right click on the same service and select Stop
  8. Right click again and select Start
Follow the same steps above to update the password for the SQL Server Agent (MSSQLSERVER) service as well.

Check your SQL Server's Windows Application Event Logs. If you receive errors, be sure that the SP Timer Service has been restarted on the Web Front End server.

No comments:

Post a Comment