Silent Installation of SQl Express 2005

Question

Can someone please tell me about the procedure for automatically installing SQL Server Express 2005 and how to specify the installation options.

Answer 1

Get MSI and do

string InstallFile = "SSCERuntime-ENU-x86.msi" string LogFile = "C:\Install.log" Process proc; proc = Process.Start("msiexec", "/l " + LogFile + " /quiet /i " + InstallFile); 

Answer 2

If you do this to support desktop application deployment, this is a bad idea.

Use the compact version of SQL Server, not Express Edition. It is more suitable for situations in the process, and it is much easier to deploy.

Answer 3

Thanks for the quick answer, I would try, but I want something like this for SQL EXPRESS http://msdn.microsoft.com/en-us/library/ms144259.aspx

Answer 4

Here you can find the variables, http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

You should be able to silently install using msiexec / qn REBOOT = ReallySuppress ADDLOCAL = ALL INSTANCENAME = SAPWD =

You might want to install some other vars that you can find in the link above, for example, SQLAUTOSTART and DISABLENETWORKPROTOCOLS.