Add Relational Database Data Source (Classic)

Creates a relational database data source.

Before you begin

Provide a name, product, and description for your data source.

Procedure

  1. Select the check box for Enable Relational Database Connection and enter these details:
    Field Name Description
    Database Type Currently, Microsoft SQL Server is the only supported database type.
    Host Enter the IP address or host name of database server. For example: 10.181.213.211 or databaseserver01.
    Note: If using a SQL named instance, enter the host name in the format ServerName\InstanceName. For example: databaseserver01\SQLEXPRESS.
    Port Enter the port number to connect to the SQL Server.
    Note: If using a SQL named instance, enter the exact port of the SQL named instance.
    Database Enter the database name to connect.
    Certificate Required Select the check box if connecting to the data source requires SSL certificates.

    Select Choose Certificate to browse to your system and add certificates.
  2. Provide SQL server authentication details:
    Field Name Description
    User Name Enter the user name for the database you want to access.
    Password Enter the password of the user configured in the database.
    Test

    Select to check whether the database connection is established using the server and authentication details.

    A message confirms on a successful connection to the database.

    If test fails, the message provides more details on the failure.
    A successful SQL Database connection.
  3. Select Save.