Re: Installation - What Account is needed?

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

Thank you.

This SQL server is part of my domain. I previously posted that I built
another SQL Server and installed under my Domain Admin account and all
services of SQL are running under Local System or Network Service. In the 2
years that this system has been up and running I have changed my password and
I don't see any indication of my account tied to SQL services.

Having said that, what if I create a SQLuser account as a Domain User and
have it as a Local Administrator on the SQL Server itself and install under
that account? If this works, after the installation can I safely remove this
account as a Local Administrator on the SQL box and let it remain solely as a
Domain User?

"Ekrem Önsoy" wrote:

Hello Rick,

I understand you are asking about the required account to install a SQL
Server Instance itself.

You must have administrator rights to be able to install a SQL Server
instance. So, there is no any problem with your Domain Admin account in case
the questioned SQL Server server is a member of your domain.

However, during the installation of your new SQL Server instance, ensure
that you assign a basic domain user account as your SQL Server service
account. You shouldn't use a Domain Account or Administrator Account as your
SQL Server service account.

SQL Server will add this ordinary domain account to some Local Groups which
are created by SQL Server Setup during the first SQL Server installation. So
that this account will have necessary rights to perform SQL Server tasks on
your environment.

Again, best practice says that you should use an ordinary domain account as
your SQL Server service account in a domain environment. However, you should
be using an administrator account to perform a SQL Server instance
installation.

--
Ekrem Önsoy




"Rick K" <RickK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7C2DB45-73A9-4042-9E3A-33D14BDB843F@xxxxxxxxxxxxxxxx
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: sa password was inadvertently changed. With a kicker...
    ... Use some other account that the client has (any domain admin should have ... Did around there install package, and see if the sql script that changed ... Put the database files back where they should ... > I have a SQL Server 7 Standard edition server running in a ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... Now I removed the account from local Administrators group. ... The SQL Server Log File reports an error 15209, ... Note that I use a specific account named SQLServerServices to install ... This is an informational message only. ...
    (microsoft.public.sqlserver.setup)
  • Re: Compromise?
    ... >made the patches available and advised customers to ... >install it. ... >>Server was installed and if your SQL Server is running ... >>administrator account, you just gave anybody who has a ...
    (microsoft.public.sqlserver.security)
  • Re: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2008 set up
    ... work on this Account so I would like to use that. ... "SQL Server System Administrators" list during SQL Server 2008 Setup. ... The install completed successfully. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)