Configure a Microsoft SQL Server data source - Remote Matching Service - 23.1 - 23.1 - Brainware - external - Brainware/Remote-Matching-Service/23.1/Remote-Matching-Service-User-Guide/About-configuring-data-sources/Configure-a-Microsoft-SQL-Server-data-source - 2024-02-05 - To configure a data source based on a Microsoft SQL Server (MSSQL) database, complete the following steps.

Remote Matching Service User Guide
Platform
Brainware
Product
Remote Matching Service
Release
23.1
License

To configure a data source based on a Microsoft SQL Server (MSSQL) database, complete the following steps.

To use a MSSQL Server data source, you must have Microsoft SQL Server authentication enabled and TCP/IP enabled on your system. The value is usually 1433 for SQL Server and 1521 for Oracle.

  1. On the navigation pane, expand Data Sources.
  2. Right-click a data source and select Add > SQL Server.
  3. In the Add Data Source dialog box, in the Configuration section, complete the following substeps.
    1. In the Name field, type a name for the data source.
    2. In the Host field, type the server host name or IP address.
    3. In the Port field, type the TCP/IP port number. The value is typically 1433, which is the default setting.
    4. (Optional) In the Database field, type the name for the default database for RMS to use to connect to the data source. If you leave this field blank, the default database is the database assigned to the user account that connects to the database.
  4. (Optional) To test the data source configuration, in the Add Data Source dialog box, in the Test Configuration section, complete the following substeps.
    1. In the User Name field, type the database user name.
    2. In the Password field, type the database user password.
    3. Click Test.
      RMS tests the connection and displays a success or failure message.
  5. Click Save to create the data source with the current configuration.