none
SQL Express 2008 Command Line Options

    Question

  • I am using the following cmdline option with SQLEXPR_x86_ENU.exe in a c# code and it is throwing an error. The same expression works ok with sql Express 2005.

     

                                  szParam = " /qb" + " ADDLOCAL=SQL_Engine,SQL_Data_Files INSTANCENAME=TEST101 SAPWD=" + G_STRSQLUSERPASSWORD + " SQLAUTOSTART=1 SECURITYMODE=SQL SQLCOLLATION=" + strSQLCollation + " DISABLENETWORKPROTOCOLS=0 SQLACCOUNT=" + "\"" + strSQLAccount + "\"" + " INSTALLSQLDIR=" + "\"" + G_SELECTED_SQLDIR + "\"";

     

     

     

    Error message:-

     

    TITLE: SQL Server Setup failure.
    ------------------------------

    SQL Server Setup has encountered the following error:

    The syntax of argument "/QB" is incorrect. Either the delimiter '=' is missing or there is one or more space characters before the delimiter '='. Please use /? to check usage.

    Error code 0x84B40001.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

     

    What is the corrected cmdline for 2008 sql express installation?

     

    Thanks,

    Ravi

     

    Monday, July 21, 2008 6:37 PM

Answers

All replies

  • You can see if this thread is useful for you.Wink

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2791283&SiteID=1

     

    Monday, July 21, 2008 8:17 PM
  • I tried the "/qs" option instead of '/qb'. I did not get the previous error reported. However it did not create a SQL instance of our database. During the installation I noticed a DOS window with some messages but was not able capture those. So, are there any options that need to be changed for 2008 SQL?
    Thursday, July 24, 2008 3:43 PM
  • Do you still use this one for the install of SQL Express 2008?

    ADDLOCAL=SQL_Engine,SQL_Data_Files

     

    You can try ADDLOCAL=SQL, Tools to see if it is working.

    Install comand lines between 2005 and 2008 are little bit different. Smile

     

     

     

    Thursday, July 24, 2008 10:54 PM
  • How to: Install SQL Server 2008 from the Command Prompt

    http://msdn.microsoft.com/en-us/library/ms144259(SQL.100).aspx

     

    Monday, July 28, 2008 10:20 PM
  • Thanks, I've tried this and able to install silently successfully.

    Now, if I want to uninstall silently while uninstalling my product, How shall I do this/

    I'm trying to install/uninstall SQL Server 2008 Express using InstallShield for Windows Vista and XP.

    Thanks.
    Monday, March 02, 2009 9:44 PM
  • Are you using Installshield while installing SQL Server 2008?

    I'm trying to install silently SQL Server 2008 Express by using command line in Installshield.

    Also, Do you know how to unintall silently in Installshield?

    Did you declare "szParam" under the database.rul?

    Please reply ASAP.

    Thanks.

    • Proposed as answer by pinky091 Wednesday, March 04, 2009 3:50 PM
    Monday, March 02, 2009 9:48 PM
  • hello dears

    I want install sql server express by installshield....why should I do?:d

    please guide me

    Monday, February 28, 2011 10:14 PM