Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Sql Server Express Installation Issues

Author  Topic 

aex
Yak Posting Veteran

60 Posts

Posted - 2011-12-05 : 02:19:39
Recently, I try to install express edition using the following command via command prompt:

SQLEXPRWT_x86_ENU.exe /Q /SAPWD="aex123" /ConfigurationFile="C:\Configuration.ini"

The content in the configuration file is as below:

[SQLSERVER2008]
INSTANCEID="MSSQLSERVER111"
ACTION="Install"
FEATURES=SQL
HELP="False"
INDICATEPROGRESS="False"
IACCEPTSQLSERVERLICENSETERMS="True"
X86="False"
ROLE="AllFeatures_WithDefaults"
ENU="True"
ERRORREPORTING="False"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
SQMREPORTING="False"
INSTANCENAME="MSSQLSERVER111"
AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
AGTSVCSTARTUPTYPE="Disabled"
ISSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT AUTHORITY\NetworkService"
ASSVCSTARTUPTYPE="Automatic"
ASCOLLATION="Latin1_General_CI_AS"
ASDATADIR="Data"
ASLOGDIR="Log"
ASBACKUPDIR="Backup"
ASTEMPDIR="Temp"
ASCONFIGDIR="Config"
ASPROVIDERMSOLAP="1"
FARMADMINPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="True"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS"
SECURITYMODE="SQL"
ADDCURRENTUSERASSQLADMIN="True"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="FilesOnlyMode"


The problem I have is the installation works successfully in Windows XP but not in Windows 7.

In Windows 7, it works only if I use the /QS switch instead of /Q switch. Is this a known issue for SQL Server Expression installation? Or is there any other workaround on this?

aex
   

- Advertisement -