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.

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 Manager

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 Manager

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