Installing SQL server 2005 Domain account or the Built in system account??

Posted on 2008-11-17
Medium Priority
Last Modified: 2012-05-05
I am installing SQL server 2005 standard edition. About 3 installation dialog boxes into the install I get prompted with a dialog box to make several choices. The choices are confusing and I don't know which one to pick. First of all there is a check box labeled "Customize for each service account".
Then there is a drop down listbox with options of "SQL Server","SQL Server Agent", and "Analysis Services".
Also with radio buttons I am prompted to chose the following choices:
(Radio Button) Use the built in system account (Choose Network service or Local System)
Or I can use a domain user account and I am prompted to enter the Username Password and Domain.(What do they mean by domain)

Ok, so why am I getting prompted for all of this information? Is it because I chose to install Analysis services? If so, maybe I shouldn't install it?

Question by:brgdotnet
1 Comment

Accepted Solution

thiyaguk earned 750 total points
ID: 22983393
The installation asked these parameters for account on which these service will be executed.
If you are not sure about what can be given, Just Use Buiilt in System account.
but. What my opinion is to run sqlservices using a separate domain account (3rd option).
Please Refer:

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question