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.