How do I download and install the Microsoft SQL Server Native Client?

HIFIS uses Microsoft SQL Server, which means that any computer that will be connecting directly to the server via Crystal Reports requires a SQL Server Native Client to assist with the connection.

You can download Native Client 11 from https://www.microsoft.com/en-us/download/details.aspx?id=50402 . If that doesn’t work, you can also find it as part of the Microsoft SQL Server 2012 Feature Pack. Native Client 10.0 also works, which is part of the Microsoft SQL Server 2008 Feature Pack.

Once the file has downloaded, follow the prompts to install the driver.

Verify that SQL Server Native Client is installed correctly 

To verify the installation of SQL Server Native Client, on your computer, open the Control Panel and search for Windows Tools. (Usually, this is found at Control Panel → System and Security → Windows Tools.) Look for ODBC Data Sources.

Click on ODBC Data Sources for either 32-bit or 64-bit, depending on your computer's processor. Next, click on the Drivers tab. If correctly installed, SQL Server Native Client should appear under the list of drivers. You can click Cancel once you have confirmed the presence of the SQL Server Native Client 11.0 (or 10.0).