WORKAROUND
The use of an .ini file to specify properties to customize the installation of the SQL Server 2000 Desktop Engine is restricted to those who use the Setup.exe file included with the SQL Server 2000 Desktop Engine. Windows Installer does not provide the option to specify these settings in an .ini file. The Microsoft Knowledge Base article in the "References" section outlines a method that you can use to specify the custom properties for the SQL Server 2000 MSDE merge modules.
The SQL Server 2000 Desktop Engine setup program that supplies the Setup.exe file, also includes special code for reading and parsing the .ini file described in the SQL Server 2000 MSDE Books Online Help file. Note that if the .ini file is used to specify the specific parameters, then you should not pass the parameters on the command-line of Setup.exe. A sample .ini file for specifying these parameters follows. Please note that the specified directories must end with a backslash:
[Options]
TARGETDIR="C:\Program Files\SQL2000\"
DATADIR="C:\Program Files\SQL2000\"
INSTANCENAME=MyInstance
You can also specify Windows Installer properties such as REINSTALL and REINSTALLMODE through the .ini file when you use the Setup.exe file to install SQL Server 2000 MSDE. The complete list of Desktop Engine-specific options that can be specified in the .ini file follows:
- CALLBACK
- COLLATION
- DATADIR
- TARGETDIR
- INSTANCENAME
- SECURITYMODE
- UPGRADE
- UPGRADEUSER
REFERENCES
For more information about custom properties, see SQL Server 2000 Books Online
SQL Server 2000 Readme.txt
For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
281983 PRB: Cannot Specify Instance Name Using SQL Server 2000 Merge Modules