How to install SQL Express using CLI
Details:
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
Products Applied:
Backup Exec for Windows Servers 11d (11.0), 12.0, 12.5
Subjects:
Backup Exec for Windows Servers
Application: How To, Installation
Languages:
English (US)
Operating Systems:
Windows 2000Advanced Server, Datacenter Server, Server
Windows Server 2003
DataCenter, Enterprise Server, Standard Server
Windows Small Business Server 2003
Premium Edition, Standard Edition
THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.