SQL Server Performance Forum – Threads Archive
SQL Service and agent accounts on Win2K3I have SQL 2000 running on Windows 2003 but am having trouble setting permissions for the service accounts. I have chosen to use the same account for both the SQL and Agent services but don’t want to have the account as a local admin – this is a backend server for an Extranet application. The SQL service is perfectly happy running as a regular domain user with the required permissions to the log and data locations on the server. The SQL agent however won’t run unless I grant local admin rights. Is it possible to set exact permissions for the agent or is a separate account with local admin rights the only solution? Many thanks
If the SQLagent jobs involves in local file handling then its adivsable to give required privileges, and there is no issue in using 2 different accouns for MSSQLServer and MSSQLAgent services. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.