by      
How to setup MS SQL 2008 Express using the command line. Make setup easy, and if you have more than one SQL server to setup the command line scripts can be added to a bat or vbs file to launch. Follow the simple guides and ask questions if you have them. Installation topics, GUI, Web PI and Command line installation. The resource link near the bottom offers more options. Command line triggers are also listed.

Installing SQL Express / MS SQL Setup Process

Update: 8-22-2013

SQL 2008 R2 Express SP2 and SP3 versions.
The new trigger for me was the license response.

/IAcceptSQLServerLicenseTerms=1

That wasn't needed in previous versions. The version of SQL in this article is SQL 2008 32bit. I've noticed that I didn't write anyting about the 64bit version and the new to me License triggers.

I haven't tested SP3 at this time but have been running SP2.

Download Link: Microsoft SQL Server 2008 SP3 Express Edition 

 If you have any issues with the newest version 64bit please share with me.

Here's the full setup for SQL 2008 R2 SP3 Copy and remove all the CrLf (Line feeds)

setup.exe /QS /ACTION=install /FEATURES=SQL,AS,RS,IS,Tools
/SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
/INSTANCENAME=SQLEXPRESS
/SAPWD=SAPassword
/SECURITYMODE=SQL
/SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
/TCPENABLED=1
/NPENABLED=1
/ENABLERANU=0
/IAcceptSQLServerLicenseTerms=1
/BROWSERSVCSTARTUPTYPE=automatic

 

Below are all still valid for both 64 and 32 bit adding the new trigger for the License agreement.

You may use the GUI installer or the command line installer. It's all up to you and how well you understand the application installtion process.

For me, I find the command line install easier and less confusing when I need to install the Express 2008 MS SQL.

Here's the steps. (Be sure you download the version of MS SQL you need.)

  1. Create your installation folder on your C:\ drive and name it MSSQL_INSTALL .
  2. Download Microsoft SQL Server 2008 Express Edition click [MS SQL 2008 click here] and select Save.  Save the file to C:\MSSQL_INSTALL .
  3. Open up the command prompt with Administrator privilages. Click on : All Programs > Accessories  then right-click on the Command Prompt icon and select Run as Administrator.  
  4. Change your current directory to your MSSQL_INSTALL directory.
  5. From within the command prompt window type the following command.
    1. SQLEXPR_x86_ENU /x: C:\MSSQL_INSTALL
    2. You are extracting the installation files into your installation folder.
  6. Copy / Paste or Type the following command line for your installation. Change the password (SA account).

I split the lines so you can see them on this page. Copy and paste them into notepad and remove the line returns making the command one long line.

setup.exe /QS /ACTION=install

/FEATURES=SQL,AS,RS,IS,Tools

/SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"

/INSTANCENAME=SQLEXPRESS

/SAPWD=ChangeMeNow!

/SECURITYMODE=SQL

/SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"

/TCPENABLED=1

/NPENABLED=1

/ENABLERANU=0

/BROWSERSVCSTARTUPTYPE=automatic

  1. Press enter and the installation process will begin.

Note: The Instance Name in the script can be changed if you have the need. I would recommend that you leave it as the default.

 

 I'll list a link to show you all the command line triggers for this type of installation.

If you are installing the Management Tools use your MS Installer under Remove or Uninstall features or something like that. I'll look up the wording later this week. It's important to install the management tools if you are going to be editing tables directly.

More details as questions come in.

Thanks again to you all, XtremeComputer.Com is becoming really great to update.

 

Microsoft Resource that might help you.

 

 

How to setup MS SQL 2008 Express using the command line. Make setup easy, and if you have more than one SQL server to setup the command line scripts can be added to a bat or vbs file to launch. Follow the simple guides and ask questions if you have them. Installation topics, GUI, Web PI and Command line installation. The resource link near the bottom offers more options. Command line triggers are also listed.