Pages

Friday, May 30, 2008

Using Command Prompt Options to Install SQL Server Express

Using Command Prompt Options to Install SQL Server Express :-

Installation Of Sql Server 2005 Using Command Prompt( Silent Mode )

Here is the command line I am using : -


Start /wait SQLEXPR32.exe   /qb INSTANCENAME=MSSQLSERVER  INSTALLSQLDIR="C:\Program Files" TALLSQLSHAREDDIR="C:\ProgramFiles" ADDLOCAL=All ERRORREPORTING=1 SQLAUTOSTART=1 SQMREPORTING=1 SAPWD=Lobby@123 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1
To install SQL Server Express 2008 following is the command-line


SQLEXPR32_x86_ENU.exe /q /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS
   /INSTANCENAME=SQLSERVER /ROLE=AllFeatures_WithDefaults
   /ADDCURRENTUSERASSQLADMIN=TRUE /SQLSVCACCOUNT="NT AUTHORITY\Network Service"
   /FEATURES=SQL

Related Other posts

5 comments:

  1. Do you Have Solution for SQL 2008 Express? Thanks..

    ReplyDelete
  2. SQLEXPR32_x86_ENU.exe /QS /ACTION=Install /FEATURES=SQLEngine /IAcceptSQLServerLicenseTerms=TRUE /SECURITYMODE=SQL /INSTANCENAME=SecureBytes /SAPWD="P@%%W)RD" /ENABLERANU /ERRORREPORTING=1 /INDICATEPROGRESS /ADDCURRENTUSERASSQLADMIN=TRUE /NPENABLED=1 /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\Network Service"/SKIPRULES=RebootRequiredCheck SQLAUTOSTART=1

    http://www.secure-bytes.com/

    ReplyDelete
  3. It looks this batch file installs service pack only ????

    ReplyDelete
  4. A fascinating discussion is worth comment. I do think that you should publish more about this topic, it might not be a
    taboo subject but typically people do not discuss such issues.
    To the next! Many thanks!!
    My webpage : Databinding a GridView in C# with ADO.NET

    ReplyDelete