Targeting a Microsoft SQL Server
For each SQL Server server, add a target system (Manage the system > Resources > Target systems):
Type is Microsoft SQL Server .
Address uses options described in the table below.
Option | Description |
|---|---|
Options marked with a | |
Server | The IP address/domain name of the database server. The instance name and/or port number are required when targeting any instance other than the default one. Alternatively, use the alias you configured. (key: server) |
Use windows authentication for connecting to database | Default is false . (key: windowsAuthentication) |
ODBC Driver | Select an ODBC driver available on the system (key: driver) |
Type of accounts to list from the server | Select:
|
Trust server certificate | Default is false (key: trustServerCertificate) |
Encrypt | Encrypt connection. Default is false (key: encrypt) |
Discover DB details | Retrieve instance specific attributes. Default is false (key: probeDB) |
The syntax is as follows:
{server=<serverName>[\<serverInstance>][,<serverPort>];[windowsAuthentication=<true|false>];[driver=<nativeclient>];[accountListType=<All|Windows|SQL>];[trustServerCertificate=<true|false>];[encrypt=<true|false>];}
Administrator ID and Password are the login ID and password for the target system administrator you configured in earlier.
By default, all connectors run the Bravura Security Fabric processes on the Bravura Security Fabric server, as the local psadmin account. To enable the target system administrator to run those processes, select the Run as? checkbox.
If using Windows Authentication for SQL, enable the Run as? option for the target system administrator.
The full list of target parameters is explained in Target system options .