How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed
On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (SQLNCLI10.1).
I downloaded a native client sqlncli.msi but received the message 'Installation of SQL Server 2008 Native Client failed because a higher version already exists on the machine...' Is there another download to install or is there a way to copy certain files from a server already containing the desired Native Client and then performing the registration without doing a complete reinstallation?
Any help would be greatly appreciated.
Solution 1:
Have a look at this post which tells of a similar situation. The author used the SQL Native Client .msi from the \x64\Setup\x64 folder
of the SQL 2008 distribution media. Maybe that will do it.
If not, you should be ok to uninstall the SQL Native Client 11, install v10 and then reinstall 11.
Solution 2:
If you can't access the distribution media, the installer for "SQL Server Native Client version 10.0" can be downloaded from the Microsoft SQL Server 2008 R2 Feature Pack. Expand the "Install Instructions" and search for "2008 R2 Native Client".