Creating a Setup Initialization File

A setup initialization file specifies all the options a user might select in SQL Server Setup, allowing the Setup program to run without prompting from the user. The Microsoft® SQL Server™ compact disc comes with three setup initialization files. If you want initialization options other than these, create a new setup initialization file rather than edit an existing one.

A setup initialization file can be created using two methods.

Format of the Setup Initialization File

The setup initialization file is a text file that uses standard Windows .ini file format. The sections, key names, and values are described in the following tables.

[InstallShield Silent]

  

This section is required for InstallShield. Do not change the values.

Entry Description Value
Version Version of the InstallShield Silent response file v5.00.000
File   Response File

[DlgOrder]

  

List each dialog box in the order it appears in an attended setup. The listing in this section must correspond to the other sections in the setup initialization file. An entry is required for each section name that ends in a number.

Entry1 Description Value2
Dlg0 First dialog box SetupMethod-0
Count Number of dialog boxes listed in this section  
Dlg1 Second dialog box SdWelcome-0
Dlg2 Third dialog box SdLicense-0
1 This example includes only a partial listing. You must include an entry for each attended setup dialog box.

2 If you click Back during an attended setup, multiple sections are recorded in the Setup.iss for each dialog box displayed more than one time. The section name of the first instance has a -0 ending. The second instance has a -1 ending. Only the last instance of a dialog box determines the setup options used.


[SetupMethod-0]

  

Corresponds to the Select Install Method dialog box.

Entry Description Value
Component-type   String
Component-count   1
Component-0 Specifies where SQL Server is being installed Remote
Local
Result Dialog box return value 1 = Next

[SkRemoteInfo]

  

Corresponds to the Remote Setup Information dialog box. This section is included for a remote installation only.

Entry Description Value
svEdit1 Domain user account to connect to target computer  
svEdit2 Domain user account password  
svEdit3 Domain name  
svEdit4 Target computer name \\computername
svEdit5 Target computer path, including the computer name and volume \\computername\volume
svEdit6 Path of the SQL Server source files  
Result Dialog box return value 1 = Next

[SdWelcome-0]

  

Corresponds to the Welcome dialog box.

Entry Description Value
Result Dialog box return value 1 = Next

[SdLicense-0]

  

Corresponds to the Software License Agreement dialog box.

Entry Description Value
Result Dialog box return value 1 = Yes

[SdRegisterUser-0]

  

Corresponds to the User Information dialog box.

Entry Description Value
szName User or owner  
szCompany Organization  
Result Dialog box return value 1 = Next

[CDKEYDialog-0]

  

Specify your product ID in this section, where xxx-xxxxxxx is the 10-digit CD key found on the yellow sticker of your compact disc liner notes or compact disc sleeve, and yyyy is a number of your choice, up to five digits.

Entry Description Value
svCDKey Product ID 28174-xxx-xxxxxxx-yyyy
Result Dialog box return value 1 = Next

[AskOptions-0]

  

Corresponds to the Convert Existing SQL Server Data dialog box, which asks the user if he or she wants to run the SQL Server Upgrade Wizard at the end of setup to convert existing SQL Server 6.x databases to SQL Server 7.0. This section applies only to computers that have a previous version of SQL Server already installed.

Entry Description Value
Sel-0 Check box for running the SQL Server Upgrade Wizard 1 = Yes
0 = No
Result Dialog box return value 1 = Next

[SetupTypeSQL-0]

  

Corresponds to the Setup Type dialog box, which asks a user to select the type of installation and specify the file destination folders.

Entry Description Value
SzDir Directory where SQL Server program files are installed  
SzDir Directory where SQL Server data files are installed  
Result Dialog box return value 301 = Typical
302 = Minimum
303 = Custom

[SQLComponentMult-0]

  

Corresponds to the Select Components dialog box. This applies only when the setup type is Custom. The entries are an internal list of component names of the selected components. If you want to perform a custom setup, run SQL Server Setup interactively to create a list of components to install.

[DlgCpSortUnicode-0]

  

Corresponds to the Character Set/Sort Order/Unicode Collation dialog box. The character set is uniquely identified by the Sort Order ID and is not needed as an entry. Although this dialog box is shown only in a custom installation, this section is always included in the setup initialization file.

Entry Description Value
SortId Sort order ID For more information, see Sort Order IDs
LCID Unicode locale ID For more information, see Unicode Collation
CompStyle Bitmask that represents the Unicode comparison styles 0x00001 = ignore case
0x00002 = ignore accent
0x10000 = ignore Kana
0x20000 = ignore width
Result Dialog box return value 1 = Next

[DlgServerNetwork-0]

  

Corresponds to the Network Libraries dialog box. Although this dialog box is shown only in a custom installation, this section is always included in the setup initialization file.

Entry Description Value
NetworkLibs Bitmask that represents the network libraries to configure NET_NMP = 0xF = Name Pipes
NET_TCP = 0xF0 = TCP/IP Sockets
NET_RPC = 0xF00 = Multiprotocol
NET_NWL = 0xF000 = NWLink IPX/SPX
NET_APL = 0xF0000 = AppleTalk
NET_BAN = 0xF00000 = Banyan Vines
NET_ENC = 0xF0000000 = Multiprotocol encryption
TCPPort TCP/IP port number, used when TCP/IP Sockets is configured Default = 1433
TCPPrxy Remote WinSock proxy address, used when TCP/IP is configured  
NMPPipeName Named pipe name, used when Named Pipes is configured \\.\pipe\sql\query
NWLinkObj Novell Bindery service name  
BanyanObj StreetTalk service name  
ApplObj AppleTalk service object  
Result Dialog box return value 1 = Next

[DlgServices-0]

  

Corresponds to the Services Accounts dialog box. This section is not included for installations on Windows 95/98.

Entry Description Value
Local-Domain Bitmask that represents whether the service accounts are local system or a Windows NT domain account SQL_LOCAL = 0xF
SQL_DOMAIN = 0xF0
AGT_LOCAL = 0xF00
AGT_DOMAIN = 0xF000
autoStart Bitmask that defines whether services are configured to autostart SQL_AUTO = 0xF
AGT_AUTO = 0xF0
SQLDomain Domain of user account for MSSQLServer service  
SQLDomainAcct MSSQLServer domain account  
SQLDomainPwd MSSQLServer domain account password Encrypted password generated by setup. This can be obtained only by running setup and generating an .iss file.
AgtDomain Domain of user account for SQLServerAgent service  
AgtDomainAcct SQLServerAgent domain account  
AgtDomainPwd SQLServerAgent domain account password Encrypted password generated by setup. This can be obtained only by running setup and generating an .iss file.
Result Dialog box return value 1 = Next

[SdStartCopy-0]

  

Corresponds to the Start Copying Files dialog box.

Entry Description Value
Result Dialog box return value 1 = Next

[License]

  

Corresponds to the Choose Licensing Mode dialog box.

Entry Description Value
License Mode Dialog box return value PERSERVER
PERSEAT
License Limit Number of client access licenses for this installation of SQL Server (for PERSERVER license mode only)  

[SdFinish-0]

  

Corresponds to the Setup Complete dialog box.

Entry Description Value
bOpt1 Not used, placeholder as part of stock dialog box  
bOpt2 Not used, placeholder as part of stock dialog box  
Result Dialog box return value 1 = Next

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.