Skip to main content

Microsoft SQL Server Hosted Applications

Connector name

agtsqlscript

Connector type

Executable with configuration SQL script

Type (UI field value)

Microsoft SQL Server (SCript)

Connector status / support

Bravura Security-Verified

This connector has been tested and is fully supported by Bravura Security.

Installation / setup

You write a script file to define SQL commands used in the interaction between the agtsqlscript connector and the SQL Server database. A sample script, agtsqlscript.cfg is contained in the samples directory. Note that any sample script may need customizations in order to work with your system.

No connector software is installed on the SQL Server Applications server or the back-end database.

Bravura Security Fabric can manage passwords for accounts defined wholly inside an SQL Server application table space using the scripted connector for SQL Server (agtsqlscript). This connector uses the SQL Server client software to bind to the SQL Server database server and issues SQL commands that you provide in a script file.

Bravura Security Fabric can perform operations on applications that have an SQL Server back-end database by connecting to the SQL Server using TDS, and either directly updating user records (for example, SQL UPDATE) or by calling stored procedures.

The following Bravura Security Fabric operations are supported by this connector:

  • user verify password

  • user change password

  • get server information

  • administrator reset password

  • administrator reset+expire password

  • expire password

  • unexpire password

  • administrator verify password

  • verify+reset password

  • enable account

  • disable account

  • check account enabled

  • create account

  • delete account

  • expire account

  • check account expiry

  • unexpire account

  • lock account

  • unlock account

  • check account lock

  • add user to group

  • delete user from group

  • create group

  • delete group

  • add group to group

  • remove group from group

  • update attributes

  • list account attributes

  • List:

    • accounts

    • attributes

    • groups

    • members

    • computer objects

    • subscribers

    • update subscriber attributes/password

For a full list and explanation of each connector operation, see Connector operations.

This connector also supports custom operations, as defined in the configuration script .

Bravura Security Fabric can also manage SQL Server database-level accounts using the connector for SQL Server (agtsql). See Microsoft SQL Server for details.

Authentication

The agtsql connector supports both SQL Server Authentication and Windows Authentication. When using Windows Authentication, the SQL server and Bravura Security Fabric server should belong to the same domain, and the password reset operation is not supported.

In this section: