Configure SQL Network Protocols
| Previous Configure COM Security | Manual Configuration | Configure Service Account Names Next |
|---|
FineBuild can configure port usage for SQL Server Database Engine and for Analysis Services.
Port usage for SQL Server database engine is configured at this point, while port usage for Analysis Services is configured at Configure AS Instance General Properties.
SQL Network Ports configuration is not performed for a Cluster Install, because a Cluster does not need a named port.
SQL Network Protocol configuration helps to reduce the host server surface area. If you setup Security Compliance then SQL Network Protocol configuration will always be implemented.
Automated silent SQL Network Protocols configuration relates to Process Id 5AB and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2017 | /SetupNetworkt: | Yes | Yes | N/A |
| SQL2016 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2014 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2012 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2008R2 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2008 | /SetupNetwork: | Yes | Yes | N/A |
| SQL2005 | /SetupNetwork: | Yes | Yes | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /ConfigNetwork: can also be used.
FineBuild also uses the following parameters to help configure SQL Network Protocols:
| Parameter | Default | Description |
|---|---|---|
| /TCPPort: | 1433 | TCP port to be used for SQL Server database engine |
The following steps show what you would have to do for manual SQL Network Protocols configuration. FineBuild does all of this work for you automatically.
-
Start SQL Server Configuration Manager
Locate the Protocols for MSSQLSERVER and ensure the following protocols are enabled. All other protocols should be set to Disabled.
Protocol State Named Pipes Enabled Shared Memory Enabled TCI/IP Enabled 
-
Click OK to the following Warning message
-
Right-click on TCP/IP, select Properties
Select the IP Addresses tab and specify the values below. Values should be specified for all IP Addresses except for 127.0.0.1 and ::1
It is recommended that a site-specific port is used for the default instance. A site-specific port must be used for a named instance
Port Type Value TCP Dynamic Ports Blank TCP Port /TCPPort: value -
Click OK to save the values
Copyright FineBuild Team © 2012 - 2020. License and Acknowledgements
| Previous Configure COM Security | Top | Configure Service Account Names Next |
|---|