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
Friday, February 24, 2012 9:18 PM
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
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
Sunday, February 26, 2012 10:05 AMModerator
I propose you that, with your agreement , a moderator moves your thread towards
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.
Monday, February 27, 2012 9:17 AMAgree and thx for the last link, it was helpful too.