Changing SQL Server service account
So I finally got the outage to do this yesterday evening and to summarize:


I opened an admin prompt, changed to the 'C:\Program Files\Microsoft
Team Foundation Server 2010\Tools' directory on the application tier
and quiesced TFS (TfsServiceControl.exe quiesce)
Changed all of the databases from LocalSystem to my service (domain)
accounts from inside sql server configuration manager.
Rebooted (I had windows update nagging me for a reboot)
Ensured all of the sql services started
Unquiesced TFS (TfsServiceControl.exe unquiesce)


The only problem I had is somehow inheritance on the Users folder where profiles are stored had some issue that prevented my service account from working. Once I fixed that everything worked just fine. I'm not sure if the profile issue was related to the account change.