XP SP3
SQL Server 2008 Standard Edition

This box is purely for local software development purposes, so I don't
really see the need for dedicated accounts.

What is a recommended accounts config for the various services ?


Here is what I used :

Active Directory Helper
NT AUTHORITY\NETWORK SERVICE

Full-text Filter Daemon Launcher
NT AUTHORITY\LOCAL SERVICE

Database Engine
LOCAL SYSTEM

Agent
LOCAL SYSTEM

Browser
NT AUTHORITY\LOCAL SERVICE

Integration Services 10.0
LOCAL SYSTEM

VSS Writer
LOCAL SYSTEM


Any problems with the above ?

Thanks.

John Grandy (johnagrandy-at-gmail-dot-com) writes:
That is probably OK. That is what I have on my machine, and I think it
was the defaults.


But this is not good at all. Use a domain account. This is not only a
security issue, but also a practical one. If you use Local System,
SQL Server cannot access resources outside the machine, for instance
put a backup on a file share.

I have my browser server running under a domain account as well, but I
don't know important this is.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx