Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » Relay Server » Relay Server deployment


Deploying the Relay Server components to Microsoft IIS 6.0 on Windows Server 2003

Before running the Relay Server with IIS 6.0, you need to deploy Relay Server files to each computer in the Relay Server farm.


The Relay Server components are installed as part of the SQL Anywhere 12 installation. The install process automatically deploys all the necessary files on the computer that is going to run the Relay Server.

By default, all files are installed to %SQLANY12% and are based on the bitness of the computer:

  • %SQLANY12%\Bin32 and %SQLANY12%\Bin64 are used for DLLs and executables for administration.

  • %SQLANY12%\RelayServer\IIS\Bin32 and %SQLANY12%\RelayServer\IIS\Bin64 are used for Relay Server specific files under the appropriate folder (for example, Admin, Client, Monitor, or Server). The Server folder contains the rshost.exe and rs.config files.

Context and remarks

Interactive quick setup feature

An interactive quick setup feature, rs-setup.bat, is provided as an alternative to this procedure (refer to the readme file for a more detailed description of the quick setup feature). rs-setup.bat is located in the %SQLANY12%/RelayServer/IIS/quicksetup_iis6 directory and performs the following tasks:

  1. Creates a demo application

  2. Generates a quick reference guide

The Relay Server for Windows consists of the following executables:

  • rs_client.dll
  • rs_server.dll
  • rs_monitor.dll
  • rshost.exe
  • dblgen12.dll
  • dbsvc.exe
  • dbfhide.exe
  • dbtool12.dll
  • dblib12.dll
  • dbicu12.dll
  • dbicudt12.dll
  • dbsupport.exe
  • dbghelp.dll

For information about which versions of IIS are supported, see [external link]

Setup scripts for the Relay Server on IIS can be found in the %SQLANY12%\RelayServer\IIS directory.

 Deploy the Relay Server components to Microsoft IIS 6.0 on Windows Server 2003
  1. Create a virtual directory called rs under the Default Web Site in the Microsoft IIS Manager for use by the Relay Server. The physical location of the virtual directory is %SQLANY12%\RelayServer\IIS\BinXX where XX is either 32 or 64 depending on the bitness of your IIS server.

  2. Create the Relay Server configuration file rs.config using the following guidelines:

    • The file should have four sections:

      • Options section
      • Relay server section
      • Backend farm section
      • Backend server section
    • Each section starts with a section tag, made by enclosing a keyword that identifies the section name in square brackets.

    • Add the appropriate properties to each section. A property is defined by specifying the property name on the left side of an equal sign and its value on the right side of the equal sign. For example, propertyname = value.

    • The configuration file should contain only 7-bit ASCII characters.

  3. Create an application pool:

    1. Start Microsoft IIS Manager Console.

    2. Right-click Application Pools and create a new application pool, for example RS_POOL.

    3. Edit the properties for the application pool you created.

      1. Click the Recycling tab and turn off all the recycling options.

      2. Click the Performance tab and do the following:

        1. Turn off Shutdown Worker Processes After Being Idle.

        2. Set the number of worker processes to the total number of processing cores. You can further adjust this number depending on your usage and performance preferences. For more information, see the Microsoft IIS performance notes about Web garden size.

  4. Set the Connection timeout property of the Default Web Site to a minimum of 60 seconds. By default this value should be 120 seconds, which is sufficient.

  5. Edit the properties of rs and enable the Relay Server web extensions using the IIS Manager Console:

    1. Click the Directory tab and do the following:

      1. Set execute permissions to Scripts And Executables.

      2. Click Create under Application Settings. Select the application pool you created in step 4 as the associated application pool.

    2. Click the Directory Security tab and do the following:

      1. Click Edit in Authentication and Access Control.

      2. Enable anonymous access and fill in the user name and password for an account belonging to the Administrators group.

        Alternatively, you may leave the setting as the built-in user IUSR_%computername% and execute the following command to grant permission to access the Microsoft IIS metabase.

        C:\Windows\Microsoft.Net\Framework\<Version>\aspnet_regiis.exe -ga IUSR_%computername%
    3. Under Web Server Extensions in the Microsoft IIS manager, add rs_server.dll, rs_client.dll, and rs_monitor.dll as a new Web service extension. The extension name should be ISAPI and the DLLs need to have the extension status set to Allowed.

  6. Deploy the Relay Server configuration file by creating a Relay Server configuration file and copying it to the %SQLANY12%\RelayServer\IIS\BinXX\server directory.

  7. Ensure optimum performance by reviewing the performance tips.

  8. Start the Relay Server State Manager as a service using a command line similar to the following:

    dbsvc -as -s auto -t rshost -w RelayServer "%SQLANY12%\RelayServer\IIS\BinXX\Server\rshost.exe" -q -qc -f "%SQLANY12%\RelayServer\IIS\BinXX\Server\rs.config" -o "c:\temp\ias_relay_server.log"

    It is recommended that you start the State Manager as a service. However, it can also be started automatically by the Relay Server.

  9. Update the Relay Server configuration for Microsoft IIS 6.0 on Windows:

    1. For each computer that belongs to the Relay Server farm you are updating, copy the updated configuration file to the %SQLANY12%\RelayServer\IIS\BinXX\Server directory under the Relay Server web site home directory. The configuration file must be called rs.config if auto start is used.

    2. From the %SQLANY12%\RelayServer\IIS\BinXX\Server directory, run the following command line to apply the configuration update:

      rshost -u -f rs.config
    3. Repeat the previous steps for each computer in the Relay Server farm that is being updated.


    After configuring the Relay Server with IIS, it is recommended that you restart the IIS server or the computer.


The Relay Server configuration file is deployed to all computers in the Relay Server farm.



 See also

Performance tips