Feature/issue 189 add sid to login

[OsirisDBA]

Description

SQL Logins for always on instances require that the SID match across all nodes in the cluster. DBAtools already supports the sid parameter so just adding it as an optional parameter.

Fixes lowlydba/lowlydba.sqlserver#189

How Has This Been Tested?

Add sid to the integration test for login.

Types of changes

• [ ] Bug fix (non-breaking change which fixes an issue) - Fixes #
• [x] New feature (non-breaking change which adds functionality)

Checklist:

• [x] I have read/followed the CONTRIBUTING document.
• [x] I have read/followed the PR Quick Start Guide
• [x] I have added tests to cover my changes or they are N/A.
• [x] I have added a changelog fragment describing the changes.
• [x] New module options/parameters include a version_added property.

[github-actions[bot]]

Docs Build 📝

Thank you for contribution!✨

The docs for this PR have been published here: https://lowlydba.github.io/lowlydba.sqlserver/pr/194

You can compare to the docs for the main branch here: https://lowlydba.github.io/lowlydba.sqlserver/branch/main

The docsite for this PR is also available for download as an artifact from this run: https://github.com/lowlydba/lowlydba.sqlserver/actions/runs/5786959294

File changes:

• M collections/lowlydba/sqlserver/ag_listener_module.html
• M collections/lowlydba/sqlserver/ag_replica_module.html
• M collections/lowlydba/sqlserver/agent_job_category_module.html
• M collections/lowlydba/sqlserver/agent_job_module.html
• M collections/lowlydba/sqlserver/agent_job_schedule_module.html
• M collections/lowlydba/sqlserver/agent_job_step_module.html
• M collections/lowlydba/sqlserver/availability_group_module.html
• M collections/lowlydba/sqlserver/backup_module.html
• M collections/lowlydba/sqlserver/credential_module.html
• M collections/lowlydba/sqlserver/database_module.html
• M collections/lowlydba/sqlserver/dba_multitool_module.html
• M collections/lowlydba/sqlserver/first_responder_kit_module.html
• M collections/lowlydba/sqlserver/hadr_module.html
• M collections/lowlydba/sqlserver/index.html
• M collections/lowlydba/sqlserver/install_script_module.html
• M collections/lowlydba/sqlserver/instance_info_module.html
• M collections/lowlydba/sqlserver/login_module.html
• M collections/lowlydba/sqlserver/maintenance_solution_module.html
• M collections/lowlydba/sqlserver/memory_module.html
• M collections/lowlydba/sqlserver/nonquery_module.html
• M collections/lowlydba/sqlserver/resource_governor_module.html
• M collections/lowlydba/sqlserver/restore_module.html
• M collections/lowlydba/sqlserver/rg_resource_pool_module.html
• M collections/lowlydba/sqlserver/rg_workload_group_module.html
• M collections/lowlydba/sqlserver/sa_module.html
• M collections/lowlydba/sqlserver/sp_configure_module.html
• M collections/lowlydba/sqlserver/sp_whoisactive_module.html
• M collections/lowlydba/sqlserver/spn_module.html
• M collections/lowlydba/sqlserver/tcp_port_module.html
• M collections/lowlydba/sqlserver/traceflag_module.html
• M collections/lowlydba/sqlserver/user_module.html

Click to see the diff comparison.

