keith kratochvil

SQL Server Books Online mentions the setup.exe approach:

local url:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm
online url: http://msdn2.microsoft.com/en-us/library/ms144259.aspx

I would probably lean toward using setup.exe

--
Keith Kratochvil


Hello,

we will redistribute the SQL-Server 2005 in our own setup-program. We
found two ways to call the installation:

setup.exe:
------
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVE ADDLOCAL=SQL_Engine
DISABLENETWORKPROTOCOLS=0
SQLCOLLATION="SQL_Latin1_General_Pref_CP1_CI_AS"
SQLACCOUNT="NT-AUTORITZT\SYSTEM"
SQLBROWSERACCOUNT="NT-AUTORITZT\SYSTEM"
AGTACCOUNT="NT-AUTORITZT\SYSTEM"
------

msiexec.exe:
------
:: SQL Native Client
msiexec.exe /i sqlncli.msi /qb /l*v "%temp%\sql2005log\sqlncli.log"
:: SQL-Setupunterstützungsdateien
msiexec.exe /i SqlSupport.msi /qb /l*v
"%temp%\sql2005log\SqlSupport.log"
:: SQL-Server nur SQL_Engine
msiexec.exe /i SqlRun_SQL.msi /qb /l*v
"%temp%\sql2005log\SqlRun_SQL.log" INSTANCENAME=DATEV_SV_SE01
ADDLOCAL=SQL_Engine DISABLENETWORKPROTOCOLS=0
COLLATION="SQL_Latin1_General_Pref_CP1_CI_AS"
SQLACCOUNT="NT-AUTORITZT\SYSTEM"
SQLBROWSERACCOUNT="NT-AUTORITZT\SYSTEM"
AGTACCOUNT="NT-AUTORITZT\SYSTEM"
-----

Which is the better way to install?
Which is way is supported by microsoft?

Maybe we will change the productcode of the SqlRun_SQL msi-File?
Are there any known problems?

Thanks
WebMan
[MCSE, MCDBA]