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