I want to learn if SQL Mail can be used if SQL Server service account is set
to Local System Account.
For SQL Server 2000 Enterprise Edition on Windows 2000 Advanced
Server, should we use the local system account to run the SQL Server
Service, or a Windows domain account? I understand some of the
benefits of using a domain account for the agent e.g. SQL Mail,
although this is not supported for SQL Server clusters, but am
clueless when it comes to the server service.
Also, are there some security issues with using the local system
account? Can a stored procedure writer use xp_cmd to do something
nasty, like format C:\ ? If so, what kind of privs do you need to
give to your domain account?
Thanks in advance for sharing your knowledge!