MSI, App-V, SCCM, Appsense, Citrix. This blog contains hints and tips on these technologies. Primarily it is an online notebook of items that I may need to refer to in the future, or things I constantly forget!
Thursday, March 29, 2012
MS SQL Express 2005 SP3
The page below describes using an ini file to provide input to the Setup.exe which allows it to run silently. The command line given is
setup.exe /settings <path to ini> /qn
ini file lines:
[Options]
USERNAME="My Company"
COMPANYNAME="My Company"
ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication
SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
INSTANCENAME=MSSQLSERVER
Although the ini file did work in the main, it did not generate an installation that exactly matched that which occured during an interactive installation.
http://msdn.microsoft.com/en-US/library/ms144259(v=sql.90).aspx#upgrade
Specifying the parmeters on the setup.exe command line did produce an installation exactly the same as the interactive one. SQLCOLLATION was the clients selected setting in this case. Other option are documented at the link above.
Install:
setup.exe USERNAME="Company Name" COMPANY="Company Name" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS INSTANCENAME=MSSQLSERVER /qn
Uninstall:
setup.exe REMOVE=All INSTANCENAME=MSSQLSERVER /qn