Local system and SQL Server Service

Hi:

A very stupid question but want to see if i have an answer.

Is it possible to run SQL Server Service and SQL Server Agent Service under local system(not Domain account) without granting SA Permissions on the server. is it ever possible to run by just granting some registry permissions and not making BUILTIN\Administrators a SA on the server.

Thx

AK

You can remove Builtin\Administrators from the server and the server will still run, but some applications relying on the presence of that login could be broken by this action.

Thanks
Laurentiu

|||

Also, we recommend against using local system as the service. Whenever it is possible, the recommendation is to use a domain account or a local account; if these types of accounts do not meet your needs, I would suggest using Network Service instead.

For more information visit BOL:

http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Use_startup_accounts

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine