RE: SQL Server Service Account

Hello John,

You do not need to use a Domain admin, but you'd be best served by using a
domain user that is a member of the local administrators group on the SQL
Server. For more information about exactly what permissions are granted to
the service accounts in SQL Server, please refer to the article in Books
Online titled: "Setting up Windows Services Accounts"

Hope this helps!

Sincerely,

Dana Brash
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>Thread-Topic: SQL Server Service Account
>thread-index: AcVJSdv14gx7rms5Tn28T/gBXuG3VA==
>X-WBNR-Posting-Host: 24.218.199.128
>From: "=?Utf-8?B?SlQ=?=" <Jthayer@xxxxxxxxxxxxx>
>References: <1B3262A6-BC50-41A5-BC31-A6F25DB254C5@xxxxxxxxxxxxx>
>Subject: RE: SQL Server Service Account
>Date: Sun, 24 Apr 2005 20:50:02 -0700
>Lines: 16
>Message-ID: <D5C952BA-7CE1-4FA7-BFDD-5722B0B4DB14@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.setup
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.setup:6728
>X-Tomcat-NG: microsoft.public.sqlserver.setup
>
>PS. In the future, this SQL Server will be clustered.
>John
>
>"JT" wrote:
>
>> Hi,
>> I am preparing to install SQL Server 2000 ENT on a server in an all WIN
2003
>> domain. It will be accessed by BizTalk Server 2004, and an ADO.NET app,
both
>> of which are on their own remote servers. In development, I have always
used
>> a local admin account for SQL Server. Now, I want to use a domain
account,
>> but have questions. Do I have to make it a domain Admin account, or can
I
>> use a domain user account with elevated privileges? If user, EXACTLY
which
>> privileges does SQL Server need to have? Same question for SQL Agent.
>> Thanks.
>> --
>> John
>

.

Relevant Pages

  • RE: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: xp_cmdshell failed to execute because current security context
    ... INFO: databasename: xp_cmdshell failed to execute because ... SQL Server running under has appropriate privilege. ... Server service account does not have all the relevant permissions not the sql ... ontario, canada ...
    (microsoft.public.sqlserver.server)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I am guessing that the SQL Server Agent service account is not what ... rights to remove folders under P:\ReplData. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)