SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sql Server Service Account
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Vishal_0009
Starting Member

2 Posts

Posted - 01/31/2013 :  11:11:41  Show Profile  Reply with Quote
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
2063 Posts

Posted - 01/31/2013 :  13:36:52  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

Vishal_0009
Starting Member

2 Posts

Posted - 02/01/2013 :  05:31:41  Show Profile  Reply with Quote
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

Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2063 Posts

Posted - 02/01/2013 :  13:00:12  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000