Skip to main content

Microsoft SQL Server

Connector name

agtsql

Connector type

Executable

Type (UI field value)

Microsoft SQL Server

Target system versions supported / tested

The agtsql connector is known to work with the following versions of SQL Server; other versions may work:

  • Microsoft SQL Server 2022

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2016

  • Microsoft SQL Server 2014

  • Microsoft SQ Server 2012

  • Microsoft SQL Server 2008 R2

Connector status / support

Bravura Security-Verified

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

Installation / setup

No agent software is installed on the SQL Server system.

Bravura Security Fabric can manage SQL Server database-level accounts (logins) using the connector for SQL Server (agtsql). Bravura Security Fabric can bind to an MSSQL server using its native TDS protocol. Once connected, Bravura Security Fabric can list users, validate current passwords, and administratively reset passwords by issuing SQL commands and/or calling stored procedures (for example SELECT, ALTER USER, UPDATE). Default SQL commands are included to update SQL Server user passwords.

Bravura Security Fabric can create, delete, enable, disable, modify, and rename system users in any specified MSSQL server. It creates new MSSQL users by cloning existing ones, copying and adjusting their group memberships and tablespace rights in the process. It can also directly manage the membership of MSSQL users in MSSQL groups.

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

  • user verify password *

  • user change password

  • get server information

  • administrator reset password

  • check password expiry

  • enable account

  • disable account

  • check account enabled

  • check account lock

  • create account

  • delete account

  • add user to group

  • delete user from group

  • update attributes

  • list account attributes

  • check account expiry

  • run command

  • List:

    • accounts

    • attributes

    • groups

    • members

    • computer objects

    Note

    Bravura Security Fabric group operations, such as "add user to group", work for what SQL Server refers to as server roles. There is no group security object in SQL Server.

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

Bravura Security Fabric can manage passwords for accounts defined wholly inside an application table space, rather than database-level accounts, using the scripted connector for SQL Server (agtsqlscript). See Microsoft SQL Server Hosted Applications for details.

Bravura Security Fabric can also discover SQL server instances and retrieve attributes from the discovered instances.

In this section: