SQL Services - Log on as (who?)
-
Friday, February 24, 2012 3:26 PM
I'm not a SQL admin, so I would like to ask the specialists about accounts, that are best to start these services:
- SQL Server Integration Services 10.0
- SQL Server Browser
- SQL Server Analysis Services (TestDB)
- SQL Server (TestDB)
- SQL Server Agent (TestDB)
- SQL Full-text Filter Daemon Launcher (TestDB)
- SQL Server Reporting Services (TestDB)--------
I created the service account - svc_sql (domain user, in SQL sysadmin). Which user should I choose to start the these services? Local system? local service? network service? or svc_sql?
- Edited by Dawid Mitura Friday, February 24, 2012 3:26 PM
All Replies
-
Friday, February 24, 2012 9:18 PM
Hi,
Please see the following: http://msdn.microsoft.com/en-us/library/ms143504.aspx
Setting the service accounts depends upon your requirements, i.e. whether you need your sql server to access domain resources
Thanks,
Andrew Bainbridge
SQL Server DBA
Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you
- Edited by Andrew Bainbridge Friday, February 24, 2012 9:20 PM
- Proposed As Answer by Papy NormandModerator Sunday, February 26, 2012 9:57 AM
- Marked As Answer by Dawid Mitura Monday, February 27, 2012 9:16 AM
-
Sunday, February 26, 2012 10:05 AMModerator
Hello,
I propose you that, with your agreement , a moderator moves your thread towards
http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/threads
or
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads ( as it is a current setting done during the setup of a SQL Server instance )
Or you may have a look at this thread
We are waiting for your feedback to try to help you more efficiently
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
- Edited by Papy NormandModerator Sunday, February 26, 2012 10:08 AM Added the link towards a similar thread
- Proposed As Answer by amber zhangModerator Monday, February 27, 2012 5:22 AM
- Marked As Answer by Dawid Mitura Monday, February 27, 2012 9:17 AM
-
Monday, February 27, 2012 9:17 AMAgree and thx for the last link, it was helpful too.

