Customizing SQL/MSDE unattended installation files (233312)

MORE INFORMATION

The .iss file has a structure similar to a standard Windows .ini file. Entries are grouped together under a section, and section names are denoted by square brackets ("[" and "]"). For example, the following is the first section in the .iss file:

  [InstallShield Silent]
  Version=v5.00.000
  File=Response File
				

Installation path

    [SetupTypeSQL-0]
    szDir=C:\MSSQL7
    szDataDir=C:\MSSQL7

				

There are two installation directories for SQL Server or MSDE. The root directory specifies the location of the binaries and log files. The data directory specifies the location of database files for the master, msdb, pubs (SQL Server only), and model databases. It is also the default location for new user databases. Modify the szDir parameter to change the root directory, and modify szDataDir to change the data directory. By default these directories will be the same. If these directories are on NTFS partitions, both the user that will be installing MSDE and the Microsoft Windows NT account that you select as the SQL Server/MSDE service startup account (see the Service Startup Account section below) must have Full Control permissions on them. Setup fails if the required permissions are not available.

Server-side network libraries

    [DlgServerNetwork-0]
    NetworkLibs=4095
    TCPPort=1433
    TCPPrxy=Default
    NMPPipeName=\\.\pipe\sql\query

				

The following network libraries can be included: Named Pipes, TCP/IP sockets, Multi-Protocol, NWLink IPX/SPX, AppleTalk ADSP, and Banyan Vines. The Named Pipes and Banyan Vines server-side Net-Libraries cannot be installed on Microsoft Windows 95 or Windows 98.

Note For other restrictions that apply to SQL Server/MSDE when running on Windows 95 or Windows 98, see the SQL Server Books Online article "SQL Server 7.0 on Windows 95/98". The .iss entry NetworkLibs is a bitmask that represents the netlibs to install. The values in the bitmask for each network library are below (values are provided in hexadecimal and decimal):

Netlib	Value (Hex)	Value (Decimal)
Name Pipes	0x0000000F	15
TCP/IP Sockets	0x000000F0	240
Multiprotocol	0x00000F00	3840
NWLink IPX/SPX	0x0000F000	61440
AppleTalk	0x000F0000	983040
Banyan Vines	0x00F00000	15728640
Multiprotocol encryption	0xF0000000	-268435456

To specify which server-side netlibs to install, combine the hexadecimal values with bitwise OR operations and write out this value to the NetworkLibs entry as a 32-bit signed integer. For example, suppose you want to install Named Pipes and Multiprotocol and you want to enable Multiprotocol encryption (Multiprotocol encryption does not have any effect unless Multiprotocol is also included). You would use the hex value F0000F0F, which is -268431601 when represented as a 32-bit signed integer:

       0000000F   (Named Pipes)
    OR 00000F00   (Multiprotocol)
    OR F0000000   (Multiprotocol encryption)
    -----------
       F0000F0F  =  -268431601
  
				

Alternatively, use the following method:

Add up the values in the "Value (Decimal)" column in the above chart for the network libraries you want to include. For example, to include Named Pipes, Multiprotocol, and Multiprotocol encryption:

               15   (Named Pipes)
    +        3840   (Multiprotocol)
    +  -268435456   (Multiprotocol encryption)
    -------------
       -268431601
  
				

Note You should always include Named Pipes, unless you are installing on Windows 95 or Windows 98.

The NMPPipeName entry is the named pipe name on which SQL Server listens. It should not be changed from the default ("\\.\pipe\sql\query") without justification.

The TCPPort entry specifies the TCP/IP port number, used when TCP/IP Sockets is installed. It should generally not be changed from the default of 1433.

The entry TCPPrxy is the remote WinSock proxy address, which also only applies when TCP/IP is configured. In most cases it will be "Default".

The NWLinkObj entry is the Novell Bindery service name. This entry only exists when NWLink IPX/SPX is included.

The BanyanObj entry is the StreetTalk service name. It is only used when Banyan Vines is selected.

The ApplObj entry is the AppleTalk service object. It is only used when the AppleTalk ADSP netlib is selected.

Code page, sort order, Unicode collation, and comparison style

    [DlgCpSortUnicode-0]
    SortId=52
    LCID=1033
    CompStyle=196609

				

The SortID entry identifies both the code page and sort order of the SQL Server/MSDE. In most circumstances the default SortID of 52 (this specifies code page 1252 and a Dictionary order, case-insensitive sort order) should be used. Each code page (also referred to as a character set) has a set of supported sort orders associated with it. Each sort order is identified by a Sort Order ID; a Sort Order ID also uniquely identifies the code page that the sort order is associated with. For a list of alternate Sort Order IDs (and the associated character sets), see the SQL Server 7.0 Books Online article "Sort Order IDs". For additional general information on this topic, see the Books Online article "Code Pages and Sort Orders".

The locale ID entry (LCID) specifies a Unicode collation. A Unicode collation defines the way that Unicode data is sorted (this is similar in function to a sort order for character data). In general, the default locale ID of 1033 (General Unicode) should be used. If you require an alternate sorting of Unicode data, see the Books Online article "Unicode Collation".

