Silent SQL Server 2008 SP1 Express install and verify

[guoqiang]

Step 1) "D:\WCU\SSE\SQLExpr32_x86_enu.exe" /q /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLEXPRESS /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCStartupType=Automatic /AddCurrentUserAsSqlAdmin /ENABLERANU=1 /SKIPRULES=RebootRequiredCheck /hideconsole /TIMESTAMP="VSExpress_10.0"

Warning: the above silent parameters doesn't work for Microsoft SQL Server 2008 R2 Nov (CTP3)

Recommended: copy and paste into cmd.exe environment

step 2) while it is still installing background, open taskmgr.exe, monitor the process SQLxxx in the list

Suggestion: when SQLxxx is not shown in the list, it means the silent install fails to work, then check out SQL error log in Temp directory; e.g. missing Windows Installer 4.5

step 3) when these two program services (sqlservr.exe, sqlwriter.exe) running, the installer has finished its task

Suggestion: please wait until setup100.exe process in the task manager disappears

( can be verified by CCleaner225 under Win7 environment)

Microsoft SQL Server 2008 Microsoft Corporation

Microsoft SQL Server 2008 Browser Microsoft Corporation 7.94 MB

Microsoft SQL Server 2008 Native Client Microsoft Corporation 2.89 MB

Microsoft SQL Server 2008 Setup Support Files Microsoft Corporation 28.6 MB

Microsoft SQL Server VSS Writer Microsoft Corporation 1.81 MB

OR,

(can be verified by using Win7's Windows PowerShell)

IdentifyingNumber : {4A6F34E2-09E5-4616-B227-4A26A488A6F9}

Name : Microsoft SQL Server 2008 Common Files

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Common Files

IdentifyingNumber : {B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2}

Name : Microsoft SQL Server 2008 Database Engine Services

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Database Engine Services

IdentifyingNumber : {58721EC3-8D4E-4B79-BC51-1054E2DDCD10}

Name : Microsoft SQL Server 2008 Database Engine Services

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Database Engine Services

IdentifyingNumber : {D441BD04-E548-4F8E-97A4-1B66135BAAA8}

Name : Microsoft SQL Server 2008 Setup Support Files

Vendor : Microsoft Corporation

Version : 10.1.2731.0

Caption : Microsoft SQL Server 2008 Setup Support Files

IdentifyingNumber : {196E77C5-F524-4B50-BD1A-2C21EEE9B8F7}

Name : Microsoft SQL Server 2008 Common Files

Vendor : Microsoft Corporation

Version : 10.0.1600.22

Caption : Microsoft SQL Server 2008 Common Files

IdentifyingNumber : {F3494AB6-6900-41C6-AF57-823626827ED8}

Name : Microsoft SQL Server 2008 Database Engine Shared

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Database Engine Shared

IdentifyingNumber : {B857D868-F8B0-43EE-BC2B-D9E5ED21F237}

Name : Microsoft SQL Server VSS Writer

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server VSS Writer

IdentifyingNumber : {33AE9E89-47C9-4A0D-9E9D-BDD6966A3804}

Name : Microsoft SQL Server 2008 RsFx Driver

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 RsFx Driver

IdentifyingNumber : {4815BD99-96A4-49FE-A885-DCF06E9E4E78}

Name : Microsoft SQL Server 2008 Database Engine Shared

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Database Engine Shared

IdentifyingNumber : {C688457E-03FD-4941-923B-A27F4D42A7DD}

Name : Microsoft SQL Server 2008 Browser

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Browser

IdentifyingNumber : {4F44B5AE-82A6-4A8A-A3E3-E24D489728E3}

Name : Microsoft SQL Server 2008 Native Client

Vendor : Microsoft Corporation

Version : 10.1.2531.0

Caption : Microsoft SQL Server 2008 Native Client

step 4) open cmd.exe, and type: osql -S .\sqlexpress -E

1> print @@version

2> go

>>> Microsoft SQL Server 2008 (SP1) - 10.0.2531.0

Express Edition...

Suggestion: the above step no. 4 can be used to verify for SQL Server 2005 Express

The above steps works for my XP SP2 too!

Edited November 26, 2009 by guoqiang