Install SNAC Update
| Previous Install SQL Cumulative Update | Manual Install | Install SQL Books Online Update Next |
|---|
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 | sqlncli_CUy_X86.msi | sqlncliCU4X86.msi |
| x64 SNAC download | sqlncli.msi | sqlncli_CUy_X64.msi | sqlncliCU4X64.msi |
Automated installation of SQL Native Client is performed by Process Id 3BB and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2017 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2016 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2014 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2012 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2008R2 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2008 | /SetupSPCUSNAC: | Yes | Yes | Yes |
| SQL2005 | /SetupSPCUSNAC: | 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.
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.
-
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
-
The SNAC Setup window is displayed. Click Yes to continue
-
The Welcome window is displayed. Click Next to continue
-
Accept the License Agreement. Click Next to continue
-
Enter your Registration Information. Click Next to Continue
-
The Feature Selection window is displayed. All features should be selected. Click Next to continue
-
The Ready to Install window is displayed. Click Install to continue
-
The SNAC install is complete. Click Finish to exit
Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements
| Previous Install SQL Cumulative Update | Top | Install SQL Books Online Update Next |
|---|