September 28, 2005 at 4:23 am
Hi All,
What is the key differences between running the SQL Server Services under a Local Service Account or Domain Account? Also, which is more secure and why?
Thanks, Siz
September 28, 2005 at 4:41 am
It's depend on your application. If your application integrated with other system, like ERP application, CRM, mail, etc, i suggested to use Domain account for starting up the SQL services. Because you can integrated the SQL with that application, if you using the local system account if will take a lot of time if you must integrated SQL with other application, for example : you can integrated SQL Mail, if you using DOmain Account, because the SQL take a profile from that user.
Domain account it's more secure, because if you installed the active directory, or you implemented the policy management, you can define the length of password, the combination etc,etc.
So, my suggetion is, use the domain account....
September 28, 2005 at 4:50 am
Excellent,
Thanks for the info Deni. I think those may be the main points. Any other opinions or reasons not mentioned by Deni are welcome.
Siz
September 28, 2005 at 6:03 am
The SQL Query Analyser debugger requires that a domain account be used if the debugger is to work.
The only thing to watch out for is that if SQL Server cannot see the domain for whatever reason then the services can't start.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply