locked
sql server native client 2016 RRS feed

  • Question

  • i am trying to install sql server native client

    i am expecting to see 130 folder but i cant there are ither 140, 110 folders under program files/microsoft sql server/


    k

    Thursday, August 16, 2018 3:26 PM

Answers

  • Hi,

    There is no sql server native client 2016.

    Check below URL

    https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-2017


    Mark it as an answer if it helped you out. Regards Rahul Dagar

    • Proposed as answer by Olaf HelperMVP Friday, August 17, 2018 5:13 AM
    • Marked as answer by Olaf HelperMVP Saturday, December 29, 2018 7:27 AM
    Thursday, August 16, 2018 3:36 PM
  • Hi,

    As Rahul_Dagar said, there's no SQL Server 2016 native client. The latest version is SQL Server 2012 Native Client

    Also, you can see in above link: Note that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client. The SQL Server 2012 Native Client (v11, e.g. sqlncli11.dll), can continue to be utilized by SQL Server 2014 and later versions. 

    Then 130 folder is used to store common files used by all SQL Server 2016 instances on a single computer. Which means, if you haven't install SQL Server 2016. There should be shared folder.

    For more details, please refer: File Locations for Default and Named Instances of SQL Server 

    Thanks,
    Xi Jin.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 17, 2018 2:24 AM
  • as on this server only sql native client is required


    You can download SQL Native Client from Microsoft® SQL Server® 2012 SP3 Feature Pack  => sqlncli.msi

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, August 17, 2018 5:16 AM
  • There is no need to install SQL 2016

    as on this server only sql native client is required.


    k

    Go ahead and just install shared components that would install SQL Server 2016 native client. Because that is inbuilt in sql server 2016 installation and does not comes as separate component. BTW what is need of SQL Server 2016 native client ?

    Plus from doc.microsoft did you checked 

    In addition to installing SQL Server Native Client as part of the SQL Server installation, there is also a redistributable installation program named sqlncli.msi, which can be found on the SQL Server installation disk in the following location: %CD%\Setup\.

    You can distribute SQL Server Native Client through sqlncli.msi. You might have to install SQL Server Native Client when you deploy an application. One way to install multiple packages in what seems to the user to be a single installation is to use chainer and bootstrapper technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 and Adding Custom Prerequisites.

    The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client. If your application targets a platform other than the one it was developed on, you can download versions of sqlncli.msi for x64, Itanium, and x86 from the Microsoft Download Center.

    When you invoke sqlncli.msi, only the client components are installed by default. The client components are are files that support running an application that was developed using SQL Server Native Client. To also install the SDK components, specify ADDLOCAL=All on the command line. For example:

    msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}



    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP



    Friday, August 17, 2018 6:47 AM

All replies

  • Hi,

    There is no sql server native client 2016.

    Check below URL

    https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-2017


    Mark it as an answer if it helped you out. Regards Rahul Dagar

    • Proposed as answer by Olaf HelperMVP Friday, August 17, 2018 5:13 AM
    • Marked as answer by Olaf HelperMVP Saturday, December 29, 2018 7:27 AM
    Thursday, August 16, 2018 3:36 PM
  • there is only shared folder under 130 folder directory.

    kindly advise


    k

    Thursday, August 16, 2018 4:03 PM
  • i am trying to install sql server native client

    i am expecting to see 130 folder but i cant there are ither 140, 110 folders under program files/microsoft sql server/


    k

    When you install SQL Server 2016 native client gets installed automatically. Have you installed SQL Server 2016, which version have you installed ?

    If you are seeing just shared folder it means you have not installed SQL Server 2016 or have you ?


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP



    Thursday, August 16, 2018 4:25 PM
  • There is no need to install SQL 2016

    as on this server only sql native client is required.


    k

    Thursday, August 16, 2018 6:49 PM
  • Hi,

    As Rahul_Dagar said, there's no SQL Server 2016 native client. The latest version is SQL Server 2012 Native Client

    Also, you can see in above link: Note that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client. The SQL Server 2012 Native Client (v11, e.g. sqlncli11.dll), can continue to be utilized by SQL Server 2014 and later versions. 

    Then 130 folder is used to store common files used by all SQL Server 2016 instances on a single computer. Which means, if you haven't install SQL Server 2016. There should be shared folder.

    For more details, please refer: File Locations for Default and Named Instances of SQL Server 

    Thanks,
    Xi Jin.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 17, 2018 2:24 AM
  • as on this server only sql native client is required


    You can download SQL Native Client from Microsoft® SQL Server® 2012 SP3 Feature Pack  => sqlncli.msi

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, August 17, 2018 5:16 AM
  • There is no need to install SQL 2016

    as on this server only sql native client is required.


    k

    Go ahead and just install shared components that would install SQL Server 2016 native client. Because that is inbuilt in sql server 2016 installation and does not comes as separate component. BTW what is need of SQL Server 2016 native client ?

    Plus from doc.microsoft did you checked 

    In addition to installing SQL Server Native Client as part of the SQL Server installation, there is also a redistributable installation program named sqlncli.msi, which can be found on the SQL Server installation disk in the following location: %CD%\Setup\.

    You can distribute SQL Server Native Client through sqlncli.msi. You might have to install SQL Server Native Client when you deploy an application. One way to install multiple packages in what seems to the user to be a single installation is to use chainer and bootstrapper technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 and Adding Custom Prerequisites.

    The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client. If your application targets a platform other than the one it was developed on, you can download versions of sqlncli.msi for x64, Itanium, and x86 from the Microsoft Download Center.

    When you invoke sqlncli.msi, only the client components are installed by default. The client components are are files that support running an application that was developed using SQL Server Native Client. To also install the SDK components, specify ADDLOCAL=All on the command line. For example:

    msiexec /i sqlncli.msi ADDLOCAL=ALL APPGUID={0CC618CE-F36A-415E-84B4-FB1BFF6967E1}



    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP



    Friday, August 17, 2018 6:47 AM