Sorting of Unicode characters within a Unicode collation can be adjusted by modifying the Unicode comparison style. Generally you should accept the default value of 196609. The Unicode comparison style is represented by the CompStyle entry, a bitmap with the following components:

Style	Value (Hex)	Value (Decimal)
Ignore case	0x00001	1
Ignore accent	0x00002	2
Ignore Kana	0x10000	65536
Ignore width	0x20000	131072

The CompStyle values can be calculated similarly to the NetworkLibs bitmask (discussed in the preceding Server-side Network Libraries section). For example, the default of 196609 (0x30001 in hexadecimal) is the result of combining the Ignore case, Ignore Kana, and Ignore width options:

           1   (Ignore case)
    +  65536   (Ignore Kana)
    + 131072   (Ignore width)
    ---------
      196609
  
				

Licensing

    [License]
    License Mode=PERSERVER
    License Limit=15

				

The License Mode entry has the following possible values: "PERSERVER", and "PERSEAT". The License Limit entry specifies the number of per server SQL Client Access Licenses (CALs) that have been purchased. The License Limit entry does not exist when License Mode is PERSEAT.

The [License] section does not apply to MSDE or SQL Server Desktop edition installs; client connections to SQL Server Desktop edition or MSDE do not require SQL CALs. However, the computer that SQL Server Desktop is installed on must be covered by a per seat SQL CAL. Similarly, a computer with MSDE installed requires a per seat SQL CAL if MSDE will be interacting with a SQL Server. For more information about SQL Server Desktop edition licensing, click the following article number to view the article in the Microsoft Knowledge Base:

Registered user name

    [SdRegisterUser-0]
    szName=User Name
    szCompany=Company Name

				

The installation of MSDE or SQL Server can be customized with the name of the registered user and company name. Modify szName to change the user's name, and szCompany to include the company.

Service startup accounts

    [DlgServices-0]
    Local-Domain=61680
    AutoStart=255
    SQLDomain=MyDomainName
    SQLDomainAcct=MyDomainUser
    SQLDomainPwd=....
    AgtDomain=MyDomainName
    AgtDomainAcct=MyDomainUser
    AgtDomainPwd=....

				

The [DlgServices-0] section defines the properties of the accounts under which the MSSQLServer and SQLServerAgent services run. The Local-Domain entry is a bitmap that specifies whether each of these accounts is a Windows NT domain account or is the special LocalSystem account. For information on when a domain account should be used instead of the local system account, see the SQL Server Books Online articles "Creating SQL Server Services User Accounts" and "SQLServerAgent Service Startup Account". On Windows 95 or Windows 98, the services must be installed to use the LocalSystem account; these operating systems do not provide a service control manager, so both services run under the security context of the current interactive user. The options for the Local-Domain entry are:

Option	Value (Hex)	Value (Decimal)
MSSQLServer uses LocalSystem	0x000F	15
MSSQLServer uses domain account	0x00F0	240
SQLServerAgent uses LocalSystem	0x0F00	3840
SQLServerAgent uses domain account	0xF000	61440

In the preceding example section [DlgServices-0], Local-Domain is 61680, which indicates that both the MSSQLServer and SQLServerAgent will be started under a domain account (61440 + 240 = 61680).

The AutoStart entry is a bitmask that controls whether each service is configured to autostart when the computer starts (on Windows NT) or when a user logs on (on either Windows 95 or Windows 98). In the previous example, both MSSQLServer and SQLServerAgent are configured to AutoStart (240 + 15 = 255):

Option	Value (Hex)	Value (Decimal)
MSSQLServer autostarts	0x000F	15
SQLServerAgent autostarts	0x00F0	240

Note that neither SQLServerAgent nor MSSQLServer can be configured to AutoStart by SQL setup on Windows 95 or Windows 98 since this option is not exposed through the graphical setup interface on these platforms. For more information about how to start the MSSQLServer service or the SQLServerAgent service on Windows 95 or on Windows 98, click the following article number to view the article in the Microsoft Knowledge Base: On Windows NT, you can autostart SQLServerAgent only if you autostart MSSQLServer as well, because the SQLServerAgent service is dependent on MSSQLServer. The remaining entries in this section (SQLDomain, SQLDomainAcct, SQLDomainPwd,and so forth) specify which Windows NT account(s) will be used if the Local-Domain entry indicates that one or both services will use a Windows NT domain account instead of the LocalSystem account. These entries are not present when LocalSystem is being used. The password entries are encrypted, and can only be obtained by running SQL Server setup interactively to generate a new .iss file. If this is not possible or practical in your circumstances, you must install MSSQLServer and SQLServerAgent to run under the LocalSystem account (Local-Domain=3855).

Windows NT users can later change the service startup accounts, if desired (see the SQL Server Books Online articles "How to set up a SQL Server service to log on under a different user account (Windows NT)" and "Creating SQL Server Services User Accounts"). On Windows NT, the utility Scm.exe (in the MSSQL7\BINN directory) can be used after installation to change the service startup account from LocalSystem to a domain account, if it is necessary that this be automated. For more information see the Microsoft Knowledge Base article referenced previously for details.