[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!

This post has been edited by guoqiang: 26 November 2009 - 05:50 PM