SQL Service - Agent Service - Running in different accounts
-
For an SQL server, we have SQL server service running in Local Sytem account. SQL Agent service is running under a domain account (Domain\Username). Since some jobs werent running in local system account, we changed Agent service to Domain account.
Is this ok? Can we have 2 services (sql & Agent) running under different accounts?
-
There is no problem running the sql and the agent under two diffrent accounts.Local System is a very high-privileged built-in account i am not sure why you are facing issues with it.
-
I will advice you to use domain accounts (No domain administrators). In this link http://download.microsoft.com/download/8/5/e/.../SQL2005SecBestPract.doc you will find more information.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply