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

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