Configuring the Response Assessment module settings

You can modify the SQL Server settings that are used to connect to the Response Assessment module (RAM) database.

To configure the RAM settings

  1. Go to Settings > General.

  2. In the General view, on the left panel, click Application Configuration > RAM DB Configuration.

  3. On the right panel, provide the following information:

    Enable RAM database configuration

    Select the check box to configure the SQL server settings that are used to connect to the Response Assessment module (RAM) database.

    SQL Server

    Type the computer name that hosts the SQL Server.

    Database Name

    The default database name can be changed, if needed.

    Instance name

    Type the SQL Server instance name.

    The default SQL Server instance name appears in the text box.

    Port number

    Type the port number of the SQL Server instance.

    If the port is enabled, the SQL Server default instance listens on TCP port 1433.

    Use SSL

    Check this option if you want SQL Server to use SSL to encrypt network transmissions independent of the network protocol.

    Use Windows NT Integrated Security

    Select this option if you connect to the SQL Server instance using Windows Authentication.

    Use a SQL user name and password

    Select this option if you connect to the SQL Server instance using SQL Server Authentication.

    You must specify the authentication details of the user in the respective text boxes.

    You cannot specify the following special characters for the User name and the Password fields:

    • Semi colon (;)

    • Double quotes (")