RE: Installation - What Account is needed?

It is generally preferred to run SQL Server under its own service account. In
particular, you shouldn't run SQL Server under any domain admin account as
that would potentially give SQL Server users ability to become a domain admin.

Linchi

"Rick K" wrote:

Hi,
I am a Domain Admin and wanted to know if there is any reason I shouldn't
install SQL 2005 Enterprise under my credentials. Do I need to create a
Service Account to run any services?
Thanks.
.

Relevant Pages

  • Re: SQL account rights
    ... SQL Server account to be a domain admin. ... configure all SQL server functions. ...
    (microsoft.public.sqlserver.security)
  • Re: 2005 Enterprise sp 2 install fails - 11009
    ... What priveleges does the login need if I can't get a full domain admin? ... Once you finished installing SQL Server 2005 SP2, ... clustered instance before you apply SQL Server 2005 service pack. ...
    (microsoft.public.sqlserver.setup)
  • Re: Error from the DTS on scheduled task
    ... you need to check what permissions the SQL Server ... Agent service account has, as jobs will be executed ... You can test the credentials by logging onto the server desktop itself, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 2008 bulk load error
    ... The point is to understand whether it is the SQL Server service which is accessing the file or something else ... Say that it *is* SQL Server that is accessing the file, then if the user in question has sysadmin SQL Server priviliges, then the service account is attempted. ... One thing that *might* be helpful is using Proxies and Credentials. ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Server Service Account
    ... domain user that is a member of the local administrators group on the SQL ... the service accounts in SQL Server, please refer to the article in Books ... >Thread-Topic: SQL Server Service Account ... Do I have to make it a domain Admin account, ...
    (microsoft.public.sqlserver.setup)