SqlServerDsc
17.3.0-preview0010
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-preview0010] - 2025-10-20
### Added
- Added script `Remove-SqlServerFromCIImage.ps1` to remove pre-installed SQL Server
components from Microsoft Hosted agents that conflict with PrepareImage operations.
The script is now run automatically in the CI pipeline before PrepareImage tests
to resolve Sysprep compatibility errors [issue #2212](https://github.com/dsccommunity/SqlServerDsc/issues/2212).
- Added integration tests for `Complete-SqlDscImage` command to ensure command
reliability in prepared image installation workflows. The test runs in a separate
pipeline job `Integration_Test_Commands_SqlServer_PreparedImage` with its own CI
worker, and verifies the completion of SQL Server instances prepared using
`Install-SqlDscServer` with the `-PrepareImage` parameter. The test includes
scenarios with minimal parameters and various service account/directory
configurations [issue #2212](https://github.com/dsccommunity/SqlServerDsc/issues/2212).
- Added integration test for `Install-SqlDscServer` with the `-PrepareImage`
parameter set to support the prepared image installation workflow. This test
(`Install-SqlDscServer.Integration.PrepareImage.Tests.ps1`) runs in the
`Integration_Test_Commands_SqlServer_PreparedImage` pipeline job and prepares
a DSCSQLTEST instance that is later completed by `Complete-SqlDscImage` tests
[issue #2212](https://github.com/dsccommunity/SqlServerDsc/issues/2212).
- Added integration tests for `Initialize-SqlDscRebuildDatabase` command to ensure
command reliability. The test runs in group 8, alongside `Repair-SqlDscServer`,
to verify the rebuild database functionality on the DSCSQLTEST instance
[issue #2242](https://github.com/dsccommunity/SqlServerDsc/issues/2242).
- Added integration tests for `Repair-SqlDscServer` command to ensure command
reliability. The test runs in group 8, before `Uninstall-SqlDscServer` in
group 9, to verify the repair functionality on the DSCSQLTEST instance
[issue #2238](https://github.com/dsccommunity/SqlServerDsc/issues/2238).
- Added integration tests for `ConvertTo-SqlDscServerPermission` command to ensure
command reliability [issue #2207](https://github.com/dsccommunity/SqlServerDsc/issues/2207).
- Added post-installation configuration integration test to configure SSL certificate
support for SQL Server instance DSCSQLTEST in CI environment, enabling testing
of encryption-related functionality. The new `PostInstallationConfiguration`
integration test includes:
- Self-signed SSL certificate creation and installation
- Certificate configuration for SQL Server Database Engine
- Service account permissions for certificate private key access
- Certificate trust chain configuration
- Verification that encryption is properly configured
- Enabled previously skipped encryption tests in `Invoke-SqlDscQuery`
- Added integration tests for `Connect-SqlDscDatabaseEngine` command to verify
the `-Encrypt` parameter functionality
[issue #2290](https://github.com/dsccommunity/SqlServerDsc/issues/2290).
- 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
- `Repair-SqlDscServer`
- Removed the `Features` parameter from the command as SQL Server Repair action
does not accept the `/FEATURES` parameter. SQL Server automatically repairs
all installed features when using the Repair action. This fixes the error
"The setting 'FEATURES' is not allowed when the value of setting 'ACTION'
is 'Repair'." that occurred when attempting to repair a SQL Server instance
[issue #2238](https://github.com/dsccommunity/SqlServerDsc/issues/2238).
- 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/
FileList
- SqlServerDsc.nuspec
- DSCResources\DSC_SqlAG\DSC_SqlAG.psm1
- DSCResources\DSC_SqlAG\DSC_SqlAG.schema.mof
- SqlServerDsc.psm1
- DSCResources\DSC_SqlAG\README.md
- SqlServerDsc.psd1
- DSCResources\DSC_SqlAGReplica\README.md
- en-US\about_SqlPermission.help.txt
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.psm1
- en-US\about_SqlAgentAlert.help.txt
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.schema.mof
- en-US\SqlServerDsc-help.xml
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.schema.mof
- en-US\SqlServerDsc.strings.psd1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.psm1
- en-US\SqlDatabasePermission.strings.psd1
- DSCResources\DSC_SqlDatabase\README.md
- en-US\SqlAudit.strings.psd1
- DSCResources\DSC_SqlEndpoint\README.md
- en-US\SqlResourceBase.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.schema.mof
- en-US\SqlAgentAlert.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.psm1
- en-US\SqlPermission.strings.psd1
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.schema.mof
- en-US\SqlRSSetup.strings.psd1
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.psm1
- en-US\about_SqlDatabasePermission.help.txt
- DSCResources\DSC_SqlAlwaysOnService\README.md
- en-US\about_SqlAudit.help.txt
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psd1
- en-US\about_SqlRSSetup.help.txt
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psm1
- en-US\about_SqlServerDsc.help.txt
- DSCResources\DSC_SqlScript\en-US\about_SqlScript.help.txt
- DSCResources\DSC_SqlScript\DSC_SqlScript.schema.mof
- DSCResources\DSC_SqlScript\en-US\DSC_SqlScript.strings.psd1
- DSCResources\DSC_SqlScript\README.md
- DSCResources\DSC_SqlScriptQuery\en-US\about_SqlScriptQuery.help.txt
- DSCResources\DSC_SqlScript\DSC_SqlScript.psm1
- DSCResources\DSC_SqlScriptQuery\en-US\DSC_SqlScriptQuery.strings.psd1
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.psm1
- DSCResources\DSC_SqlDatabaseMail\en-US\about_SqlDatabaseMail.help.txt
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.schema.mof
- DSCResources\DSC_SqlDatabaseMail\en-US\DSC_SqlDatabaseMail.strings.psd1
- DSCResources\DSC_SqlScriptQuery\README.md
- DSCResources\DSC_SqlDatabaseRole\en-US\DSC_SqlDatabaseRole.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.schema.mof
- DSCResources\DSC_SqlDatabaseRole\en-US\about_SqlDatabaseRole.help.txt
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.psm1
- DSCResources\DSC_SqlRole\en-US\DSC_SqlRole.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\README.md
- DSCResources\DSC_SqlRole\en-US\about_SqlRole.help.txt
- DSCResources\DSC_SqlDatabaseRole\README.md
- DSCResources\DSC_SqlMaxDop\en-US\DSC_SqlMaxDop.strings.psd1
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.psm1
- DSCResources\DSC_SqlMaxDop\en-US\about_SqlMaxDop.help.txt
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.schema.mof
- DSCResources\DSC_SqlDatabaseUser\en-US\about_SqlDatabaseUser.help.txt
- DSCResources\DSC_SqlRole\DSC_SqlRole.schema.mof
- DSCResources\DSC_SqlDatabaseUser\en-US\DSC_SqlDatabaseUser.strings.psd1
- DSCResources\DSC_SqlRole\README.md
- DSCResources\DSC_SqlMemory\en-US\DSC_SqlMemory.strings.psd1
- DSCResources\DSC_SqlRole\DSC_SqlRole.psm1
- DSCResources\DSC_SqlMemory\en-US\about_SqlMemory.help.txt
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.schema.mof
- DSCResources\DSC_SqlWindowsFirewall\en-US\about_SqlWindowsFirewall.help.txt
- DSCResources\DSC_SqlMaxDop\README.md
- DSCResources\DSC_SqlWindowsFirewall\en-US\DSC_SqlWindowsFirewall.strings.psd1
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.psm1
- DSCResources\DSC_SqlRS\en-US\about_SqlRS.help.txt
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.schema.mof
- DSCResources\DSC_SqlRS\en-US\DSC_SqlRS.strings.psd1
- DSCResources\DSC_SqlDatabaseUser\README.md
- DSCResources\DSC_SqlAgentFailsafe\en-US\about_SqlAgentFailsafe.help.txt
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.psm1
- DSCResources\DSC_SqlAgentFailsafe\en-US\DSC_SqlAgentFailsafe.strings.psd1
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.psm1
- DSCResources\DSC_SqlProtocol\en-US\about_SqlProtocol.help.txt
- DSCResources\DSC_SqlMemory\README.md
- DSCResources\DSC_SqlProtocol\en-US\DSC_SqlProtocol.strings.psd1
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.schema.mof
- DSCResources\DSC_SqlSetup\en-US\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.schema.mof
- DSCResources\DSC_SqlSetup\en-US\about_SqlSetup.help.txt
- DSCResources\DSC_SqlWindowsFirewall\README.md
- DSCResources\DSC_SqlSetup\sv-SE\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.psm1
- DSCResources\DSC_SqlAgentOperator\en-US\about_SqlAgentOperator.help.txt
- DSCResources\DSC_SqlRS\DSC_SqlRS.schema.mof
- DSCResources\DSC_SqlAgentOperator\en-US\DSC_SqlAgentOperator.strings.psd1
- DSCResources\DSC_SqlRS\README.md
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\about_SqlDatabaseObjectPermission.help.txt
- DSCResources\DSC_SqlRS\DSC_SqlRS.psm1
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\DSC_SqlDatabaseObjectPermission.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.psm1
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\DSC_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.schema.mof
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\about_SqlDatabaseDefaultLocation.help.txt
- DSCResources\DSC_SqlAgentFailsafe\README.md
- DSCResources\DSC_SqlLogin\en-US\DSC_SqlLogin.strings.psd1
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.psm1
- DSCResources\DSC_SqlLogin\en-US\about_SqlLogin.help.txt
- DSCResources\DSC_SqlProtocol\README.md
- DSCResources\DSC_SqlSecureConnection\en-US\about_SqlSecureConnection.help.txt
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.schema.mof
- DSCResources\DSC_SqlSecureConnection\en-US\DSC_SqlSecureConnection.strings.psd1
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.psm1
- DSCResources\DSC_SqlAGListener\en-US\about_SqlAGListener.help.txt
- DSCResources\DSC_SqlSetup\README.md
- DSCResources\DSC_SqlAGListener\en-US\DSC_SqlAGListener.strings.psd1
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.schema.mof
- DSCResources\DSC_SqlEndpointPermission\en-US\DSC_SqlEndpointPermission.strings.psd1
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.schema.mof
- DSCResources\DSC_SqlEndpointPermission\en-US\about_SqlEndpointPermission.help.txt
- DSCResources\DSC_SqlAgentOperator\README.md
- DSCResources\DSC_SqlAGDatabase\en-US\DSC_SqlAGDatabase.strings.psd1
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.psm1
- DSCResources\DSC_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.schema.mof
- DSCResources\DSC_SqlWaitForAG\en-US\DSC_SqlWaitForAG.strings.psd1
- DSCResources\DSC_SqlDatabaseObjectPermission\README.md
- DSCResources\DSC_SqlWaitForAG\en-US\about_SqlWaitForAG.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.psm1
- DSCResources\DSC_SqlReplication\en-US\DSC_SqlReplication.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\DSC_SqlReplication\en-US\about_SqlReplication.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\README.md
- DSCResources\DSC_SqlAlias\en-US\DSC_SqlAlias.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.psm1
- DSCResources\DSC_SqlAlias\en-US\about_SqlAlias.help.txt
- DSCResources\DSC_SqlLogin\README.md
- DSCResources\DSC_SqlTraceFlag\en-US\DSC_SqlTraceFlag.strings.psd1
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.schema.mof
- DSCResources\DSC_SqlTraceFlag\en-US\about_SqlTraceFlag.help.txt
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.psm1
- DSCResources\DSC_SqlServiceAccount\en-US\about_SqlServiceAccount.help.txt
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.psm1
- DSCResources\DSC_SqlServiceAccount\en-US\DSC_SqlServiceAccount.strings.psd1
- DSCResources\DSC_SqlSecureConnection\README.md
- DSCResources\DSC_SqlConfiguration\en-US\DSC_SqlConfiguration.strings.psd1
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.schema.mof
- DSCResources\DSC_SqlConfiguration\en-US\about_SqlConfiguration.help.txt
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.schema.mof
- DSCResources\DSC_SqlProtocolTcpIp\en-US\DSC_SqlProtocolTcpIp.strings.psd1
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.psm1
- DSCResources\DSC_SqlProtocolTcpIp\en-US\about_SqlProtocolTcpIp.help.txt
- DSCResources\DSC_SqlAGListener\README.md
- DSCResources\DSC_SqlAG\en-US\about_SqlAG.help.txt
- DSCResources\DSC_SqlEndpointPermission\README.md
- DSCResources\DSC_SqlAG\en-US\DSC_SqlAG.strings.psd1
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.schema.mof
- DSCResources\DSC_SqlAGReplica\en-US\DSC_SqlAGReplica.strings.psd1
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.psm1
- DSCResources\DSC_SqlAGReplica\en-US\about_SqlAGReplica.help.txt
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.psm1
- DSCResources\DSC_SqlDatabase\en-US\DSC_SqlDatabase.strings.psd1
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.schema.mof
- DSCResources\DSC_SqlDatabase\en-US\about_SqlDatabase.help.txt
- DSCResources\DSC_SqlAGDatabase\README.md
- DSCResources\DSC_SqlEndpoint\en-US\DSC_SqlEndpoint.strings.psd1
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.psm1
- DSCResources\DSC_SqlEndpoint\en-US\about_SqlEndpoint.help.txt
- DSCResources\DSC_SqlWaitForAG\README.md
- DSCResources\DSC_SqlAlwaysOnService\en-US\about_SqlAlwaysOnService.help.txt
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.schema.mof
- DSCResources\DSC_SqlAlwaysOnService\en-US\DSC_SqlAlwaysOnService.strings.psd1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.psm1
- Modules\DscResource.Common\0.24.4\DscResource.Common.psd1
- DSCResources\DSC_SqlReplication\README.md
- Modules\DscResource.Common\0.24.4\DscResource.Common.psm1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.schema.mof
- Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.psm1
- Modules\SqlServerDsc.Common\sv-SE\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlAlias\README.md
- Modules\DscResource.Base\1.4.0\DscResource.Base.psm1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.schema.mof
- Modules\DscResource.Base\1.4.0\DscResource.Base.psd1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.schema.mof
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlTraceFlag\README.md
- Modules\DscResource.Common\0.24.4\en-US\about_DscResource.Common.help.txt
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.psm1
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common.strings.psd1
- DSCResources\DSC_SqlServiceAccount\README.md
- Modules\DscResource.Base\1.4.0\en-US\ResourceBase.strings.psd1
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.schema.mof
- Modules\DscResource.Base\1.4.0\en-US\about_DscResource.Base.help.txt
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.psm1
- Modules\DscResource.Base\1.4.0\en-US\DscResource.Base.strings.psd1
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.psm1
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psd1
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.schema.mof
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psm1
- DSCResources\DSC_SqlConfiguration\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlProtocolTcpIp\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\about_DscResource.Common.help.txt
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.psm1
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\DscResource.Common.strings.psd1
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.schema.mof
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 17.3.0-previ... (current version) | 3 | 10/21/2025 |
| 17.3.0-previ... | 9 | 10/15/2025 |
| 17.3.0-previ... | 12 | 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 | 132,849 | 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,718 | 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,344,328 | 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 | 93,101 | 5/17/2024 |
| 16.6.0-previ... | 12 | 5/12/2024 |
| 16.6.0-previ... | 6 | 5/11/2024 |
| 16.6.0-previ... | 117 | 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,946 | 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,834 | 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,793 | 5/6/2023 |
| 16.3.1-previ... | 7 | 5/6/2023 |
| 16.3.1-previ... | 11 | 5/4/2023 |
| 16.3.0 | 42,408 | 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,348 | 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,791 | 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,429 | 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,788 | 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,447,570 | 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,266 | 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,498 | 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,347 | 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,013 | 9/19/2019 |
| 13.1.0.0 | 35,054 | 8/8/2019 |
| 13.0.0.0 | 26,094 | 6/26/2019 |
| 12.5.0.0 | 17,608 | 5/15/2019 |
| 12.4.0.0 | 21,814 | 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,463 | 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,677 | 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 |