SQL Service Accounts

From: Dan Andryszak (danandryszak@yahoo.com)
Date: 10/29/02 

From: "Dan Andryszak" <danandryszak@yahoo.com>
Date: Mon, 28 Oct 2002 17:07:34 -0800

I started a new job and am responsible for the "care and
feeding" of SQL Server 2000. I have performed rudimentary
DBA tasks at prior jobs, so I'm not a complete novice.

Currently, all of the SQL Server service accounts
(SQLServer and SQLAgent) are using the local system
account and the servers are set for mixed security.
Typically, I have always used a domain account that has
local administrator priviligies in the SQL Server.

I want to use the Maintenance Wizard to setup DBCC and
Backup jobs, but I want to make sure that I don't "break"
anything.

I modified one SQL Server to use a domain account for the
services and the Maintenance Plan executed fine, but I
noticed (in the event viewer) that another user's
scheduled jobs failed. What database role does the domain
account need to operate properly?

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)
  • Re: Connections errors
    ... Jasper Smith (SQL Server MVP) ... accounts and not the NT domain account. ... >> been observing connection errors that we can trace back ...
    (microsoft.public.sqlserver.security)
  • Re: Account Recommendations
    ... I use a Windows domain account for both SQL Server and SQL Server Agent. ... I had to changed the job agent service to run ...
    (microsoft.public.sqlserver.setup)