Re: Installation - What Account is needed?
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Sat, 16 Aug 2008 23:14:38 +0300
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.
Haven't you restarted your SQL Server services since 2 years? Because, when you change your SQL Server' s service account's password from your Active Directory, it won't be updated automatically at the SQL Server server and when your SQL Server service restarts, it'd compain about the wrong password.
Also, it does not mean your SQL Server services have to be running under the account which you installed the mentioned SQL Server instance. You can change your SQL Server service accounts through the SQL Server Configuration Manager. And if your SQL Server services are running under an administrator account, you should change it to a Domain User account which must be created for and used only by your SQL Server services.
In a domain environment, you may experience some problems if you don't use a domain account as your SQL Server service. At this point, I suggest you to read this page from BOL: http://technet.microsoft.com/en-us/library/ms143504.aspx
--
Ekrem Önsoy
"Rick K" <RickK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BB6F49A9-8030-48EC-A40B-97DD46427B33@xxxxxxxxxxxxxxxx
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.
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.
.
- References:
- Installation - What Account is needed?
- From: Rick K
- Re: Installation - What Account is needed?
- From: Ekrem Önsoy
- Re: Installation - What Account is needed?
- From: Rick K
- Installation - What Account is needed?
- Prev by Date: 2008 setup failure Cannot execute a program which is csc.exe
- Next by Date: Cannot install MSSQL2008 to Server2008 .net Framework failed to install
- Previous by thread: Re: Installation - What Account is needed?
- Next by thread: RE: Installation - What Account is needed?
- Index(es):
Relevant Pages
|
