Install SNAC update

FineBuild can install the latest SQL Native Client (SNAC) update as part of the SQL install process.
If you do not want to include SQL Native Client update in your FineBuild install, then do not download it.

SQL Native Client is written by Microsoft. It was chosen to be included in FineBuild so that the latest version of the SQL Native Client is available to people using SQL Server.

It is recommended that the SQL Server Native Client (SNAC) update for a given CU is always applied in addition to the CU update. This is because Microsoft sometimes package updates to SNAC in the main CU file, and sometimes the SNAC updates are excluded from
the CU file.

The SNAC Update must be placed in the same folder as the Service Pack (eg \Service Packs\SP1).

The update for SNAC is normally called sqlncli.msi. This must be renamed at download time as shown below, with
CUy being replaced by the CU number:

Component

Original File Name

File Name Model

File Name Example

x86 SNAC download

sqlncli.msi

sqlncliCUyX86.msi

sqlncliCU4X86.msi

x64 SNAC download

sqlncli.msi

sqlncliCUyX64.msi

sqlncliCU4X64.msi

FineBuild SQL SNAC update

Automated installation of SQL Native Client is performed by Process Id 3BB and is controlled by the parameters below:

Install Parameter

Build

SQL2005

SQL2008

SQL2008 R2

SQL2012

SQL2014

SetupSPCUSNAC

FULL

Yes

Yes

Yes

Yes

Yes

SetupSPCUSNAC

WORKSTATION

Yes

Yes

Yes

Yes

Yes

SetupSPCUSNAC

CLIENT

Yes

Yes

Yes

Yes

Yes

For compatibility with older versions of SQL FineBuild, the parameter /InstSPCUSNAC: can also be used.

The FineBuild SQL SNAC update includes the following items:

Install the latest version of SQL SNAC

FineBuild will automatically search for a file in the Service Packs folder with a name of sqlncliXXXYYY.msi where XXX is the CU (e.g. CU4) and YYY is the processor architecture (e.g. X86), giving for example a file name of
sqlncliCU4X86.msi.

Manual SQL SNAC update

The following steps show what you would have to do to install the SQL SNAC update manually. FineBuild does all of this work for you automatically.

1) Navigate to the Service Packs folder, and double-click the required SNAC install file.

E.G. To install CU4 SNAC for 32-bit servers, use the following files: sqlncliCU4X86.msi

2) The SNAC Setup window is displayed. Click Yes to continue.

3) The Welcome window is displayed. Click Next to continue.

4) Accept the License Agreement. Click Next to continue.

5) Enter your Registration Information. Click Next to Continue.

6) The Feature Selection window is displayed. All features should be selected. Click
Next to continue.

7) The Ready to Install window is displayed. Click Install to continue.