Installation Notes

Preparing to Install DataGate® for SQL Server

Meet System Requirements

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

The system requirements include:

  • Windows Server 2012 R2, 2014, or 2014 R2; Windows 7, Windows 8 Pro, or Windows 10 Pro
  • 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 2012 R2 or later be installed, configured and running. Note that Microsoft SQL Server 2005-2012 are 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:

  • Ensure that Microsoft for SQL Server has been installed, or install Microsoft for SQL Server. Refer to Microsoft SQL Server documentation for further information.
  • Be sure the computer meets the system requirements for DataGate® 16.0 for SQL Server. For more information, see System Requirements.
  • 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 16.0 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.

To Install from ASNA Developer Network (DevNet)

  1. Go to
  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 16.0 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.

Silent Installation

To set up a silent installation, you must download the Mobile RPG package or otherwise have it available on your Windows machine or network.

Then, in a command prompt, enter the path to the folder where the AVR installation package is saved followed by Setup.exe, using the following syntax:

ASNA.Setup.exe [options] 

The following options are required for silent installation:

-s       Run the installation with no user interface.
-a       Accept the ASNA Software License Agreement (required to run in silent mode)

Other available installation options are:

-?       Displays the command line usage dialog. -f       Full: Install all components.
-c       Core: Install required components.
-o       Optional: Install required and optional components.
-h       Help: Install required and help components.
-netfx45 .NET Fx 4.5: Install .NET Framework 4.5 Support if present on machine.
-np      Do not prompt the user to reboot if Reboot is required.

Note: Multiple installation options may be used.

Ex. \"ASNA.Setup.exe -s -a -o -netfx45\" will install the required components, optional components, and .NET 4.5 Support.

To repair an installation from the command line:

-r       Repair the installation.
Will repair all features that are installed and have not previously been upgraded by another product.

To uninstall from the command line:

-u       Uninstall the product.
Will remove all features that are part of the product package, are not permanent (ASNA Services for example is permanent, so will not be uninstalled), and are not shared with other ASNA products that are currently installed on the machine.

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

The DataGate® for SQL Server dialogs (Stored Procedures) display 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.
Additionally, these dialogs allow users to update, repair, or remove the ASNA Stored procedures through the same dialog tree.

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 Install SQL Server Instance(s)

  1. Select the Install Option on the Action Selection dialog
    • Instance Selection:
      • The left (Available Instances) column displays the list of currently running, available, named SQL Server instances on your system. The right (Selected Instances) column contains those instances ASNA's Stored Procedures will be installed on.
      • Select instances then click on the arrow to the right to move them into the Selected Instances column. Alternately, clicking the double-right chevron (>>) will shift all instances into the Selected Column.
      • Click Next when done to move on to the next page
    • Settings
    • QTEMP
      • This section lets users enable the QTEMP database, and specify a name for it (you will be warned if a database with the chosen name already exists).
    • SQL Credentials
      • This section lets users choose whether to access the instance(s) with a trusted connection, and if not, to enter credentials to use.