TechNet
• Products
• IT Resources
• Training
• Support

# Specifying Setup Properties with an .ini File (64-bit)

This topic applies only to SQL Server 2000 (64-bit).

Optionally, the setup command line properties can be specified using an .ini file. On the setup command line, use the /settings ini_file argument to specify the .ini file. The first line in the .ini file must contain the string [Options].

The \Template.ini file on the SQL Server 2000 (64-bit) installation compact disc provides detailed instructions for creating an ini file. The format of the .ini file is illustrated in this example:

[Options]
COMPANYNAME=MyCompany
PIDKEY=ABCDE12345FGHIJ67890KLMNO
INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
INSTALLSQLDATADIR="C:\Program Files\Microsoft SQL Server\"
INSTANCENAME=MyInstance
SQLACCOUNT=MyDomain/MyAccount
...


Important  Property settings that contain spaces must be enclosed between double quotation marks, and paths must always end with a backslash (\) character.

You can also use an .ini file to specify property settings for an existing installation of SQL Server 2000. To maintain an existing instance using an .ini file, you must also include the /i package_file argument on the command line to specify the package file for the instance. Include the /i on the command line with the /settings argument. For example:

setup /i sqlrun01.msi /settings myinstance.ini /l*v c:\myinstance.log


Alternatively, you can specify the product code from the ProductCode registry key. For the default instance use HKEY_Local_Machine\Software\Microsoft\MSSQLServer\Setup:ProductCode. For a named instance use HKEY_Local_Machine\Software\Microsoft SQL Server\instancename\Setup:ProductCode.