DataGate® 16.0 for SQL Server Reference Guide

Installing DataGate® for SQL Server

Preparing to Install DataGate® for SQL Server


Meet System Requirements

To run DataGate® 16.0 for SQL Server and ASNA DataGate® 15.0 you must have certain hardware and software installed on your computer.

The system requirements include:

  • Windows Server 2008 R2, Windows Server 2012, Windows Server 2016, Windows 7, Windows 8 Pro, Windows 10
  • TCP/IP with TCP port 5042 enabled/allowed in firewall
  • You must be signed on with Administrative privileges in order to start the DataGate® Service and to license both products
  • At least 500 MB free disk space

DataGate® 16.0 for SQL Server also requires that either Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2012 (or both) be installed, configured and running. Note that Micorosoft SQL Server 2005 is no longer supported by this or future versions of DataGate® for SQL Server.

Review Installation Options

Before installing ASNA DataGate® 16.0 for SQL Server, consider the following:

  • Verify that the respective Microsoft SQL Server Service for each Instance is started, and that the Auto-start service when OS starts is selected.
  • Review the Installation Instructions for installing DataGate® 16.0 for SQL Server and be prepared to make the appropriate selections when running Setup.
  • Read the Release Notes section in this document, or on the ASNA Developer Network site or DataGate® for SQL Server for the latest on product issues, as well as known fixes, known bugs, etc.

Installing DataGate® 16.0 for SQL Server

DataGate® for SQL Server (DSS) is also installed with the AVR and Windows Deployment installations. However, to install DSS on a system that does not have AVR, you can install from the Developer Network Downloads page.

When installing DataGate® for SQL Server, you should be signed on with Administrative Privileges to start the DataGate® Service. If you are not signed on with Administrative Privileges, a Warning will display – stating that you need to have Administrative privileges to start the DataGate® Service. Therefore, you may want to check with your Network Administrator prior to installing to ensure you have Administrative privileges.

  1. Go to http://devnet.asna.com.
  2. Click on Sign In link on the top right corner and sign in to your DevNet account, or select Create an Account on the left to create a new account.
  3. Once you are signed in, click on the Downloads link at the top.
  4. Scroll down and select the product and version you wish to download.
  5. On the next screen, the list of products in the product suite selected will display for you to select from.
  6. Select the product to install. The Release Notes for that product will display. In the right hand corner "Downloads" window, you will see the list of products available based on your sign in. Select the icon of the product to install. The installation exe will display for you to Run now, or Save to your system and install later.

Enabling SQL Database(s) to be used as QTEMP Library

The DataGate® for SQL Server dialog (Stored Procedures) displays during the installation of DataGate® for SQL Server and when selecting the Stored Procedures option. It allows you to select a SQL Server instance and connect to SQL Server. You can set security information, as well as specify a SQL database to be used as a QTEMP library.

Note that after DSS is installed, you can access this dialog at any time from Start - Programs - ASNA .NET Product Suite - DataGate® 16.0 for SQL Server - ASNA DataGate® 16.0 for SQL Server Stored Procedures.

To Enable SQL Server Instance(s)

  1. Enter or select the following to the SQL Server instance dialog.
    • SQL Server Instance:
      • This option displays the list of currently running and available named SQL Server instances specified on your system for DataGate® setup.
      • Click on the arrow to the right to change or select another SQL Server Instance (if available).
    • Use Trusted Connection:
    • This option allows you to use integrated Login security to connect with SQL Server.
    • If checked (default), DataGate® will use integrated Login security to connect with SQL Server.
    • If unchecked, you will need to enter a valid Login Name and Password to connect.
    • Login Name:
    • This box is disabled if Use Trusted Connection is checked.
    • If enabled, specify a Login Name used to connect to SQL Server.
    • Password:
    • This box is disabled if Use Trusted Connection is checked.
    • If enabled, specify the Password for the Login Name used to connect to SQL Server.
    • QTEMP library support:
    • This option allows you to enable, or specify a SQL database name to be used as the special QTEMP library. By default, this option will be disabled.
    • To enable this support, click on the Enable button to enable the ability for a SQL database name to be used as the special QTEMP library. When the Enable button is selected, the "SQL Database to be used as QTEMP library" option will be enabled, for you to specify a SQL Database to be used as a QTEMP library.
    • To disable this support (if previously enabled), click on the Disable button. The "SQL Database to be used as QTEMP library" option will be disabled and appear 'dimmed'.
    • SQL Database to be used as QTEMP library:
    • This option will only be available if the Enable button has been clicked.
    • Specify the name of a SQL database to be used as the special QTEMP library. The name of the database does not have to be QTEMP, but it will be accessed by DataGate® in response to requests for QTEMP library requests.
    • If the database does not exist, it will be created with default attributes.
    • Install Button:
    • Selecting Install will save the entries to the dialog and continue with the installation.
    • Please note that the Install button will only be enabled when the Enable button is selected.
    • Done Button:
    • Selecting Done indicates you are finished with the dialog, and that you will not specify a SQL Database to be used as a QTEMP library. The DSS installation will continue.
    • However, please note that selecting Done while accessing the Stored Procedures dialog from Start - Programs - ASNA Product Suite - DataGate® 16.0 for SQL Server - ASNA DataGate® 16.0 for SQL Server Stored Procedures will display a dialog stating "DataGate® For SQL Server was cancelled or was unable to install properly will display". Select the OK button to close the dialog box.
    • Help Button:
    • Select Help to display the help topic for additional information.

Also in this section