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

Posted on 2008-11-17
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
    LVL 7

    Accepted Solution

    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:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now