Setup Initialization File Details

Installing SQL Server

Installing SQL Server

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>

See Also

Services Accounts

Network Libraries

Performing an Unattended Installation