How To Do SQL Server Native Client Installation?

You can install Microsoft SQL Server Native client software on the Rendition Engine server to enable communication with a Microsoft SQL Server database when using a non-default port.

The following procedure describes the minimum options for installing the Microsoft SQL Server Native client. Before you begin, see the Microsoft SQL Server Native client Installation Guide that was provided with the client software for complete instructions and pre-installation requirements.

To install the Microsoft SQL Server Native client:

Log on with the appropriate local account to install and launch the Microsoft SQL Server Client.

From the SQL Server Setup media, install the following Shared Features:
Client Tools Connectivity
Management Tools - Basic

In SQL Server Configuration Manager, create a new alias in SQL Native Client Configuration (32-bit).
Tip: In the Server box, type the name or IP address of the server. For a named instance, append the instance name to the alias.
Use SQL Server Management Studio or the sqlcmd utility to verify the connection to the new alias.