How to install SQL Express using CLI

Article:TECH49523  |  Created: 2009-01-05  |  Updated: 2010-11-18  |  Article URL http://www.symantec.com/docs/TECH49523
Article Type
Technical Solution

Product(s)

Subject

Problem



How to install SQL Express using CLI


Solution



To install SQL Express using 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. Refer the task manager and verify that the installation is running by checking for msiexec.exe and setup.exe. Refer 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 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