Targeting Microsoft SQL Server hosted applications
For each SQL Server server hosted application, add a target system (Manage the system > Resources > Target systems):
Type is Microsoft SQL Server (Script) .
Address uses options described in the table below.
Option | Description |
|---|---|
Options marked with a | |
Server | The IP address/domain name of the database server. Optionally, you can include the SQL Server instance name in the server name field. You must include the instance if you want to target an SQL Server instance that isn’t the default instance of the target system administrator. Alternatively, you can use the server alias . (key: server) |
ODBC Driver | Select an ODBC driver available on the system (key: driver) |
Instance | The value for the substitution variable _instance . It can be used to specify a database to use or a schema in the script. |
Script file | The file must be in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory and describes the SQL commands used in the interaction between the connector and the database. (key: script) |
Use windows authentication for connecting to database | Default is false . (key: windowsAuthentication) |
The Administrator ID and Password are the login ID and password for the target system administrator you configured in configured 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, check the Run as? option for the target system administrator.
The full list of target parameters is explained in Target system options .