Re: service accounts setting up 2008

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the info.


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:36748873-B728-44DD-8E4E-F3A378C5864A@xxxxxxxxxxxxxxxx
See this link to understand MS' s recommendations.
http://technet.microsoft.com/en-us/library/ms143504.aspx

For a development server, using one Windows account for every service is
OK. Create a normal Windows account to be used as your SQL Server service
account and specify this account' s information during SQL Server setup.

--
Ekrem Önsoy



"Paul Pedersen" <nospam@xxxxxxx> wrote in message
news:ejWZInnSJHA.3584@xxxxxxxxxxxxxxxxxxxxxxx
During setup, the installer asks me to specify an account name and
password for each service. It recommends a different account for each of
the following services:

SQL Server Agent
SQL Server Database Engine
SQL Server Analysis Services
Sql Server Reporting Services
SQL Server Integration Services 10.0

The choices given in the drop-down box are:

NT AUTHORITY/NETWORK SERVICE
NT AUTHORITY/LOCAL SERVICE
NT AUTHORITY/SYSTEM
NT AUTHORITY/NetworkService
<<Browse...>> [Where apparently I can choose to run under some user's
account]

For SQL Server Integration Services 10.0, "NT AUTHORITY/NetworkService"
is preselected; the others are blank.


What's all this about?

What's the difference to me whether it runs under one service or another?

Why does MS recommend running each service under a different account?

I can't run each one under a different account anyway, because there are
five services and only four accounts.

Which account should I pick for each service, and why?

FYI, I'm installing on a development machine, not production.






.

Relevant Pages

  • Windows Authentication with IIS on separate machines
    ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
    (microsoft.public.sqlserver.security)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)