SqlServerDsc
17.3.0-preview0008
This module contains commands and DSC resources for deployment and configuration of Microsoft SQL Server, SQL Server Reporting Services and Power BI Report Server.
Minimum PowerShell version
5.0
Installation Options
Owners
Copyright
Copyright the DSC Community contributors. All rights reserved.
Package Details
Author(s)
- DSC Community
Tags
DesiredStateConfiguration DSC DSCResourceKit DSCResource SqlServer PowerBI ReportingServices ReportServer
Functions
Add-SqlDscNode Add-SqlDscTraceFlag Assert-SqlDscAgentOperator Assert-SqlDscLogin Complete-SqlDscFailoverCluster Complete-SqlDscImage Connect-SqlDscDatabaseEngine ConvertFrom-SqlDscDatabasePermission ConvertFrom-SqlDscServerPermission ConvertTo-SqlDscDatabasePermission ConvertTo-SqlDscEditionName ConvertTo-SqlDscServerPermission Deny-SqlDscServerPermission Disable-SqlDscAgentOperator Disable-SqlDscAudit Disable-SqlDscLogin Disconnect-SqlDscDatabaseEngine Enable-SqlDscAgentOperator Enable-SqlDscAudit Enable-SqlDscLogin Get-SqlDscAgentAlert Get-SqlDscAgentOperator Get-SqlDscAudit Get-SqlDscConfigurationOption Get-SqlDscDatabase Get-SqlDscDatabasePermission Get-SqlDscInstalledInstance Get-SqlDscLogin Get-SqlDscManagedComputer Get-SqlDscManagedComputerInstance Get-SqlDscManagedComputerService Get-SqlDscPreferredModule Get-SqlDscRole Get-SqlDscRSSetupConfiguration Get-SqlDscServerPermission Get-SqlDscServerProtocol Get-SqlDscServerProtocolName Get-SqlDscStartupParameter Get-SqlDscTraceFlag Grant-SqlDscServerPermission Import-SqlDscPreferredModule Initialize-SqlDscRebuildDatabase Install-SqlDscBIReportServer Install-SqlDscReportingService Install-SqlDscServer Invoke-SqlDscQuery New-SqlDscAgentAlert New-SqlDscAgentOperator New-SqlDscAudit New-SqlDscDatabase New-SqlDscLogin New-SqlDscRole Remove-SqlDscAgentAlert Remove-SqlDscAgentOperator Remove-SqlDscAudit Remove-SqlDscDatabase Remove-SqlDscLogin Remove-SqlDscNode Remove-SqlDscRole Remove-SqlDscTraceFlag Repair-SqlDscBIReportServer Repair-SqlDscReportingService Repair-SqlDscServer Revoke-SqlDscServerPermission Save-SqlDscSqlServerMediaFile Set-SqlDscAgentAlert Set-SqlDscAgentOperator Set-SqlDscAudit Set-SqlDscConfigurationOption Set-SqlDscDatabase Set-SqlDscDatabaseDefault Set-SqlDscDatabasePermission Set-SqlDscServerPermission Set-SqlDscStartupParameter Set-SqlDscTraceFlag Test-SqlDscAgentAlertProperty Test-SqlDscConfigurationOption Test-SqlDscDatabase Test-SqlDscIsAgentAlert Test-SqlDscIsAgentOperator Test-SqlDscIsDatabasePrincipal Test-SqlDscIsLogin Test-SqlDscIsLoginEnabled Test-SqlDscIsRole Test-SqlDscIsSupportedFeature Test-SqlDscRSInstalled Test-SqlDscServerPermission Uninstall-SqlDscBIReportServer Uninstall-SqlDscReportingService Uninstall-SqlDscServer
DSCResources
SqlAgentAlert SqlAudit SqlDatabasePermission SqlPermission SqlRSSetup SqlAG SqlAGDatabase SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlConfiguration SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseMail SqlDatabaseObjectPermission SqlDatabaseRole SqlDatabaseUser SqlEndpoint SqlEndpointPermission SqlLogin SqlMaxDop SqlMemory SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlRS SqlScript SqlScriptQuery SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall
Dependencies
This module has no dependencies.
Release Notes
## [17.3.0-preview0008] - 2025-10-12
### Added
- Added integration tests for `Get-SqlDscDatabasePermission` command to ensure
database permission retrieval functions correctly in real environments
[issue #2221](https://github.com/dsccommunity/SqlServerDsc/issues/2221).
- Added integration tests for `Get-SqlDscManagedComputer` command to ensure it
functions correctly in real environments
[issue #2220](https://github.com/dsccommunity/SqlServerDsc/issues/2220).
- Added integration tests for `Remove-SqlDscAudit` command to ensure it functions
correctly in real environments
[issue #2241](https://github.com/dsccommunity/SqlServerDsc/issues/2241).
- Added integration tests for `ConvertFrom-SqlDscDatabasePermission` command to
ensure it functions correctly in real environments
[issue #2211](https://github.com/dsccommunity/SqlServerDsc/issues/2211).
- Added integration tests for `Get-SqlDscStartupParameter` command to ensure it
functions correctly in real environments
[issue #2217](https://github.com/dsccommunity/SqlServerDsc/issues/2217).
- Added integration tests for `Get-SqlDscTraceFlag` command to ensure it functions
correctly in real environments
[issue #2216](https://github.com/dsccommunity/SqlServerDsc/issues/2216).
- Added integration tests for `Get-SqlDscPreferredModule` command to ensure it
functions correctly in real environments
[issue #2218](https://github.com/dsccommunity/SqlServerDsc/issues/2218).
- Added integration tests for `Enable-SqlDscAudit` command to ensure command
reliability [issue #2223](https://github.com/dsccommunity/SqlServerDsc/issues/2223).
- Added integration tests for `Get-SqlDscAudit` command to ensure it functions
correctly in real environments
[issue #2222](https://github.com/dsccommunity/SqlServerDsc/issues/2222).
- Added integration tests for `Disconnect-SqlDscDatabaseEngine` command to ensure
command reliability in real environments
[issue #2224](https://github.com/dsccommunity/SqlServerDsc/issues/2224).
- Added integration tests for `Invoke-SqlDscQuery` command to ensure it functions
correctly in real environments
[issue #2227](https://github.com/dsccommunity/SqlServerDsc/issues/2227).
- Added integration tests for `New-SqlDscAudit` command to ensure it functions
correctly in real environments
[issue #2226](https://github.com/dsccommunity/SqlServerDsc/issues/2226).
- Added integration tests for `Test-SqlDscIsLogin` command to ensure it functions
correctly in real environments
[issue #2230](https://github.com/dsccommunity/SqlServerDsc/issues/2230).
- Added integration tests for `Test-SqlDscIsDatabasePrincipal` command to ensure
it functions correctly in real environments
[issue #2231](https://github.com/dsccommunity/SqlServerDsc/issues/2231).
### Fixed
- Corrected error message in test file to recommend 'noop' task instead of 'build'
task for resolving dependencies
([issue #2279](https://github.com/dsccommunity/SqlServerDsc/issues/2279)).
- Updated integration test documentation in `tests/Integration/Commands/README.md`
to correctly reflect that `ConvertFrom-SqlDscDatabasePermission` test does not
require database instance connectivity
[issue #2284](https://github.com/dsccommunity/SqlServerDsc/issues/2284).
- Added integration tests for `Set-SqlDscAudit` command to ensure it functions
correctly in real environments
[issue #2236](https://github.com/dsccommunity/SqlServerDsc/issues/2236).
- Added integration tests for `Set-SqlDscStartupParameter` command to ensure
reliable startup parameter configuration
[issue #2233](https://github.com/dsccommunity/SqlServerDsc/issues/2233).
- Added integration tests for `Set-SqlDscServerPermission` command to ensure it
functions correctly in real environments
[issue #2234](https://github.com/dsccommunity/SqlServerDsc/issues/2234).
- Added integration tests for `Save-SqlDscSqlServerMediaFile` command to ensure
it functions correctly in real environments
[issue #2237](https://github.com/dsccommunity/SqlServerDsc/issues/2237).
- Added integration tests for `Disable-SqlDscAudit` command to ensure it functions
correctly in real environments
[issue #2206](https://github.com/dsccommunity/SqlServerDsc/issues/2206).
- Added integration tests for `ConvertTo-SqlDscDatabasePermission` command to
ensure command reliability
[issue #2209](https://github.com/dsccommunity/SqlServerDsc/issues/2209).
- Added integration tests for `Set-SqlDscDatabasePermission` command to ensure
command reliability
[issue #2235](https://github.com/dsccommunity/SqlServerDsc/issues/2235).
- Added integration test for `ConvertTo-SqlDscEditionName` command to ensure
command reliability in real environments
[issue #2208](https://github.com/dsccommunity/SqlServerDsc/issues/2208).
- Added integration tests for `Import-SqlDscPreferredModule` command to ensure
proper module import functionality in real environments
[issue #2225](https://github.com/dsccommunity/SqlServerDsc/issues/2225).
- Added integration tests for `Test-SqlDscIsSupportedFeature` command to ensure
it functions correctly in real environments
[issue #2228](https://github.com/dsccommunity/SqlServerDsc/issues/2228).
- Added integration test for `Get-SqlDscManagedComputerService` command to ensure
command reliability [issue #2219](https://github.com/dsccommunity/SqlServerDsc/issues/2219).
- Added integration tests for `Set-SqlDscTraceFlag` command to ensure it functions
correctly in real environments
[issue #2232](https://github.com/dsccommunity/SqlServerDsc/issues/2232).
- Added integration tests for `ConvertFrom-SqlDscServerPermission` command to
ensure it functions correctly in real environments
[issue #2210](https://github.com/dsccommunity/SqlServerDsc/issues/2210).
- `Remove-SqlDscTraceFlag`
- Added missing integration test to ensure command reliability ([issue #2239](https://github.com/dsccommunity/SqlServerDsc/issues/2239)).
- `Remove-SqlDscAudit`
- Added missing integration test to ensure command reliability ([issue #2241](https://github.com/dsccommunity/SqlServerDsc/issues/2241)).
- Added integration tests for `Test-SqlDscIsRole` command to ensure it functions
correctly in real environments
[issue #2229](https://github.com/dsccommunity/SqlServerDsc/issues/2229).
- Added integration tests for `Add-SqlDscTraceFlag` command to ensure it functions
correctly in real environments
[issue #2214](https://github.com/dsccommunity/SqlServerDsc/issues/2214).
- `Set-SqlDscAudit`
- Added `AllowAuditGuidChange` parameter to enable modifying the audit GUID
by dropping and recreating the audit with the new GUID. This parameter is
required when changing the `AuditGuid` property because SQL Server does not
allow direct modification of the audit GUID ([issue #2287](https://github.com/dsccommunity/SqlServerDsc/issues/2287)).
- `Save-SqlDscSqlServerMediaFile`
- Fixed the Force parameter to work correctly when the target ISO file already
exists. The command now properly overwrites the target file when Force is
specified. Removed the safety check that was incorrectly blocking execution
when other ISO files existed in the destination directory
([issue #2280](https://github.com/dsccommunity/SqlServerDsc/issues/2280)).
- `DSC_SqlRS`
- Fixed intermittent initialization failures on resource-constrained systems
(particularly Windows Server 2025 in CI) by adding an optional `RestartTimeout`
parameter that allows specifying a wait period (in seconds) after service
restart to allow Reporting Services to fully initialize before attempting
to get configuration data or run initialization methods. The timeout is applied
both after the initial service restart and before calling `InitializeReportServer()`
if needed, giving the WMI provider sufficient time to be ready. When not specified,
no additional wait time is applied, maintaining backward compatibility.
- `New-SqlDscAudit`
- Fixed parameter validation to prevent the `ReserveDiskSpace` parameter from
being used with the `FileWithMaxFiles` parameter set (when only `MaximumFiles`
is specified without `MaximumFileSize`). This combination always resulted in
a SQL Server error because `RESERVE_DISK_SPACE` cannot be specified when
`MAXSIZE = UNLIMITED`. The `ReserveDiskSpace` parameter now correctly requires
both `MaximumFiles` and `MaximumFileSize` to be specified
([issue #2289](https://github.com/dsccommunity/SqlServerDsc/issues/2289)).
- `Add-SqlDscTraceFlag` and `Remove-SqlDscTraceFlag`
- Fixed parameter binding error when `ErrorAction` was specified both
explicitly and via `PSBoundParameters` by using `Remove-CommonParameter`
instead of manual parameter removal
([issue #2239](https://github.com/dsccommunity/SqlServerDsc/issues/2239)).
- `Remove-SqlDscTraceFlag`
- Optimized to skip unnecessary Set operations when removal results in no
effective change
([issue #2239](https://github.com/dsccommunity/SqlServerDsc/issues/2239)).
- Updated `.gitattributes` to enforce LF line endings for PowerShell files to
ensure cross-platform compatibility.
### Changed
- `Add-SqlDscTraceFlag`
- Improved de-duplication logic to normalize element types to `[System.UInt32]`
before sorting and removing duplicates, ensuring proper handling of mixed
numeric types ([issue #2277](https://github.com/dsccommunity/SqlServerDsc/issues/2277)).
- Added idempotent behavior by comparing current and desired trace flags before
calling `Set-SqlDscTraceFlag`, skipping unnecessary writes when there are no
effective changes ([issue #2277](https://github.com/dsccommunity/SqlServerDsc/issues/2277)).
- Refactored integration tests to remove `finally` blocks from `It`-blocks and
use Pester `BeforeEach`/`AfterEach` blocks instead, following DSC Community
coding guidelines. This improves test cleanup reliability and maintainability
across the following test files ([issue #2288](https://g
FileList
- SqlServerDsc.nuspec
- DSCResources\DSC_SqlAG\DSC_SqlAG.psm1
- SqlServerDsc.psm1
- DSCResources\DSC_SqlAG\DSC_SqlAG.schema.mof
- SqlServerDsc.psd1
- DSCResources\DSC_SqlAG\README.md
- en-US\about_SqlPermission.help.txt
- DSCResources\DSC_SqlAGReplica\README.md
- en-US\about_SqlAgentAlert.help.txt
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.psm1
- en-US\SqlServerDsc-help.xml
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.schema.mof
- en-US\SqlServerDsc.strings.psd1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.schema.mof
- en-US\SqlDatabasePermission.strings.psd1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.psm1
- en-US\SqlAudit.strings.psd1
- DSCResources\DSC_SqlDatabase\README.md
- en-US\SqlResourceBase.strings.psd1
- DSCResources\DSC_SqlEndpoint\README.md
- en-US\SqlAgentAlert.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.schema.mof
- en-US\SqlPermission.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.psm1
- en-US\SqlRSSetup.strings.psd1
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.schema.mof
- en-US\about_SqlDatabasePermission.help.txt
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.psm1
- en-US\about_SqlAudit.help.txt
- DSCResources\DSC_SqlAlwaysOnService\README.md
- en-US\about_SqlRSSetup.help.txt
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psd1
- en-US\about_SqlServerDsc.help.txt
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psm1
- DSCResources\DSC_SqlScript\DSC_SqlScript.schema.mof
- DSCResources\DSC_SqlScript\en-US\about_SqlScript.help.txt
- DSCResources\DSC_SqlScript\README.md
- DSCResources\DSC_SqlScript\en-US\DSC_SqlScript.strings.psd1
- DSCResources\DSC_SqlScript\DSC_SqlScript.psm1
- DSCResources\DSC_SqlScriptQuery\en-US\about_SqlScriptQuery.help.txt
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.psm1
- DSCResources\DSC_SqlScriptQuery\en-US\DSC_SqlScriptQuery.strings.psd1
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.schema.mof
- DSCResources\DSC_SqlDatabaseMail\en-US\about_SqlDatabaseMail.help.txt
- DSCResources\DSC_SqlScriptQuery\README.md
- DSCResources\DSC_SqlDatabaseMail\en-US\DSC_SqlDatabaseMail.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.schema.mof
- DSCResources\DSC_SqlDatabaseRole\en-US\DSC_SqlDatabaseRole.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.psm1
- DSCResources\DSC_SqlDatabaseRole\en-US\about_SqlDatabaseRole.help.txt
- DSCResources\DSC_SqlDatabaseMail\README.md
- DSCResources\DSC_SqlRole\en-US\DSC_SqlRole.strings.psd1
- DSCResources\DSC_SqlDatabaseRole\README.md
- DSCResources\DSC_SqlRole\en-US\about_SqlRole.help.txt
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.psm1
- DSCResources\DSC_SqlMaxDop\en-US\DSC_SqlMaxDop.strings.psd1
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.schema.mof
- DSCResources\DSC_SqlMaxDop\en-US\about_SqlMaxDop.help.txt
- DSCResources\DSC_SqlRole\DSC_SqlRole.schema.mof
- DSCResources\DSC_SqlDatabaseUser\en-US\about_SqlDatabaseUser.help.txt
- DSCResources\DSC_SqlRole\README.md
- DSCResources\DSC_SqlDatabaseUser\en-US\DSC_SqlDatabaseUser.strings.psd1
- DSCResources\DSC_SqlRole\DSC_SqlRole.psm1
- DSCResources\DSC_SqlMemory\en-US\DSC_SqlMemory.strings.psd1
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.schema.mof
- DSCResources\DSC_SqlMemory\en-US\about_SqlMemory.help.txt
- DSCResources\DSC_SqlMaxDop\README.md
- DSCResources\DSC_SqlWindowsFirewall\en-US\about_SqlWindowsFirewall.help.txt
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.psm1
- DSCResources\DSC_SqlWindowsFirewall\en-US\DSC_SqlWindowsFirewall.strings.psd1
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.schema.mof
- DSCResources\DSC_SqlRS\en-US\about_SqlRS.help.txt
- DSCResources\DSC_SqlDatabaseUser\README.md
- DSCResources\DSC_SqlRS\en-US\DSC_SqlRS.strings.psd1
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.psm1
- DSCResources\DSC_SqlAgentFailsafe\en-US\about_SqlAgentFailsafe.help.txt
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.psm1
- DSCResources\DSC_SqlAgentFailsafe\en-US\DSC_SqlAgentFailsafe.strings.psd1
- DSCResources\DSC_SqlMemory\README.md
- DSCResources\DSC_SqlProtocol\en-US\about_SqlProtocol.help.txt
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.schema.mof
- DSCResources\DSC_SqlProtocol\en-US\DSC_SqlProtocol.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.schema.mof
- DSCResources\DSC_SqlSetup\en-US\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\README.md
- DSCResources\DSC_SqlSetup\en-US\about_SqlSetup.help.txt
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.psm1
- DSCResources\DSC_SqlSetup\sv-SE\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlRS\DSC_SqlRS.schema.mof
- DSCResources\DSC_SqlAgentOperator\en-US\about_SqlAgentOperator.help.txt
- DSCResources\DSC_SqlRS\README.md
- DSCResources\DSC_SqlAgentOperator\en-US\DSC_SqlAgentOperator.strings.psd1
- DSCResources\DSC_SqlRS\DSC_SqlRS.psm1
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\about_SqlDatabaseObjectPermission.help.txt
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.psm1
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\DSC_SqlDatabaseObjectPermission.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.schema.mof
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\DSC_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\README.md
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\about_SqlDatabaseDefaultLocation.help.txt
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.psm1
- DSCResources\DSC_SqlLogin\en-US\DSC_SqlLogin.strings.psd1
- DSCResources\DSC_SqlProtocol\README.md
- DSCResources\DSC_SqlLogin\en-US\about_SqlLogin.help.txt
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.schema.mof
- DSCResources\DSC_SqlSecureConnection\en-US\about_SqlSecureConnection.help.txt
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.psm1
- DSCResources\DSC_SqlSecureConnection\en-US\DSC_SqlSecureConnection.strings.psd1
- DSCResources\DSC_SqlSetup\README.md
- DSCResources\DSC_SqlAGListener\en-US\about_SqlAGListener.help.txt
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.schema.mof
- DSCResources\DSC_SqlAGListener\en-US\DSC_SqlAGListener.strings.psd1
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.schema.mof
- DSCResources\DSC_SqlEndpointPermission\en-US\DSC_SqlEndpointPermission.strings.psd1
- DSCResources\DSC_SqlAgentOperator\README.md
- DSCResources\DSC_SqlEndpointPermission\en-US\about_SqlEndpointPermission.help.txt
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.psm1
- DSCResources\DSC_SqlAGDatabase\en-US\DSC_SqlAGDatabase.strings.psd1
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.schema.mof
- DSCResources\DSC_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\README.md
- DSCResources\DSC_SqlWaitForAG\en-US\DSC_SqlWaitForAG.strings.psd1
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.psm1
- DSCResources\DSC_SqlWaitForAG\en-US\about_SqlWaitForAG.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\DSC_SqlReplication\en-US\DSC_SqlReplication.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\README.md
- DSCResources\DSC_SqlReplication\en-US\about_SqlReplication.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.psm1
- DSCResources\DSC_SqlAlias\en-US\DSC_SqlAlias.strings.psd1
- DSCResources\DSC_SqlLogin\README.md
- DSCResources\DSC_SqlAlias\en-US\about_SqlAlias.help.txt
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.schema.mof
- DSCResources\DSC_SqlTraceFlag\en-US\DSC_SqlTraceFlag.strings.psd1
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.psm1
- DSCResources\DSC_SqlTraceFlag\en-US\about_SqlTraceFlag.help.txt
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.psm1
- DSCResources\DSC_SqlServiceAccount\en-US\about_SqlServiceAccount.help.txt
- DSCResources\DSC_SqlSecureConnection\README.md
- DSCResources\DSC_SqlServiceAccount\en-US\DSC_SqlServiceAccount.strings.psd1
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.schema.mof
- DSCResources\DSC_SqlConfiguration\en-US\DSC_SqlConfiguration.strings.psd1
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.schema.mof
- DSCResources\DSC_SqlConfiguration\en-US\about_SqlConfiguration.help.txt
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.psm1
- DSCResources\DSC_SqlProtocolTcpIp\en-US\DSC_SqlProtocolTcpIp.strings.psd1
- DSCResources\DSC_SqlAGListener\README.md
- DSCResources\DSC_SqlProtocolTcpIp\en-US\about_SqlProtocolTcpIp.help.txt
- DSCResources\DSC_SqlEndpointPermission\README.md
- DSCResources\DSC_SqlAG\en-US\about_SqlAG.help.txt
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.schema.mof
- DSCResources\DSC_SqlAG\en-US\DSC_SqlAG.strings.psd1
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.psm1
- DSCResources\DSC_SqlAGReplica\en-US\DSC_SqlAGReplica.strings.psd1
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.psm1
- DSCResources\DSC_SqlAGReplica\en-US\about_SqlAGReplica.help.txt
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.schema.mof
- DSCResources\DSC_SqlDatabase\en-US\DSC_SqlDatabase.strings.psd1
- DSCResources\DSC_SqlAGDatabase\README.md
- DSCResources\DSC_SqlDatabase\en-US\about_SqlDatabase.help.txt
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.psm1
- DSCResources\DSC_SqlEndpoint\en-US\DSC_SqlEndpoint.strings.psd1
- DSCResources\DSC_SqlWaitForAG\README.md
- DSCResources\DSC_SqlEndpoint\en-US\about_SqlEndpoint.help.txt
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.schema.mof
- DSCResources\DSC_SqlAlwaysOnService\en-US\about_SqlAlwaysOnService.help.txt
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.psm1
- DSCResources\DSC_SqlAlwaysOnService\en-US\DSC_SqlAlwaysOnService.strings.psd1
- DSCResources\DSC_SqlReplication\README.md
- Modules\DscResource.Common\0.24.4\DscResource.Common.psd1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.schema.mof
- Modules\DscResource.Common\0.24.4\DscResource.Common.psm1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.psm1
- Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlAlias\README.md
- Modules\SqlServerDsc.Common\sv-SE\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.schema.mof
- Modules\DscResource.Base\1.4.0\DscResource.Base.psm1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.schema.mof
- Modules\DscResource.Base\1.4.0\DscResource.Base.psd1
- DSCResources\DSC_SqlTraceFlag\README.md
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.psm1
- Modules\DscResource.Common\0.24.4\en-US\about_DscResource.Common.help.txt
- DSCResources\DSC_SqlServiceAccount\README.md
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common.strings.psd1
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.schema.mof
- Modules\DscResource.Base\1.4.0\en-US\ResourceBase.strings.psd1
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.psm1
- Modules\DscResource.Base\1.4.0\en-US\about_DscResource.Base.help.txt
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.psm1
- Modules\DscResource.Base\1.4.0\en-US\DscResource.Base.strings.psd1
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.schema.mof
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psd1
- DSCResources\DSC_SqlConfiguration\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psm1
- DSCResources\DSC_SqlProtocolTcpIp\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.psm1
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\about_DscResource.Common.help.txt
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.schema.mof
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\DscResource.Common.strings.psd1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 17.3.0-previ... (current version) | 11 | 10/12/2025 |
| 17.3.0-previ... | 3 | 10/11/2025 |
| 17.3.0-previ... | 5 | 10/10/2025 |
| 17.3.0-previ... | 6 | 10/7/2025 |
| 17.3.0-previ... | 11 | 9/28/2025 |
| 17.3.0-previ... | 4 | 9/26/2025 |
| 17.3.0-previ... | 4 | 9/24/2025 |
| 17.3.0-previ... | 5 | 9/21/2025 |
| 17.2.0 | 101,246 | 9/16/2025 |
| 17.2.0-previ... | 3 | 9/15/2025 |
| 17.2.0-previ... | 6 | 9/13/2025 |
| 17.2.0-previ... | 5 | 9/12/2025 |
| 17.2.0-previ... | 13 | 9/7/2025 |
| 17.2.0-previ... | 5 | 9/6/2025 |
| 17.2.0-previ... | 5 | 9/6/2025 |
| 17.2.0-previ... | 10 | 9/1/2025 |
| 17.2.0-previ... | 4 | 8/31/2025 |
| 17.2.0-previ... | 4 | 8/31/2025 |
| 17.2.0-previ... | 5 | 8/30/2025 |
| 17.2.0-previ... | 5 | 8/30/2025 |
| 17.2.0-previ... | 4 | 8/29/2025 |
| 17.2.0-previ... | 15 | 8/25/2025 |
| 17.2.0-previ... | 11 | 8/22/2025 |
| 17.2.0-previ... | 5 | 8/19/2025 |
| 17.2.0-previ... | 16 | 8/9/2025 |
| 17.2.0-previ... | 15 | 8/3/2025 |
| 17.1.0 | 519,651 | 5/22/2025 |
| 17.1.0-previ... | 27 | 5/2/2025 |
| 17.1.0-previ... | 6 | 5/1/2025 |
| 17.1.0-previ... | 37 | 4/7/2025 |
| 17.1.0-previ... | 7 | 4/6/2025 |
| 17.1.0-previ... | 7 | 4/4/2025 |
| 17.1.0-previ... | 44 | 3/24/2025 |
| 17.1.0-previ... | 14 | 3/19/2025 |
| 17.1.0-previ... | 12 | 3/13/2025 |
| 17.1.0-previ... | 8 | 3/12/2025 |
| 17.1.0-previ... | 5 | 3/11/2025 |
| 17.1.0-previ... | 30 | 3/4/2025 |
| 17.1.0-previ... | 9 | 3/2/2025 |
| 17.0.1-previ... | 106 | 10/29/2024 |
| 17.0.1-previ... | 8 | 10/26/2024 |
| 17.0.1-previ... | 17 | 10/7/2024 |
| 17.0.0 | 2,275,537 | 9/30/2024 |
| 17.0.0-previ... | 9 | 9/29/2024 |
| 17.0.0-previ... | 52 | 8/13/2024 |
| 16.6.1-previ... | 120 | 5/23/2024 |
| 16.6.1-previ... | 7 | 5/22/2024 |
| 16.6.0 | 92,994 | 5/17/2024 |
| 16.6.0-previ... | 12 | 5/12/2024 |
| 16.6.0-previ... | 6 | 5/11/2024 |
| 16.6.0-previ... | 112 | 3/3/2024 |
| 16.6.0-previ... | 48 | 1/20/2024 |
| 16.6.0-previ... | 8 | 1/19/2024 |
| 16.5.1-previ... | 70 | 12/15/2023 |
| 16.5.1-previ... | 93 | 11/19/2023 |
| 16.5.1-previ... | 49 | 11/2/2023 |
| 16.5.0 | 145,940 | 10/5/2023 |
| 16.5.0-previ... | 15 | 10/1/2023 |
| 16.5.0-previ... | 10 | 9/29/2023 |
| 16.5.0-previ... | 51 | 9/1/2023 |
| 16.5.0-previ... | 9 | 8/26/2023 |
| 16.4.1-previ... | 8 | 8/25/2023 |
| 16.4.0 | 111,831 | 8/22/2023 |
| 16.4.0-previ... | 7 | 8/20/2023 |
| 16.4.0-previ... | 7 | 8/20/2023 |
| 16.4.0-previ... | 7 | 8/19/2023 |
| 16.4.0-previ... | 78 | 5/18/2023 |
| 16.4.0-previ... | 22 | 5/10/2023 |
| 16.4.0-previ... | 8 | 5/9/2023 |
| 16.4.0-previ... | 10 | 5/8/2023 |
| 16.3.1 | 460,779 | 5/6/2023 |
| 16.3.1-previ... | 7 | 5/6/2023 |
| 16.3.1-previ... | 11 | 5/4/2023 |
| 16.3.0 | 42,400 | 4/26/2023 |
| 16.3.0-previ... | 10 | 4/26/2023 |
| 16.3.0-previ... | 9 | 4/25/2023 |
| 16.3.0-previ... | 8 | 4/24/2023 |
| 16.3.0-previ... | 7 | 4/23/2023 |
| 16.3.0-previ... | 30 | 4/18/2023 |
| 16.3.0-previ... | 9 | 4/16/2023 |
| 16.2.1-previ... | 10 | 4/12/2023 |
| 16.2.0 | 75,344 | 4/10/2023 |
| 16.2.0-previ... | 8 | 4/10/2023 |
| 16.2.0-previ... | 7 | 4/8/2023 |
| 16.2.0-previ... | 7 | 4/8/2023 |
| 16.2.0-previ... | 12 | 4/6/2023 |
| 16.2.0-previ... | 13 | 4/1/2023 |
| 16.2.0-previ... | 14 | 3/28/2023 |
| 16.2.0-previ... | 12 | 3/26/2023 |
| 16.2.0-previ... | 7 | 3/25/2023 |
| 16.2.0-previ... | 173 | 3/19/2023 |
| 16.2.0-previ... | 29 | 3/7/2023 |
| 16.2.0-previ... | 11 | 3/4/2023 |
| 16.1.0 | 175,785 | 2/28/2023 |
| 16.1.0-previ... | 7 | 2/28/2023 |
| 16.1.0-previ... | 10 | 2/25/2023 |
| 16.1.0-previ... | 10 | 2/24/2023 |
| 16.1.0-previ... | 50 | 2/13/2023 |
| 16.1.0-previ... | 30 | 2/12/2023 |
| 16.1.0-previ... | 27 | 2/5/2023 |
| 16.1.0-previ... | 14 | 2/1/2023 |
| 16.1.0-previ... | 31 | 1/25/2023 |
| 16.1.0-previ... | 10 | 1/24/2023 |
| 16.1.0-previ... | 7 | 1/24/2023 |
| 16.1.0-previ... | 14 | 1/22/2023 |
| 16.1.0-previ... | 347 | 1/4/2023 |
| 16.1.0-previ... | 8 | 1/3/2023 |
| 16.1.0-previ... | 17 | 12/26/2022 |
| 16.1.0-previ... | 52 | 12/19/2022 |
| 16.1.0-previ... | 15 | 12/17/2022 |
| 16.1.0-previ... | 117 | 12/11/2022 |
| 16.1.0-previ... | 16 | 12/4/2022 |
| 16.1.0-previ... | 39 | 11/26/2022 |
| 16.1.0-previ... | 14 | 11/24/2022 |
| 16.0.1-previ... | 33 | 11/11/2022 |
| 16.0.0 | 828,416 | 9/9/2022 |
| 16.0.0-previ... | 32 | 8/21/2022 |
| 16.0.0-previ... | 26 | 8/13/2022 |
| 16.0.0-previ... | 18 | 8/13/2022 |
| 16.0.0-previ... | 27 | 8/1/2022 |
| 16.0.0-previ... | 84 | 6/14/2022 |
| 16.0.0-previ... | 27 | 6/8/2022 |
| 16.0.0-previ... | 19 | 6/6/2022 |
| 16.0.0-previ... | 17 | 6/6/2022 |
| 16.0.0-previ... | 92 | 4/26/2022 |
| 16.0.0-previ... | 46 | 3/28/2022 |
| 16.0.0-previ... | 68 | 2/12/2022 |
| 15.2.0 | 2,685,762 | 9/1/2021 |
| 15.2.0-previ... | 20 | 9/1/2021 |
| 15.2.0-previ... | 46 | 7/23/2021 |
| 15.2.0-previ... | 77 | 6/6/2021 |
| 15.2.0-previ... | 70 | 4/18/2021 |
| 15.2.0-previ... | 88 | 3/12/2021 |
| 15.1.1 | 1,446,962 | 2/12/2021 |
| 15.1.1-previ... | 20 | 2/12/2021 |
| 15.1.0 | 62,665 | 2/2/2021 |
| 15.1.0-previ... | 27 | 2/1/2021 |
| 15.1.0-previ... | 22 | 1/31/2021 |
| 15.0.2-previ... | 21 | 1/30/2021 |
| 15.0.2-previ... | 27 | 1/24/2021 |
| 15.0.2-previ... | 66 | 1/21/2021 |
| 15.0.2-previ... | 65 | 1/12/2021 |
| 15.0.1 | 143,085 | 1/9/2021 |
| 15.0.1-previ... | 62 | 1/9/2021 |
| 15.0.1-previ... | 67 | 1/6/2021 |
| 15.0.1-previ... | 63 | 1/6/2021 |
| 15.0.1-previ... | 72 | 12/27/2020 |
| 15.0.1-previ... | 64 | 12/26/2020 |
| 15.0.1-previ... | 66 | 12/23/2020 |
| 15.0.1-previ... | 73 | 12/14/2020 |
| 15.0.1-previ... | 65 | 12/13/2020 |
| 15.0.1-previ... | 64 | 12/12/2020 |
| 15.0.1-previ... | 64 | 12/10/2020 |
| 15.0.0 | 214,908 | 12/6/2020 |
| 15.0.0-previ... | 64 | 12/6/2020 |
| 15.0.0-previ... | 69 | 11/25/2020 |
| 15.0.0-previ... | 61 | 11/22/2020 |
| 15.0.0-previ... | 65 | 11/21/2020 |
| 14.3.0-previ... | 102 | 10/5/2020 |
| 14.3.0-previ... | 57 | 10/3/2020 |
| 14.3.0-previ... | 64 | 10/2/2020 |
| 14.2.2-previ... | 108 | 8/19/2020 |
| 14.2.2-previ... | 65 | 8/16/2020 |
| 14.2.1 | 650,033 | 8/14/2020 |
| 14.2.1-previ... | 62 | 8/13/2020 |
| 14.2.1-previ... | 64 | 8/11/2020 |
| 14.2.1-previ... | 60 | 8/11/2020 |
| 14.2.1-previ... | 76 | 7/31/2020 |
| 14.2.1-previ... | 63 | 7/28/2020 |
| 14.2.0 | 72,790 | 7/23/2020 |
| 14.2.0-previ... | 66 | 7/23/2020 |
| 14.2.0-previ... | 68 | 7/19/2020 |
| 14.2.0-previ... | 77 | 7/13/2020 |
| 14.2.0-previ... | 68 | 7/10/2020 |
| 14.2.0-previ... | 65 | 7/9/2020 |
| 14.1.1-previ... | 66 | 7/9/2020 |
| 14.1.0 | 221,834 | 7/6/2020 |
| 14.1.0-previ... | 372 | 7/5/2020 |
| 14.1.0-previ... | 64 | 7/4/2020 |
| 14.1.0-previ... | 65 | 7/4/2020 |
| 14.1.0-previ... | 66 | 7/3/2020 |
| 14.1.0-previ... | 69 | 7/1/2020 |
| 14.0.1-previ... | 75 | 6/28/2020 |
| 14.0.1-previ... | 65 | 6/26/2020 |
| 14.0.0 | 10,853 | 6/12/2020 |
| 14.0.0-previ... | 66 | 6/12/2020 |
| 14.0.0-previ... | 71 | 6/11/2020 |
| 14.0.0-previ... | 74 | 6/10/2020 |
| 14.0.0-previ... | 73 | 6/10/2020 |
| 14.0.0-previ... | 106 | 5/28/2020 |
| 14.0.0-previ... | 80 | 5/25/2020 |
| 14.0.0-previ... | 72 | 5/25/2020 |
| 14.0.0-previ... | 83 | 5/19/2020 |
| 14.0.0-previ... | 79 | 5/19/2020 |
| 14.0.0-previ... | 85 | 5/17/2020 |
| 14.0.0-previ... | 74 | 5/17/2020 |
| 14.0.0-previ... | 72 | 5/16/2020 |
| 14.0.0-previ... | 73 | 5/14/2020 |
| 14.0.0-previ... | 75 | 5/13/2020 |
| 14.0.0-previ... | 82 | 5/12/2020 |
| 14.0.0-previ... | 72 | 5/12/2020 |
| 14.0.0-previ... | 73 | 5/12/2020 |
| 14.0.0-previ... | 86 | 5/8/2020 |
| 14.0.0-previ... | 71 | 5/6/2020 |
| 14.0.0-previ... | 77 | 5/5/2020 |
| 14.0.0-previ... | 73 | 5/4/2020 |
| 14.0.0-previ... | 73 | 5/3/2020 |
| 14.0.0-previ... | 72 | 5/3/2020 |
| 14.0.0-previ... | 86 | 4/27/2020 |
| 14.0.0-previ... | 82 | 4/26/2020 |
| 13.5.0 | 28,496 | 4/12/2020 |
| 13.5.0-previ... | 79 | 4/11/2020 |
| 13.5.0-previ... | 82 | 4/11/2020 |
| 13.4.1-previ... | 108 | 3/31/2020 |
| 13.4.0 | 122,355 | 3/18/2020 |
| 13.4.0-previ... | 76 | 3/18/2020 |
| 13.3.1-previ... | 120 | 1/18/2020 |
| 13.3.0 | 481,337 | 1/17/2020 |
| 13.3.0-previ... | 78 | 1/17/2020 |
| 13.3.0-previ... | 82 | 1/12/2020 |
| 13.3.0-previ... | 77 | 1/8/2020 |
| 13.3.0-previ... | 78 | 1/7/2020 |
| 13.3.0-previ... | 77 | 1/3/2020 |
| 13.3.0-previ... | 77 | 1/2/2020 |
| 13.3.0-previ... | 78 | 1/2/2020 |
| 13.2.0.0 | 863,012 | 9/19/2019 |
| 13.1.0.0 | 35,051 | 8/8/2019 |
| 13.0.0.0 | 26,094 | 6/26/2019 |
| 12.5.0.0 | 17,606 | 5/15/2019 |
| 12.4.0.0 | 21,809 | 4/3/2019 |
| 12.3.0.0 | 40,238 | 2/20/2019 |
| 12.2.0.0 | 9,113 | 1/10/2019 |
| 12.1.0.0 | 23,379 | 10/25/2018 |
| 12.0.0.0 | 21,451 | 9/5/2018 |
| 11.4.0.0 | 16,164 | 7/25/2018 |
| 11.3.0.0 | 7,394 | 6/13/2018 |
| 11.2.0.0 | 5,673 | 5/2/2018 |
| 11.1.0.0 | 6,264 | 3/22/2018 |
| 11.0.0.0 | 13,553 | 2/8/2018 |
| 10.0.0.0 | 3,656 | 12/14/2017 |