Many times, there are some strange requests which I heard from my clients. I try to help my client with the answers and write a blog so that others can find the answers easily. Let us learn about SQL Server Native Client today.
Question: How to download SQL Server Native Client?
Answer: I always search for “SQL Server Feature Pack” on the search engine. The SQL Server Feature Pack is a collection of stand-alone packages that provide additional features to SQL Server. The SQL Server Native Client Drivers package is a subset of the Feature Pack.
There are also feature packs for the service pack, so always search and choose the latest.
How to download SQL Server Native Client?
As I mentioned above, SQL Server Native Client is the subset of the feature pack. One we open the link for downloading feature pack, click on “Download” button and we get various packages to download. We need to choose sqlncli.msi as shown below (for 64 bit)
There is another one for 32 bit which is shown under “x86”.
Hope this would help someone who is not able to get proper guidance from other sites/forums. Let me know what you think of this blog post.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Hi Pinal, Very useful indeed. Is there a way to do something at T-SQL level Or do we need to install the patch files.
If yes please let me know.