Posted on: 6/4/2012 9:20:39 AM | Views : 197

I'm trying to do silent installation of "SQL Express 2008 R2 SP1 x86" On Windows 2008 Server using below commands to create two SQL instances (TestA and TestB) through windows installer package
i. SQLEXPR.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /INSTANCENAME=TESTA /NPENABLED=1 /TCPENABLED=1 /SQLSVCACCOUNT=test\administrator /SQLSVCPASSWORD=******** /SQLSVCSTARTUPTYPE=Automatic
ii. SQLEXPR.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /INSTANCENAME=TESTB /NPENABLED=1 /TCPENABLED=1 /SQLSVCACCOUNT=test\administrator /SQLSVCPASSWORD=******** /SQLSVCSTARTUPTYPE=Automatic
Above commands works fine on most of the machines. But on some machines SQL installation is getting failed with error "0x84C40013". Please find the attached sql installation logs.
In failed cases we have observed that one instance is successfully installed and service is visible in Service manager (services.msc)

Go to the complete details ...