SqlServerDsc

16.6.0

Module with DSC resources for deployment and configuration of Microsoft SQL Server.

Minimum PowerShell version

5.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SqlServerDsc -RequiredVersion 16.6.0

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SqlServerDsc -Version 16.6.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Copyright the DSC Community contributors. All rights reserved.

Package Details

Author(s)

  • DSC Community

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

Functions

Add-SqlDscNode Add-SqlDscTraceFlag Complete-SqlDscFailoverCluster Complete-SqlDscImage Connect-SqlDscDatabaseEngine ConvertFrom-SqlDscDatabasePermission ConvertFrom-SqlDscServerPermission ConvertTo-SqlDscDatabasePermission ConvertTo-SqlDscServerPermission Disable-SqlDscAudit Disconnect-SqlDscDatabaseEngine Enable-SqlDscAudit Get-SqlDscAudit Get-SqlDscConfigurationOption Get-SqlDscDatabasePermission Get-SqlDscManagedComputer Get-SqlDscManagedComputerService Get-SqlDscPreferredModule Get-SqlDscServerPermission Get-SqlDscStartupParameter Get-SqlDscTraceFlag Import-SqlDscPreferredModule Initialize-SqlDscRebuildDatabase Install-SqlDscServer Invoke-SqlDscQuery New-SqlDscAudit Remove-SqlDscAudit Remove-SqlDscNode Remove-SqlDscTraceFlag Repair-SqlDscServer Save-SqlDscSqlServerMediaFile Set-SqlDscAudit Set-SqlDscDatabasePermission Set-SqlDscServerPermission Set-SqlDscStartupParameter Set-SqlDscTraceFlag Test-SqlDscIsDatabasePrincipal Test-SqlDscIsLogin Test-SqlDscIsSupportedFeature Uninstall-SqlDscServer

DSCResources

SqlAudit SqlDatabasePermission SqlPermission SqlAG SqlAGDatabase SqlAgentAlert SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlConfiguration SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseMail SqlDatabaseObjectPermission SqlDatabaseRole SqlDatabaseUser SqlEndpoint SqlEndpointPermission SqlLogin SqlMaxDop SqlMemory SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

## [16.6.0] - 2024-05-16

### Added

- SqlServerDsc
 - Added build tasks to generate Wiki documentation for public commands.
 - Initial integration tests for commands.
- SqlDatabaseMail
 - Added the parameter `UseDefaultCredentials` to control use of the DatabaseEngine
   service account for SMTP server authentication.
- New public commands
 - `Save-SqlDscSqlServerMediaFile` - Downloads the content on the provided URL
   and if it is an executable it will use the executable to download the
   ISO image media.

### Fixed

- SqlServerDsc
 - `Get-SMOModuleCalculatedVersion`
   - Return SQLPS version as 12.0 instead of 120
 - `Get-SqlDscPreferredModule`
   - Fix sort to get the latest version
 - Public commands no handles when both `-Force` and `-Confirm $true`
   would be passed to command.
 - Enabled NUnit results for HQRM tests.
- `Assert-Feature`
 - Fixed unit tests.
- SqlAGReplica
 - Fix unit test FailedRemoveAvailabilityGroupReplica
- SqlAgentOperator
 - Integration test for changing e-mail address on an existing operator.
- `DatabasePermission`
 - New method ToString() for making verbose output better.
- `ServerPermission`
 - New method ToString() for making verbose output better.
