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

Article:TECH49523  |  Created: 2009-01-05  |  Updated: 2014-02-19  |  Article URL http://www.symantec.com/docs/TECH49523
Article Type
Technical Solution

Product(s)

Subject

Issue



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

 


Solution



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



285764


Article URL http://www.symantec.com/docs/TECH49523


Terms of use for this information are found in Legal Notices