Microsoft Native client is required on each computer that will run POSitive software (SQL Server Native Client is automatically installed on the server where SQL Server is installed). It helps facilitate communication between POSitive software and its SQL Server database. Previous versions of our software would not operate without the 2005 version of SQL Server Native Client. However, with security updates implemented in Windows operating systems in 2018, newer releases of POSitive software operate more efficiently with the latest version of SQL Server Native Client. This guide will give you the steps to uninstall SQL Server Native Client (2005) and install SQL Server 2012 Native Client in Windows 10 based operating systems.
--- PROJECT SUMMARY---
------------------------------
STEP 1: Uninstall SQL Server Native Client (2005)
------------------------------
Uninstall SQL Server Native Client (2005) from all computers, including the server where SQL Server is installed:
1. Click the Windows Start button and click the gear (settings) icon
2. Type "remove" in the 'Find a setting' search box
3. Click 'Add or remove programs' from the search results
4. Under 'Apps & features', type "native" in the 'Search this list' search box
5. Click 'Microsoft SQL Server Native Client' (Do NOT select 'Microsoft SQL Server 2012 Native Client', you WANT this installed) from the search results and click 'Uninstall'
Back to top
------------------------------
STEP 2: Install SQL Server 2012 Native Client on all computers
------------------------------
Install SQL Server 2012 Native Client on all computers
1. Right-click on the shortcut to open POSitive and choose Properties
2. Click 'Open File Location'. This will open a Windows File Explorer window into the POSitive installation folder.
3. Navigate to, and open the 'Utility' folder, then open the 'MSSQL' folder
4. Double-click 'sqlncli_x64.msi' to install (You may have 'Hide extensions for known file types' turned on if you cannot find the '.exe' part of the filename. To turn it off, open a new 'File Explorer' windows and click View or Tools and select (Folder) Options. Click the View tab and uncheck the option 'Hide extensions for known file types.' Click OK to close. Close the newly opened File Explorer window). If you get an error, then run 'sqlnci.msi' instead.
Back to top
Updated 10/08/2018
