What service accounts to use when installing SQL Server 2008 on a Dev Box
sql-server
Solution
You cannot use `NT AUTHORITY\LOCAL SERVICE`. Also you cannot use a local account.
The recommended way is to use a domain account. Next best thing is `NT AUTHORITY\NETWORK SERVICE`.
Problem
I am installing SQL Server 2008 on my development machine and during the install I am asked to assign accounts to the different services. What account should I use for the services where no user has been assigned if this is a simple development machine? - Can I use the account I am logged in with (I am the only user on this machine)? - Should I use the NT AUTHORITY/SYSTEM account? - Can I user either or of the above or is there a downside to one or the other or should I use something totally different?