In server mode, you must start the SQL engine server before connecting.
Note: The Configuration Manager is currently supported only on Windows platforms. To configure the SQL engine on UNIX/Linux platforms, see "Configuring the SQL engine server using Java options."

The following sections describe how to configure, start, and stop the SQL engine server using the Configuration Manager.

  1. Open your data source using the Configuration Manager; then, select the SQL Engine tab.
  2. Set the SQL Engine Mode (SQLEngineMode) connection option to one of the following values:
    • 0 - Auto: The SQL engine attempts to run in server mode first, but will failover to direct mode if server mode is unavailable.
    • 1 - Server: The SQL engine runs exclusively in server mode.
    Note: By default, SQL Engine Mode is set to 1 - Server for Windows and 2 - Direct for Linux.
    The fields associated with server mode will become editable, and the Start button appears.
  3. Provide values for the following options:

    • Server Port Number: Specifies a valid port on which the SQL engine listens for requests from the driver. The default value depends on your platform:

      32-bit: 19948

      64-bit: 19947

    • JVM Classpath: Specifies the CLASSPATH for the JVM used by the driver. See "JVM Classpath" for details. The default depends on your platform:

      Windows: {.;c:\install_dir\java\lib\snowflake.jar}

      Linux: {.:/home/user1/install_dir/java/lib/snowflake.jar}

    • JVM Arguments: A string that contains the arguments that are passed to the JVM that the driver is starting. The location of the JVM must be specified on your PATH. See "JVM Arguments" for details. The default value is:

      -Xmx1024m

    • JVM Path: Specifies fully qualified path to the JVM executable that you want to use to run the SQL engine server. The path must not contain double quotation marks.

  4. Optionally, if connecting through a proxy server, provide values for the following options:
    • Server Proxy Host: Specifies the host name of the proxy server used by the SQL engine. The value specified can be a host name, a fully qualified domain name, or an IPv4 or IPv6 address.
    • Server Proxy Port: Specifies the port needed to connect to the proxy server used by the SQL engine.
    • Server Proxy User: Specifies the user name needed to connect to the proxy server used by the SQL engine.
    • Server Proxy Password: Specifies the password needed to connect to the proxy server used by the SQL engine.
    Note: After the initial configuration, in order for changes to the required and optional connection option values to take effect, you must restart the SQL engine server.
  5. Click Save to save your changes
  6. Click Start to run the SQL engine service. A message is displayed that indicates whether the SQL engine was able to successfully run.