Previous Install SQL Cumulative Update Manual Install Install SQL Books Online Update Next

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
SNACExplorer.png
2) The SNAC Setup window is displayed. Click Yes to continue.
SNACUpgrade.png
3) The Welcome window is displayed. Click Next to continue.
Welcome.png
4) Accept the License Agreement. Click Next to continue.
License.png
5) Enter your Registration Information. Click Next to Continue.
Registration.png
6) The Feature Selection window is displayed. All features should be selected. Click Next to continue.
Features.png
7) The Ready to Install window is displayed. Click Install to continue.
Ready.png
8) The SNAC install is complete. Click Finish to exit.
Complete.png
Copyright © 2013 Edward Vassie. License and Acknowledgements
Previous Install SQL Cumulative Update Top Install SQL Books Online Update Next

Last edited Jun 20, 2013 at 2:05 PM by EdVassie, version 3

Comments

No comments yet.