Background:
We are a smallish company that prefers to keep things simple and not have to manage our Active Directory very much. My company uses a single administrator account to setup and do all the admin stuff that needs to be done. Recently we changed the password on that account and our MSSQL 2008 R2 server stopped working. We found out the issue was that the service related to the MSSQL server was setup to be started and run by the administrator account that was using the old cached password. We changed the password and it started working again.
Related fix for our issue: http://forums.devshed.com/showpost.php?p=301169&postcount=2
My Question:
Should the account used to start the MSSQL service be a domain user account setup in a particular fashion or is ok to select a local account like Network Service
or Local System
.