Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vishal_0009
Starting Member
2 Posts |
 Posted - 2013-01-31 : 11:11:41
|
| Hi guys,Require your help with changing Sql Server Service Account.We're running SQL Server 2005 Enterprise Edition. The database being used by bespoke application (that is installed) on client's pcs. Currently, the following services - are all configured to run with Domain Admin account. I've been asked to change the setting to run these services with Service Account. (1) SQL Server(2) SQL Server Agent(3) SQL Server Browser(4) SQL Server FullText SearchBefore I go ahead and make the changes, what Service Account do I need to use for this? i.e Local Service Account or Network Service Account. What implication that I need to cater for?While doing the initial research - found out that I need to use SQL Server Configuration Manager to make the changes. Await to hear from you.Regards,Vishal. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-31 : 13:36:52
|
| A Service can be a Local System account or a Domain Account - it depends on how your organisation wants to manage the Service account.What OS are you running?For example , the default account for Windows 2008 is Network ServiceYes, use Configuration ManagerJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
Vishal_0009
Starting Member
2 Posts |
Posted - 2013-02-01 : 05:31:41
|
Hi Jack,Thanks for your reply. The client O/S are WinXP and the Server O/S where the SQL Server 2005 installed is - Win Server 2003 R2. My only concern changing these service account is - will it fall anything apart? At the same time, don't want to assign more previleges than the required to run these services.Await your resposne.Regards,Vishal.quote:
Originally posted by jackv
A Service can be a Local System account or a Domain Account - it depends on how your organisation wants to manage the Service account.What OS are you running?For example , the default account for Windows 2008 is Network ServiceYes, use Configuration ManagerJack Vamvas--------------------http://www.sqlserver-dba.com
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-01 : 13:00:12
|
| Apart from starting up SQL Server , are you relying on the service account to interact with the OS.? For example, if you are using xp_cmdshell , that is using the Service account to interact with the OSJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
|
|
Sql Server Service Account