lowlydba / lowlydba.sqlserver / 2.3.2 / module / sp_configure Make instance level system configuration changes via C(sp_configure) | "added in version" 0.1.0 of lowlydba.sqlserver" Authors: Sudhir Koduri (@kodurisudhir)lowlydba.sqlserver.sp_configure (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
Read instance level system configuration for a given configuration and update to a new value as provided.
- name: Enable remote DAC connection lowlydba.sqlserver.sp_configure: sql_instance: sql-01.myco.io name: RemoteDacConnectionsEnabled value: 1
name: description: - Name of the configuration that will be changed. required: true type: str value: description: - New value the configuration will be set to. required: true type: int sql_instance: description: - The SQL Server instance to modify. required: true type: str sql_password: description: - Password for SQL Authentication. required: false type: str sql_username: description: - Username for SQL Authentication. required: false type: str
data: description: - Output from the C(Set-DbaSpConfigure) function. - RestartRequired returned if the setting requires a service restart to take effect. returned: success, but not in check_mode. type: dict