Creating a Setup File Manually
You create a customized setup initialization file interactively when you select the Record Unattended option in Microsoft® SQL Server™ 2000 Setup. You can also edit files manually, to further refine and customize setup initialization files.
Creating or Modifying a Setup File Using a Text Editor
You can use a text editor to modify the Setup.iss file generated using the Record Unattended .ISS file option. You can also modify one of the sample setup files (*.iss) included on the SQL Server 2000 compact disc or you can create your own setup file.
To modify one of the sample setup initialization files found on the SQL Server compact disc, open the file in a text editor and modify as required. Keep the file compatible with the Microsoft Windows® initialization file format and save it with the .iss file name extension.
Format of a Sample Setup Initialization File
A setup initialization file is a text file that uses the standard Windows .ini file format. Sections of the sample setup initialization file for a typical installation of Microsoft SQL Server 2000 are described in the tables that follow. This sample file (Sqlins.iss) is found in the root directory of the SQL Server compact disc.
Note In creating a setup file for a named instance of SQL Server 2000, you must indicate the instance name you want to install and the path required to navigate through the setup screens. The Instance Name dialog box [DlgInstanceName] section must be modified, as well as other places in the setup file where the instance name appears.
[InstallShield Silent]
This section is required for InstallShield. Do not change the values.
| Entry | Value | Description |
|---|---|---|
| Version | v5.00.000 | Version of the InstallShield Silent response file. |
| File | Response File | Indicates this is the Response File. |
[File Transfer]
| Entry | Value | Description |
|---|---|---|
| OverwriteReadOnly | NoToAll | Do not overwrite read-only files. |
[DlgOrder]
Lists 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.
| Entry | Value | Description |
|---|---|---|
| Dlg0 | SdWelcome-0 | Initial dialog box |
| Count | 14 | Number of dialog boxes listed in this section |
| Dlg1 | DlgMachine-0 | Next dialog box |
| Dlg2 | DlgInstallMode-0 | Next dialog box |
| Dlg3 | SdRegisterUser-0 | Next dialog box |
| Dlg4 | SdLicense-0 | Next dialog box |
| Dlg5 | CDKEYDialog-0 | Next dialog box |
| Dlg 6 | DlgClientServer-0 | Next dialog box |
| Dlg7 | DlgInstanceName-0 | Next dialog box |
| Dlg8 | SetupTypeSQL-0 | Next dialog box |
| Dlg9 | DlgServices-0 | Next dialog box |
| Dlg10 | DLGSqlSecurity-0 | Next dialog box |
| Dlg11 | DlgCollation-0 | Next dialog box |
| Dlg12 | DlgServerNetwork-0 | Next dialog box |
| Dlg13 | SdStartCopy-0 | Next dialog box |
| Dlg14 | SdFinish-0 | Last dialog box |
[SdWelcome-0]
Corresponds to the Welcome dialog box.
| Entry | Value | Description |
|---|---|---|
| Result | 1 | Next |
[DlgMachine-0]
Corresponds to the Computer Name dialog box.
| Entry | Value | Description |
|---|---|---|
| Type | 1 | Local computer |
| Result | 1 | Next |
[DlgInstallMode-0]
Corresponds to the Installation Selection dialog box.
| Entry | Value | Description |
|---|---|---|
| Type | 1 | Create a new instance |
| Result | 1 | Next |
[SdRegisterUser-0]
Corresponds to the User Information dialog box.
| Entry | Value | Description |
|---|---|---|
| szName | <user name> | Name of user; company name is not required. |
| Result | 1 | Next. |
[SdLicense-0]
Corresponds to the Software License Agreement dialog box.
| Entry | Value | Description |
|---|---|---|
| Result | 1 | Yes |
[CDKEYDialog-0]
Corresponds to the CD-Key dialog box.
| Entry | Value | Description |
|---|---|---|
| svCDKey | <CD key value> | Specified for each installation |
| Result | 1 | Next |
[DlgClientServer-0]
Corresponds to the Installation Definition dialog box.
| Entry | Value | Description |
|---|---|---|
| Type | 2 | Server and client tools |
| Result | 1 | Next |
[DlgInstanceName-0]
Corresponds to the Instance Name dialog box.
| Entry | Value | Description |
|---|---|---|
| InstanceName | MSSQLSERVER | Designation of the default instance (always the same). |
| InstanceName | <instance name> | Designation of a named instance. |
| Result | 1 | Next. |
[SetupTypeSQL-0]
Corresponds to the Setup type dialog box.
| Entry | Value | Description |
|---|---|---|
| szDir | %PROGRAMFILES%\Microsoft SQL Server | Directory where SQL Server program files are installed. |
| Result | 301 | Typical (301)
(302 = Minimum and 303 = Custom). |
| szDataDir | %PROGRAMFILES%\Microsoft SQL Server | Directory where SQL Server data files are installed (same as program files). |
[DlgServices-0]
Corresponds to the Services Accounts dialog box.
| Entry | Value | Description |
| Local-Domain | 3855 <other numeric value> |
Use the same account for each service.
To customize the settings for each service, see Setup Initialization File Details. |
| AutoStart | 15 | Autostart Service is enabled. |
| Result | 1 | Next. |
[DlgSQLSecurity-0]
Corresponds to the Authentication dialog box. Choices shown here include options not in the sample Sqlins.iss file.
| Entry | Value | Description |
| LoginMode | -1 | System default security is used.
The Microsoft Windows NT® default is Windows Authentication Mode. The Microsoft Windows 98 default is Mixed Mode, with no sa password. |
| LoginMode | 1 | Windows Authentication Mode. |
| LoginMode | 2 | Mixed Mode. |
| szPwd | <choice of password> | Used only with Mixed Mode security. |
| Result | 1 | Next. |
[DlgCollation-0]
Corresponds to the Collation Settings dialog box.
| Entry | Value | Description |
|---|---|---|
| collation_name | ' ' | When blank, system default collation is used. |
| collation_name | <collation designator> | Selected by user. For more information, see Collation Settings in Setup. |
[SdServerNetwork-0]
Corresponds to the Network Libraries dialog box.
| Entry | Value | Description |
|---|---|---|
| NetworkLibs | 255
245 15 |
Named pipes and TCP/IP
Value 245 = TCP/IP only Value 15 = Named pipes only To customize network library settings, see Setup Initialization File Details |
| TCPPort | 1433 | Port address, for TCP/IP |
| TCPPrxy | Default | Default proxy, or what is entered |
| NMPPipeName | \\.\pipe\sql\query | Pipe name |
| Result | 1 | Next |
[SdStartCopy-0]
Corresponds to the Start Copying Files dialog box.
| Entry | Value | Description |
|---|---|---|
| Result | 1 | Next |
[SdFinish-0]
Corresponds to the Setup Complete dialog box.
| Entry | Value | Description |
|---|---|---|
| Result | 1 | Next |
| bOpt1 | 0 | Placeholder for stock dialog box |
| bOpt2 | 0 | Placeholder for stock dialog box |