Zero Touch Installation Deployment Feature Team Guide

Appendix M: Locating Regional SQL Servers

Published: August 27, 2005

There may be some situations where it would be useful to locate SQL servers that are local to the client computers. You can use CustomSettings.ini file to determine the regional SQL server that is optimal for the client computer.

You can use the DefaultGateway section to specify the SQL server based on the default gateway of the client computer. You can use other variables (such as MAC address or distribution point) as well.

To use the DefaultGateway section to select the regional SQL server:

1.

Modify the CustomSettings.ini file to include the DefaultGateway literal value in the Priority line (as illustrated in Listing 102).

[Settings]
...
Priority=MacAddress, DefaultGateway, Default
...

Listing 102. Excerpt from Customsettings.ini that illustrates the database section

The DefaultGateway value causes the ZTI rules engine to look for a section named [DefaultGateway]. The [DefaultGateway] section contains pointers to other sections that have the actual application package settings.

2.

Create [DefaultGateway] section (as illustrated in Listing 103).

[DefaultGateway]
192.168.0.1=HOUSTON
11.1.1.11=REDMOND
172.28.20.1=REDMOND
...

Listing 103. Excerpt from Customsettings.ini that illustrates [DefaultGateway] section

As illustrated in Listing 103, in the “REDMOND” section there are two different default gateway values (11.1.1.11 and 172.28.20.1). In the “HOUSTON” section there is only one default gateway value (192.168.0.1). You can use this method to deploy location-specific packages to REDMOND and HOUSTON.

3.

Create a section for each of the default gateways specified in the [DefaultGateway] section (as illustrated in Listing 104).

[REDMOND]
SQLServer=RED-SQL-01
 
[HOUSTON]
SQLServer=HOU-SQL-01

Listing 104. Excerpt from Customsettings.ini that illustrates SQL server selection based on the default gateway

Based on configuration settings in Listing 104, different SQL servers are used for client computers in REDMOND in comparison to HOUSTON.


Top of pageTop of pagePrevious24 of 25Next
**
In This Article
**