Re: Services account

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Taras Tim Bredel (ttb_at_jtj.dk)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 14:43:17 +0100

So if I understand it correctly....

Since my sql server won't be part of a domain, and therefore won't require
any network services, it is ok to install it under "Local Service Account",
as long as "System" has access to all the nessecary files and directories
Furthermore it would perhibit replication.

Correct ???

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:%23tsyhrW8DHA.1936@TK2MSFTNGP12.phx.gbl...
> Here is an useful article:
>
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1061.asp.
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
> "Taras Tim Bredel" <ttb@jtj.dk> wrote in message
> news:OfiIK#V8DHA.2404@TK2MSFTNGP12.phx.gbl...
> > Usually I install sql server under "Local System Account", but several
> > places I've read that it is recommended to create a local user account
for
> > all the sql services to run under.
> >
> > Does anyone care to elaborate on this?
> >
> > Thanx!
> >
> >
> >
>
>

Relevant Pages

  • Re: Helppp!! Web Part error after upgrading to SQL Server 2005
    ... permission on the new SQL Server. ... not a network or local service account. ... build of the Sharepoint server! ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Helppp!! Web Part error after upgrading to SQL Server 2005
    ... permission on the new SQL Server. ... And maybe verify that SQL Server is still using a domain account and ... not a network or local service account. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Multiple Quesions and some feedback on Modelling
    ... need to add ENV is sql server 2005 enterprise edition. ... Have a model structure that entails three mining models including tree. ... >> was they are trained already for sql management studio because otherwise ... > Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: Multi Dimensional Cases in Time Series
    ... This message does not imply endorsement from Solid Quality Learning, ... >> - in SQL Server, create a linked server to the Analysis Services ... >> Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: SQL7 standalone
    ... Can you connect with Query Analyzer using a SQL login (SQL authentication)? ... Dejan Sarka, SQL Server MVP ... "giovanni" wrote in message ... I thought you mean SQL Server installed on the ME. ...
    (microsoft.public.sqlserver.server)