Re: Services account

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 02/12/04 

Date: Thu, 12 Feb 2004 16:01:40 +0100

Correct, just check besides files and folders registry keys permissions. 

-- 
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:eu5nt4W8DHA.1672@TK2MSFTNGP12.phx.gbl...
> 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: best way to scrub data
    ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ... > sensitive data like user info,credit card info,etc.. ...
    (microsoft.public.sqlserver.security)
  • Re: clearing concept
    ... and Extents" chapter. ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.clients)
  • Re: Change sql agent login user
    ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ... "shivi" wrote in message ...
    (microsoft.public.sqlserver.security)
  • 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: predetermine size of differential
    ... You can try with the undocumented DBCC PAGE command - see ... Dejan Sarka, SQL Server MVP ... Solid Quality Learning ...
    (microsoft.public.sqlserver.server)