command line install sql express 2008 r2 with tools

Posted on 2011-10-10
Last Modified: 2012-05-12
I'm trying to install SQL Express 2008 R2 doing a command line install.  I'm currently using following parameters:


When I run the install the it will hang up and give me an error.  I'm trying to install SQL Server Express along with Management Studio using quite mode.
Question by:PeterTrefren
    LVL 15

    Expert Comment

    LVL 15

    Expert Comment

    this is another link about unattended installation

    Accepted Solution

    After a fair amount of trail and error I ended up using the following parameters:


    I didn't seem to have a lot of success installing Tools by itself but at this point I'm happy with the fact it works.  
    LVL 15

    Expert Comment

    its good to hear that.

    i guess now you can keep it in a batch file or you also have the option if a configuration file for sql setup

    All the best

    Author Closing Comment

    This solution will give a generic install of SQlL Server.  However just realize it does not allow remote connections.  If you are looking to have other computers access this instance of SQL server you wiill have to use the additional parameters.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 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

    20 Experts available now in Live!

    Get 1:1 Help Now