**NOTE:** only file modifications are shown here. New and deleted files are excluded. See the file list and check the published docs to see those files. ```diff diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/ag_listener_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/ag_listener_module.html index fada97f..ca5b234 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/ag_listener_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/ag_listener_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.ag_listener module – Configures an availability group listener

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/ag_replica_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/ag_replica_module.html index e9fff8c..e5ba098 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/ag_replica_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/ag_replica_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.ag_replica module – Configures an availability group replica

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_category_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_category_module.html index df728a0..34c846b 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_category_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_category_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.agent_job_category module – Configures a SQL Agent job category

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_module.html index 1b06020..fd72907 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.agent_job module – Configures a SQL Agent job

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_schedule_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_schedule_module.html index 14cc5bc..b284fa7 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_schedule_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_schedule_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.agent_job_schedule module – Configures a SQL Agent job schedule

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_step_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_step_module.html index 2ec7368..b3745ec 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/agent_job_step_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/agent_job_step_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.agent_job_step module – Configures a SQL Agent job step

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/availability_group_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/availability_group_module.html index 198db3c..c6f88d1 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/availability_group_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/availability_group_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.availability_group module – Configures availability group(s)

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/backup_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/backup_module.html index 0c614f2..5d53c98 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/backup_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/backup_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.backup module – Performs a backup operation

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/credential_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/credential_module.html index d9ac111..e8f104b 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/credential_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/credential_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.credential module – Configures a credential on a SQL server

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/database_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/database_module.html index 58f8a19..11709ee 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/database_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/database_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.database module – Creates and configures a database

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/dba_multitool_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/dba_multitool_module.html index 1d534c4..302fe49 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/dba_multitool_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/dba_multitool_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.dba_multitool module – Install/update the DBA Multitool suite by John McCall

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/first_responder_kit_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/first_responder_kit_module.html index 05c95f2..b2c63db 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/first_responder_kit_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/first_responder_kit_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.first_responder_kit module – Install/update the First Responder Kit scripts

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/hadr_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/hadr_module.html index 3c891ac..e1514cf 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/hadr_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/hadr_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.hadr module – Enable or disable HADR

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/index.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/index.html index fd8af97..6b06f3c 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/index.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/index.html @@ -127,7 +127,7 @@

Lowlydba.Sqlserver

-

Collection version 2.0.0

+

Collection version 2.1.0

• Description

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/install_script_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/install_script_module.html index 72efcf8..37f9024 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/install_script_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/install_script_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.install_script module – Runs migration scripts against a database

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/instance_info_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/instance_info_module.html index 6886981..28a1d01 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/instance_info_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/instance_info_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.instance_info module – Returns basic information for a SQL Server instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/login_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/login_module.html index c7078fd..6602c9e 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/login_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/login_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.login module – Configures a login for the target SQL Server instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

@@ -249,27 +249,35 @@ see

+

sid

+

string

+

added in lowlydba.sqlserver 2.1.0

+

+

Provide an explicit Sid that should be used when creating the account.

+

+ +

sql_instance

string / required

The SQL Server instance to modify.

-

+

sql_password

string

Password for SQL Authentication.

-

+

sql_username

string

Username for SQL Authentication.

-

+

state

string

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/maintenance_solution_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/maintenance_solution_module.html index 09d98d3..02706d5 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/maintenance_solution_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/maintenance_solution_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.maintenance_solution module – Install/update Maintenance Solution by Ola Hallengren

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/memory_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/memory_module.html index c7b6aab..ef5426f 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/memory_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/memory_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.memory module – Sets the maximum memory for a SQL Server instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/nonquery_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/nonquery_module.html index e741297..62ac3a8 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/nonquery_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/nonquery_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.nonquery module – Executes a generic nonquery

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/resource_governor_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/resource_governor_module.html index 22c22bc..5a70a31 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/resource_governor_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/resource_governor_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.resource_governor module – Configures the resource governor on a SQL Server instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/restore_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/restore_module.html index 0bf1633..17c265f 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/restore_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/restore_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.restore module – Performs a restore operation

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/rg_resource_pool_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/rg_resource_pool_module.html index ff4896b..6a78b92 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/rg_resource_pool_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/rg_resource_pool_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.rg_resource_pool module – Configures a resource pool for use by the Resource Governor

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/rg_workload_group_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/rg_workload_group_module.html index c72636a..03b5412 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/rg_workload_group_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/rg_workload_group_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.rg_workload_group module – Configures a workload group for use by the Resource Governor

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sa_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sa_module.html index 6848f40..d0dbf53 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sa_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sa_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.sa module – Configure the sa login for security best practices

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sp_configure_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sp_configure_module.html index d8a6988..f75a709 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sp_configure_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sp_configure_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.sp_configure module – Make instance level system configuration changes via sp_configure

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sp_whoisactive_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sp_whoisactive_module.html index c343ea1..698855d 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/sp_whoisactive_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/sp_whoisactive_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.sp_whoisactive module – Install/update sp_whoisactive by Adam Mechanic

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/spn_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/spn_module.html index 4789154..ee9866c 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/spn_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/spn_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.spn module – Configures SPNs for SQL Server

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/tcp_port_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/tcp_port_module.html index f6f0d19..6cd8630 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/tcp_port_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/tcp_port_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.tcp_port module – Sets the TCP port for the instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/traceflag_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/traceflag_module.html index dd037ac..cf26794 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/traceflag_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/traceflag_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.traceflag module – Enable or disable global trace flags on a SQL Server instance

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

diff --git a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/user_module.html b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/user_module.html index e5c3dc4..6b9227c 100644 --- a/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/base/collections/lowlydba/sqlserver/user_module.html +++ b/home/runner/work/lowlydba.sqlserver/lowlydba.sqlserver/docsbuild/head/collections/lowlydba/sqlserver/user_module.html @@ -130,7 +130,7 @@

lowlydba.sqlserver.user module – Configures a user within a database

Note

-

This module is part of the lowlydba.sqlserver collection (version 2.0.0).

+

This module is part of the lowlydba.sqlserver collection (version 2.1.0).

To install it, use: ansible-galaxy collection install lowlydba.sqlserver. You need further requirements to be able to use this module, see Requirements for details.

```

[codecov-commenter]

Codecov Report

Patch coverage has no change and project coverage change: +6.20% :tada:

Comparison is base (84756bc) 93.79% compared to head (a93015e) 100.00%. Report is 2 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #194 +/- ## =========================================== + Coverage 93.79% 100.00% +6.20% =========================================== Files 64 33 -31 Lines 2192 106 -2086 =========================================== - Hits 2056 106 -1950 + Misses 136 0 -136 ``` | Flag | Coverage Δ | | |---|---|---| | sanity | `100.00% <ø> (ø)` | | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=John+McCall#carryforward-flags-in-the-pull-request-comment) to find out more. | [Files Changed](https://app.codecov.io/gh/lowlydba/lowlydba.sqlserver/pull/194?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=John+McCall) | Coverage Δ | | |---|---|---| | [plugins/modules/login.py](https://app.codecov.io/gh/lowlydba/lowlydba.sqlserver/pull/194?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=John+McCall#diff-cGx1Z2lucy9tb2R1bGVzL2xvZ2luLnB5) | `100.00% <ø> (ø)` | | | [plugins/modules/sa.py](https://app.codecov.io/gh/lowlydba/lowlydba.sqlserver/pull/194?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=John+McCall#diff-cGx1Z2lucy9tb2R1bGVzL3NhLnB5) | `100.00% <ø> (ø)` | | ... and [31 files with indirect coverage changes](https://app.codecov.io/gh/lowlydba/lowlydba.sqlserver/pull/194/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=John+McCall)

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[OsirisDBA]

@lowlydba These windows ones are still failing on .github/workflows/ansible-test-windows.yml

[lowlydba]

@lowlydba These windows ones are still failing on .github/workflows/ansible-test-windows.yml

Yeah, I am working on some of the Windows encryption issues in another PR - this is a pretty straightforward change so I'm OK with just the linux CI passing.

I'll get this released once the Windows issues are cleared up. Thanks again!