Page Comparison

...

Connecting the UMS to the Database (Single Instance)
Anchor
ADNativeAuthConnectSingle
ADNativeAuthConnectSingle

Note

Before configuring the connection, perform the following:

Right-click the UMS Administrator (for example, in the start menu) and select Run as different user from the context menu.
Authenticate with the SQL AD Service Account.
Log into the UMS server as the SQL AD Service Account.
Run the UMS Administrator.

In the UMS Administrator, set up a new SQL Server AD Native type data source.
Edit the data as follows:
- Host: The Fully Qualified Host Name (FQDN) of the Microsoft SQL server. If you deploy MS SQL Server Always On Availability Groups, enter the domain name of the Always On Availability Group listener.
- Port: The port on which the Microsoft SQL Server listens for requests. (Default: 1433)
- Schema: The database schema
- Database / SID: The database name
- JDBC Parameter (double-click):
  - sendStringParametersAsUnicode: false
  - trustServerCertificate: true
Select your database configuration and click Activate.

Note

Before configuring the connection, perform the following:

Right-click the UMS Administrator (for example, in the start menu) and select Run as different user from the context menu.
Authenticate with the SQL AD Service Account.
Log into the UMS server as the SQL AD Service Account.
Run the UMS Administrator.

In the UMS Administrator, set up a new SQL Server Cluster AD Native type data source.
Edit the data as follows:
- Host: The Fully Qualified Host Name (FQDN) of the Microsoft SQL server
- Port: The port on which the Microsoft SQL Server listens for requests. (Default: 1433)
- Schema: The database schema
- Database / SID: The database name
- Instance: The instance for your Microsoft SQL Server Cluster
- JDBC Parameter (double-click):
  - sendStringParametersAsUnicode: false
  - trustServerCertificate: true
Select your database configuration and click Activate.

...