Configuring Named Instance for Microsoft® SQL Server Prior to Installing Transact 4.5.0.0

Introduction

Prior to installing Transact 4.5.0.0, it is necessary to set up the named instance, and then configure related settings.
This article describes how to set up named instances on Microsoft® Server.

  1. First, follow the steps in this document to create the named instance:
    https://wiki.ephesoft.com/kb0021050-how-to-install-ephesoft-with-mssql-named-instance-through-installer
    Note: The wiki article above states that you should use the server name of <<SERVERNAME>>\<<NAMED_INSTANCE>>, when defining the server name during installation. The system will prompt you to provide the remote MS SQL Server details during this step. Only previous versions of Transact require the server name, with this convention. Server name definition does not apply to Transact 4.5.0.0.
    In Transact 4.5.0.0, there are two required parameters:

    • Instance Name (optional)
    • Listener Port (required)
  2. Once you have created the named instance, using the procedure above, and before installing Transact 4.5.0.0, complete the steps in this document, which are as follows:
    1. Find and Set up the Listener Port
    2. Enable the Named Pipes
    3. Ensure the SQL Server Browser is Running
    4. Use the Listener Port During the Transact 4.5.0.0 Installation

Find and Set up the Listener Port

Perform these steps to set up the listener port.

  1. One way to find the listener port is through the Sql Server Configuration Manager.
    For SQL Server 2016, it may be located through Start > and search for “SQLServerManager13.msc“.
  2. Expand the Sql Server Network Configuration.
  3. Click Protocols for your instance.
  4. Right click on the TCP/IP in the right pane and select Properties.
  5. On the IP Addresses tab, scroll to the bottom and find the TCP Port for IPALL.

    Screen Clipping
    Sql Server Configuration Manager — TCP Port

  6. Type this port number into all the TCP Port lines cited above.
  7. Remove the “0” from the TCP Dynamic Ports.

Enable the Named Pipes

    1. In the Sql Server Configuration Manager, ensure that named pipes are enabled.
      The following snapshot illustrates this configuration:
      Screen Clipping

Sql Server Configuration Manager — Named Pipes Enabled

Ensure the SQL Server Browser is Running

  1. In the Sql Server Configuration Manager, ensure that the SQL Server Browser is running.
    The following snapshot illustrates this configuration and state:
    Screen Clipping

Sql Server Configuration Manager — SQL Server Browser is Running

Use the Listener Port During the Transact 4.5.0.0 Installation

  1. When you begin the Transact 4.5.0.0 installation, be sure to use the Listener Port that you defined with previous steps.
    The following snapshot illustrates this port.

Was this article helpful to you?

Rene Hernandez