Wednesday, 28 March, 2012 3:15 PM
I have set up Project Server 2010 on a dual system environment, one DB server and one application server. The complete installation is done by one single AD User - say User 1. As such, he becomes the SP farm administrator, and all SQL services are also running under his credentials. All remaining Project Server related configuration like reporting services, PPS, secure store and also Search Services etc. are also done thru same user. It is a vanilla deployment with no customization. Can anyone tell me how to (and where all) change/reset the password for User 1. Thanks!!
Wednesday, 28 March, 2012 5:01 PM
In 2010 you should be able to do this with the new SP 2010 managed accounts feature. Since you have performed all installation tasks with that account, it will already be listed as managed account in SharePoint.
Open SharePoint Central Admin, then navigate to Security > General Security > Configure managed accounts. Your account will be listed as probably the only account. Click the edit button and then click the checkbox next to "change password now" and set the new password in the two boxes below.
For the secure store service, you might want to check if the access still works. If not you probably only have the "Set Credentials" again for your Target Application as you have changed the password for the data access account.
Check this article for additional information. Hope this helps...
- Edited by shelldor23 Wednesday, 28 March, 2012 5:05 PM
Thursday, 29 March, 2012 5:59 AMThanks Shelldor. What happens to SQL Server. Or in other words, what happens if I change the password directly from Active Directory?
Friday, 30 March, 2012 6:45 PM
Review following article to understand the process and options.
- Marked As Answer by Christophe FiessingerMicrosoft Employee, Owner Sunday, 1 April, 2012 3:09 AM
Monday, 2 April, 2012 5:09 PM
SQL doesn't care about the password if you are using AD accounts and you probably are.
However, if you change the accounts in Active Directory then the services will fail the next time they are restarted, like a reboot. The services will not have the username/password for starting up. It's best to manage in SharePoint Central admin because everything is stored, sync and managed here.
Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA, MCC 2011, MCC2012
Blog http://MyProjectExpert.com contains my field notes and SQL queries
Tuesday, 3 April, 2012 8:25 AM
I have same environment and have changed my admin password once and working well -
- Change the account password
- Change directory wherever STSADM has been installed, typically:
- cd "C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN" Run cmds -->
- For Central admin --> stsadm -o updatefarmcredentials -userlogin DOMAIN\user -password NEWPASSWORD
- For App pool --> stsadm -o updateaccountpassword -userlogin DOMAIN\USER -password NEWPASSWORD –noadmin
- For Search Service à stsadm.exe -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
For performance point à open service application and update unattended account with new password
- For reporting à open reporting configuration and update new password.
- No need to update Secure store separately, it worked for me.
- Reboot servers.