Setup Initialization File Details
When creating a customized setup initialization file, the Service Accounts and Network Libraries dialog boxes have additional options used for an unattended installation.
Services Accounts Dialog Box
To customize settings for each service, you can calculate values for the Local-Domain and AutoStart entries.
Local-Domain
If you want the SQL Server and SQL Server Agent services to use different logon accounts, you can calculate the value to enter for Local-Domain. The Local-Domain value is a bitwise logical OR combination of the values shown in the following table. For more information, see | (Bitwise OR).
| Service | Account to use | Hexadecimal value |
|---|---|---|
| SQL Server | Local System account | x0000000F |
| SQL Server Agent | Local System account | 0x00000F00 |
| SQL Server | Domain User account | 0x000000F0 |
| SQL Server Agent | Domain User account | 0x0000F000 |
Additional entries must be added to your setup initialization file if the Domain User account is used for either service.
When SQL Server service is using a domain account, Setup looks for values for:
- SQLDomain = <domain name>
- SQLDomainAcct = <domain user account>
- SQLDomainPwd = <domain password: an encrypted password available only using setup screens>
When SQL Server Agent service is using a domain account, Setup looks for values for:
- AgtDomain = <domain name>
- AgtDomainAcct = <domain user account>
- AgtDomainPwd = <domain password: an encrypted password available only using setup screens>
AutoStart
The value for the AutoStart option is a bitwise logical OR combination using the following hexadecimal values:
Autostart SQL Server = 0x0000000F
Autostart SQL Server Agent = 0x000000F0
A value of zero (0) for either service indicates no AutoStart; manual startup is required.
Network Libraries Dialog Box
To customize network library settings, you can calculate a value for the NetworkLibs entry in the Network Libraries dialog box. The value for NetworkLibs is a bitwise logical OR combination of the values shown in the following table. When a network library is set, additional information must be entered in the setup initialization file, as shown in the third column.
| Network Library to use when connecting to the server | Hexadecimal value to use in Bitwise OR operation | Additional information that Setup looks for |
|---|---|---|
| Named Pipes | 0xF | NMPPipeName = <named pipe name> |
| TCP/IP Sockets | 0xF0 | TCPPort = <port number>
TCPPrxy = <Remote Winsock proxy address> |
| NW Link | 0xF000 | NWLinkObj = <Novell Bindary service name> |
| Apple Talk | 0xF0000 | ApplObj = <Apple Talk service object> |
| Banyan VINES | 0xF00000 | BanyanObj = <StreetTalk service name> |