When installing SQL Server 2005 using the answer files provided on the Team Foundation Server 2008 media one of the steps is to modify the answer file to specify which accounts you want to run the various SQL Server 2005 components as. In a number of scenarios you may want to use the built-in Network Service account instead of a “real” service account.
To do this you need to replace the following section:
;Security Context of service accounts
SQLBROWSERACCOUNT=”MyDomain\MyServiceAccount”
SQLBROWSERPASSWORD=”MyPassword”
SQLACCOUNT=”MyDomain\MyServiceAccount”
SQLPASSWORD=”MyPassword”
AGTACCOUNT=”MyDomain\MyServiceAccount”
AGTPASSWORD=”MyPassword”
ASACCOUNT=”MyDomain\MyServiceAccount”
ASPASSWORD=”MyPassword”
RSACCOUNT=”MyDomain\MyServiceAccount”
RSPASSWORD=”MyPassword”
With:
;Security Context of service accounts
SQLBROWSERACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
SQLACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
AGTACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
ASACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
RSACCOUNT=”NT AUTHORITY\NETWORK SERVICE”