- SqlAgDatabase
 - Remove unused help file ([issue #1745](https://github.com/dsccommunity/SqlServerDsc/issues/1745)).
- SqlDatabaseObjectPermission
 - Added `foreach` loop in `Get-TargetResource` to fix issues with `INSERT`
   permissions when it's not the only permission on the table ([issue [#2006](https://github.com/dsccommunity/SqlServerDsc/issues/2006)]).
- `Install-SqlDscServer`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Add-SqlDscNode`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Complete-SqlDscFailoverCluster`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Complete-SqlDscImage`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Initialize-SqlDscRebuildDatabase`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Remove-SqlDscNode`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Repair-SqlDscServer`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- `Uninstall-SqlDscServer`
 - No longer throws with duplicate parameter error if the parameter
   `ErrorAction` is passed to the command.
- Private functions
 - `Invoke-SetupAction` no longer throws when secure strings is passed on
   Windows PowerShell.

### Changed

- SqlServerDsc
 - Updated pipeline files to support pre-releases with ModuleFast (when
   resolving dependencies).
 - Bump PSResourceGet to v1.0.0 (used when resolving dependencies).
 - Update markdown highlights with newly supported keywords.
 - Bump GitHub Action _Stale_ to v9.
 - Bump GitHub Action _CodeQL-Action_ to v3.
 - Documentation is now built using a separate meta task `docs`.
   It is run with the meta task `pack` which is run by the pipeline.
   To run the meta task `docs` the SMO assemblies must be loaded into the
   session, either by importing SqlServer module or loading SMO stubs.
 - QA test improved to speed up quality testing.
 - The pipeline test stages has been split into different stages.
- SqlAG
 - Converted unit test to Pester 5
 - DtcSupportEnabled option in Set-TargetResource and TestTargetResource
- SqlSetup
 - Updated integration tests to use PSResourceGet to download required modules.
- SqlRS
 - Integration tests for SQL Server 2022 has been temporarily disabled due
   to a unknown problem. More information in [issue #2009](https://github.com/dsccommunity/SqlServerDsc/issues/2009).

FileList

Version History

Version Downloads Last updated
16.6.1-previ... 48 5/23/2024
16.6.1-previ... 3 5/22/2024
16.6.0 (current version) 19,336 5/17/2024
16.6.0-previ... 9 5/12/2024
16.6.0-previ... 2 5/11/2024
16.6.0-previ... 103 3/3/2024
16.6.0-previ... 45 1/20/2024
16.6.0-previ... 5 1/19/2024
16.5.1-previ... 67 12/15/2023
16.5.1-previ... 90 11/19/2023
16.5.1-previ... 46 11/2/2023
16.5.0 142,983 10/5/2023
16.5.0-previ... 11 10/1/2023
16.5.0-previ... 6 9/29/2023
16.5.0-previ... 46 9/1/2023
16.5.0-previ... 6 8/26/2023
16.4.1-previ... 5 8/25/2023
16.4.0 111,305 8/22/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 5 8/19/2023
16.4.0-previ... 75 5/18/2023
16.4.0-previ... 19 5/10/2023
16.4.0-previ... 5 5/9/2023
16.4.0-previ... 6 5/8/2023
16.3.1 459,659 5/6/2023
16.3.1-previ... 4 5/6/2023
16.3.1-previ... 8 5/4/2023
16.3.0 42,137 4/26/2023
16.3.0-previ... 6 4/26/2023
16.3.0-previ... 5 4/25/2023
16.3.0-previ... 5 4/24/2023
16.3.0-previ... 5 4/23/2023
16.3.0-previ... 20 4/18/2023
16.3.0-previ... 4 4/16/2023
16.2.1-previ... 6 4/12/2023
16.2.0 75,029 4/10/2023
16.2.0-previ... 4 4/10/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 9 4/6/2023
16.2.0-previ... 9 4/1/2023
16.2.0-previ... 10 3/28/2023
16.2.0-previ... 9 3/26/2023
16.2.0-previ... 4 3/25/2023
16.2.0-previ... 169 3/19/2023
16.2.0-previ... 26 3/7/2023
16.2.0-previ... 9 3/4/2023
16.1.0 175,498 2/28/2023
16.1.0-previ... 5 2/28/2023
16.1.0-previ... 8 2/25/2023
16.1.0-previ... 5 2/24/2023
16.1.0-previ... 47 2/13/2023
16.1.0-previ... 27 2/12/2023
16.1.0-previ... 24 2/5/2023
16.1.0-previ... 10 2/1/2023
16.1.0-previ... 28 1/25/2023
16.1.0-previ... 7 1/24/2023
16.1.0-previ... 4 1/24/2023
16.1.0-previ... 11 1/22/2023
16.1.0-previ... 345 1/4/2023
16.1.0-previ... 5 1/3/2023
16.1.0-previ... 14 12/26/2022
16.1.0-previ... 49 12/19/2022
16.1.0-previ... 12 12/17/2022
16.1.0-previ... 114 12/11/2022
16.1.0-previ... 12 12/4/2022
16.1.0-previ... 35 11/26/2022
16.1.0-previ... 10 11/24/2022
16.0.1-previ... 30 11/11/2022
16.0.0 827,055 9/9/2022
16.0.0-previ... 29 8/21/2022
16.0.0-previ... 23 8/13/2022
16.0.0-previ... 14 8/13/2022
16.0.0-previ... 25 8/1/2022
16.0.0-previ... 80 6/14/2022
16.0.0-previ... 24 6/8/2022
16.0.0-previ... 17 6/6/2022
16.0.0-previ... 14 6/6/2022
16.0.0-previ... 88 4/26/2022
16.0.0-previ... 44 3/28/2022
16.0.0-previ... 65 2/12/2022
15.2.0 2,683,984 9/1/2021
15.2.0-previ... 15 9/1/2021
15.2.0-previ... 44 7/23/2021
15.2.0-previ... 75 6/6/2021
15.2.0-previ... 65 4/18/2021
15.2.0-previ... 85 3/12/2021
15.1.1 1,381,890 2/12/2021
15.1.1-previ... 17 2/12/2021
15.1.0 62,348 2/2/2021
15.1.0-previ... 24 2/1/2021
15.1.0-previ... 19 1/31/2021
15.0.2-previ... 18 1/30/2021
15.0.2-previ... 24 1/24/2021
15.0.2-previ... 62 1/21/2021
15.0.2-previ... 61 1/12/2021
15.0.1 143,049 1/9/2021
15.0.1-previ... 58 1/9/2021
15.0.1-previ... 63 1/6/2021
15.0.1-previ... 59 1/6/2021
15.0.1-previ... 68 12/27/2020
15.0.1-previ... 60 12/26/2020
15.0.1-previ... 62 12/23/2020
15.0.1-previ... 70 12/14/2020
15.0.1-previ... 61 12/13/2020
15.0.1-previ... 59 12/12/2020
15.0.1-previ... 60 12/10/2020
15.0.0 214,135 12/6/2020
15.0.0-previ... 60 12/6/2020
15.0.0-previ... 65 11/25/2020
15.0.0-previ... 57 11/22/2020
15.0.0-previ... 61 11/21/2020
14.3.0-previ... 98 10/5/2020
14.3.0-previ... 54 10/3/2020
14.3.0-previ... 60 10/2/2020
14.2.2-previ... 104 8/19/2020
14.2.2-previ... 60 8/16/2020
14.2.1 640,116 8/14/2020
14.2.1-previ... 59 8/13/2020
14.2.1-previ... 60 8/11/2020
14.2.1-previ... 56 8/11/2020
14.2.1-previ... 71 7/31/2020
14.2.1-previ... 59 7/28/2020
14.2.0 72,570 7/23/2020
14.2.0-previ... 62 7/23/2020
14.2.0-previ... 64 7/19/2020
14.2.0-previ... 73 7/13/2020
14.2.0-previ... 64 7/10/2020
14.2.0-previ... 61 7/9/2020
14.1.1-previ... 63 7/9/2020
14.1.0 221,728 7/6/2020
14.1.0-previ... 368 7/5/2020
14.1.0-previ... 60 7/4/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 63 7/3/2020
14.1.0-previ... 65 7/1/2020
14.0.1-previ... 71 6/28/2020
14.0.1-previ... 60 6/26/2020
14.0.0 10,836 6/12/2020
14.0.0-previ... 61 6/12/2020
14.0.0-previ... 67 6/11/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 68 6/10/2020
14.0.0-previ... 102 5/28/2020
14.0.0-previ... 77 5/25/2020
14.0.0-previ... 67 5/25/2020
14.0.0-previ... 79 5/19/2020
14.0.0-previ... 75 5/19/2020
14.0.0-previ... 81 5/17/2020
14.0.0-previ... 70 5/17/2020
14.0.0-previ... 68 5/16/2020
14.0.0-previ... 69 5/14/2020
14.0.0-previ... 71 5/13/2020
14.0.0-previ... 79 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 82 5/8/2020
14.0.0-previ... 68 5/6/2020
14.0.0-previ... 72 5/5/2020
14.0.0-previ... 70 5/4/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 68 5/3/2020
14.0.0-previ... 83 4/27/2020
14.0.0-previ... 78 4/26/2020
13.5.0 28,319 4/12/2020
13.5.0-previ... 75 4/11/2020
13.5.0-previ... 77 4/11/2020
13.4.1-previ... 104 3/31/2020
13.4.0 122,346 3/18/2020
13.4.0-previ... 70 3/18/2020
13.3.1-previ... 116 1/18/2020
13.3.0 480,265 1/17/2020
13.3.0-previ... 73 1/17/2020
13.3.0-previ... 78 1/12/2020
13.3.0-previ... 72 1/8/2020
13.3.0-previ... 75 1/7/2020
13.3.0-previ... 72 1/3/2020
13.3.0-previ... 73 1/2/2020
13.3.0-previ... 74 1/2/2020
13.2.0.0 861,071 9/19/2019
13.1.0.0 34,993 8/8/2019
13.0.0.0 26,018 6/26/2019
12.5.0.0 17,365 5/15/2019
12.4.0.0 21,720 4/3/2019
12.3.0.0 40,223 2/20/2019
12.2.0.0 8,983 1/10/2019
12.1.0.0 23,224 10/25/2018
12.0.0.0 21,422 9/5/2018
11.4.0.0 16,151 7/25/2018
11.3.0.0 7,381 6/13/2018
11.2.0.0 5,077 5/2/2018
11.1.0.0 6,199 3/22/2018
11.0.0.0 13,020 2/8/2018
10.0.0.0 3,648 12/14/2017
Show more