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.
By default, when you install SQL Server by running SQL Server Setup interactively, your setup options are recorded into a setup initialization file. This file, Setup.iss, is placed in the \Mssql7\Install directory.
SQL Server Setup can also generate an .iss file without actually installing SQL Server. In the \x86\Setup or \Alpha\Setup directory on the SQL Server compact disc, run this program from the command prompt:
setupsql.exe k=Rc
Running Setupsql.exe with the k=Rc option causes SQL Server Setup to write the Setup.iss file to the \Windows or \WinNT directory while you select setup options rather than waiting until after the files are copied. When the Setup program prompts you that it is ready to begin copying files, click Cancel to exit without installing SQL Server.
The Setup.iss file created with the k=Rc option is incomplete. Add the [SdStartCopy-0] and [SdFinish-0] sections detailed at the end of the setup initialization file format sections, below.
The file should be saved with the .iss file name and be compatible with the Windows initialization file format.
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 |