salt.states.mssql_login

Management of Microsoft SQLServer Logins

The mssql_login module is used to create and manage SQL Server Logins

frank:
  mssql_login.present
    - domain: mydomain
salt.states.mssql_login.absent(name, **kwargs)

Ensure that the named login is absent

name

The name of the login to remove

salt.states.mssql_login.present(name, password=None, domain=None, server_roles=None, options=None, **kwargs)

Checks existence of the named login. If not present, creates the login with the specified roles and options.

name

The name of the login to manage

password

Creates a SQL Server authentication login Since hashed passwords are varbinary values, if the new_login_password is 'long', it will be considered to be HASHED.

domain

Creates a Windows authentication login. Needs to be NetBIOS domain or hostname

server_roles

Add this login to all the server roles in the list

options

Can be a list of strings, a dictionary, or a list of dictionaries