| Author |
 Topic  |
|
|
Vishal_0009
Starting Member
2 Posts |
 Posted - 01/31/2013 : 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 Search
Before 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
Flowing Fount of Yak Knowledge
United Kingdom
1773 Posts |
Posted - 01/31/2013 : 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 Service
Yes, use Configuration Manager
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
 |
|
|
Vishal_0009
Starting Member
2 Posts |
Posted - 02/01/2013 : 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 Service
Yes, use Configuration Manager
Jack Vamvas
--------------------
http://www.sqlserver-dba.com
|
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1773 Posts |
Posted - 02/01/2013 : 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 OS
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
| |
Topic |
|
Sql Server Service Account
