Microsoft SQL Server Plugin
Rotate SQL Server passwords
Keeper has launched a new Password Rotation feature with Keeper Secrets Manager. This new capability is recommended for all password rotation use cases. The Documentation is linked below:
This plugin allows rotating a user's password in Microsoft SQL Server
pip3 install pymssql
Rotation supports legacy and typed records. If using typed record, a 'Login' type field is required. Additional fields may be added depending on the rotation type as well. See the instructions below.
Complete record example. Follow steps below to setup a record for rotation
Commander will use these settings to connect.
TIP: If the port is set to 1433, or the host begins with "mssql://" Commander will automatically recognize the record as Microsoft SQL credentials and will use that rotation method unless otherwise configured
Commander will use the password to login to perform the rotation
Create a Text type custom field labeled "cmdr:db" and fill in the name of the database to connect to.
Instead of using the fields above, custom fields can be added with the shown label
A Keeper Record that is setup for MSSQL rotation
To rotate Azure passwords, use the
rotatecommand in Commander. Pass the command a record title or UID (or use
--matchwith a regular expression to rotate several records at once)
rotate "MSSQL Example" --plugin mssql
The plugin can be supplied to the command as shown here added to a record field, or automatically assigned based on the port number (see options above). Adding the plugin type to the record makes it possible to rotate several records at once with different plugins.
After rotation is completed, the new password will be stored in the
Passwordfield of the record