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 || SQL 2005 || SQL 2008 || SQL 2008 R2 || SQL 2012 |
| SetupSPCUSNAC || FULL || Yes || Yes || Yes || Yes |
| SetupSPCUSNAC || WORKSTATION || Yes || Yes || Yes || Yes |
| SetupSPCUSNAC || CLIENT || 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
3) The Welcome window is displayed. Click Next
4) Accept the License Agreement. Click Next
5) Enter your Registration Information. Click Next
6) The Feature Selection window is displayed. All features should be selected. Click Next
7) The Ready to Install window is displayed. Click Install
8) The SNAC install is complete. Click Finish
Copyright © 2013 Edward Vassie. License and Acknowledgements