I have created a C# Windows application and used SQL Server 2008 R2 for database. So I need to install SQL Server on my client's machine to run my application.
For this I have created a setup using Installshield and added prerequisites SQL Server.
But the problem is: I need to install it silently so user doesn't have to configure it. I have tried a command line code but it not working, it's showing installing SQL Server, but it does not really get installed.
Code I have tried :-
SQLEXPRWT_x86_ENU.exe /q /Action=Install /Hideconsole
/Features=SQL,Tools /InstanceName=SQLExpress
/SQLSYSADMINACCOUNTS="Builtin\Administrators"
/SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSVCPASSWORD="a123"
I think you missing IACCEPTSQLSERVERLICENSETERMS parameter, it is required for silent install , it should be TRUE.
Check following Links.
How to install SQL Server 2008 R2 Express silently using command prompt
SQL Server 2008 R2 – Unattended Silent Install