How to install SQL Express from the Windows CLI (Command Line Interface)

Article:TECH49523  |  Created: 2009-01-05  |  Updated: 2014-02-19  |  Article URL
Article Type
Technical Solution




There may be times when it is necessary to install Microsoft SQL Express from a command line.



To install SQL Express using the command line interface (CLI) perform the following steps:

1. Go to command prompt.

2. Browse to the path where SQLExpress.exe is located.

3. Type the following command:

SQLEXPR.exe /wait /qn /norestart /lv "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt" INSTANCENAME=BKUPEXEC INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\" INSTALLSQLDATADIR="C:\Program Files\Microsoft SQL Server\" INSTALLSQLSHAREDDIR="C:\Program Files\Microsoft SQL Server\" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,Client_Components,Connectivity BLANKSAPWD=1 DISABLENETWORKPROTOCOLS=0

4. This will extract the contents. Refer to figure 1.

Figure 1

5. Open task manager and verify that the installation is running by checking for msiexec.exe and setup.exe. Refer to figure 2.
Figure 2

6. After SQL Express is installed successfully, the Task Manager no longer shows setup.exe.

7. The sqlserver.exe process is now present. Refer to figure 3.
Figure 3


Legacy ID


Article URL

Terms of use for this information are found in Legal Notices