SqlServerDsc
17.3.0-preview0015
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-SqlDscCompatibilityLevel 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-SqlDscSetupLog 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-SqlDscDatabaseDefault Set-SqlDscDatabaseOwner Set-SqlDscDatabasePermission Set-SqlDscDatabaseProperty Set-SqlDscServerPermission Set-SqlDscStartupParameter Set-SqlDscTraceFlag Test-SqlDscAgentAlertProperty Test-SqlDscConfigurationOption Test-SqlDscDatabaseProperty Test-SqlDscIsAgentAlert Test-SqlDscIsAgentOperator Test-SqlDscIsDatabase 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-preview0015] - 2025-10-31
### Removed
- BREAKING CHANGE: Removed public command `Test-SqlDscDatabase`. Use
`Test-SqlDscIsDatabase` to check existence. For property checks, use
`Test-SqlDscDatabaseProperty`. See [issue #2201](https://github.com/dsccommunity/SqlServerDsc/issues/2201).
- BREAKING CHANGE: `Set-SqlDscDatabase`
- Removed parameter `OwnerName` [issue #2177](https://github.com/dsccommunity/SqlServerDsc/issues/2177).
Use the new command `Set-SqlDscDatabaseOwner` to change database ownership instead.
- BREAKING CHANGE: `Set-SqlDscDatabaseProperty`
- Removed parameters `AzureEdition` and `AzureServiceObjective`. Azure SQL Database
service tier and SLO changes should be managed using `Set-AzSqlDatabase` from the
Azure PowerShell module instead. See [issue #2177](https://github.com/dsccommunity/SqlServerDsc/issues/2177).
### Added
- Added public command `Set-SqlDscDatabaseOwner` to change the owner of a SQL Server
database [issue #2177](https://github.com/dsccommunity/SqlServerDsc/issues/2177).
This command uses the SMO `SetOwner()` method and supports both `ServerObject`
and `DatabaseObject` parameter sets. This replaces the ownership changes
previously done via the `OwnerName` parameter in `Set-SqlDscDatabase`.
- Added public command `Test-SqlDscIsDatabase` to test if a database exists on a
SQL Server Database Engine instance ([issue #2201](https://github.com/dsccommunity/SqlServerDsc/issues/2201)).
- Added public command `Get-SqlDscSetupLog` to retrieve SQL Server setup bootstrap
logs (Summary.txt) from the most recent setup operation. This command can be used
interactively for troubleshooting or within integration tests to help diagnose
setup failures. Integration tests have been updated to use this command instead
of duplicated error handling code [issue #2311](https://github.com/dsccommunity/SqlServerDsc/issues/2311).
- 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).
- Added public command `Test-SqlDscDatabaseProperty` to test database properties
on SQL Server Database Engine instances. This command supports two parameter sets:
`ServerObject` with **DatabaseName**, and `DatabaseObject` (from `Get-SqlDscDatabase`).
It allows users to specify any non-collection properties of the SMO Database object
as dynamic parameters to test, returning `$true` if all tested properties match
their expected values, and `$false` otherwise. This command improves maintainability
of SQL DSC resources and provides granular database configuration testing
[issue #2306](https://github.com/dsccommunity/SqlServerDsc/issues/2306).
### Fixed
- `SqlRS`
- Obtain the Reporting service name from WMI for version 14 and higher.
[issue #2313](https://github.com/dsccommunity/SqlServerDsc/issues/2313)
- `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).
- Updated unit test assertion in `Get-SqlDscSetupLog.Tests.ps1` to use
`Should -BeFalse` instead of `Should -Contain $false` to comply with DSC
Community Pester style guidelines
[issue #2315](https://github.com/dsccommunity/SqlServerDsc/issues/2315).
- 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
reliab
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) | 2 | 10/31/2025 |
| 17.3.0-previ... | 2 | 10/31/2025 |
| 17.3.0-previ... | 8 | 10/26/2025 |
| 17.3.0-previ... | 4 | 10/24/2025 |
| 17.3.0-previ... | 8 | 10/22/2025 |
| 17.3.0-previ... | 4 | 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 | 177,752 | 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,743 | 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,441,231 | 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,245 | 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,955 | 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,836 | 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,832 | 5/6/2023 |
| 16.3.1-previ... | 7 | 5/6/2023 |
| 16.3.1-previ... | 11 | 5/4/2023 |
| 16.3.0 | 42,412 | 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,351 | 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,463 | 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,834 | 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,448,712 | 2/12/2021 |
| 15.1.1-previ... | 20 | 2/12/2021 |
| 15.1.0 | 62,667 | 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,086 | 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,347 | 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,792 | 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,835 | 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,499 | 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,358 | 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,033 | 9/19/2019 |
| 13.1.0.0 | 35,057 | 8/8/2019 |
| 13.0.0.0 | 26,094 | 6/26/2019 |
| 12.5.0.0 | 17,610 | 5/15/2019 |
| 12.4.0.0 | 21,823 | 4/3/2019 |
| 12.3.0.0 | 40,238 | 2/20/2019 |
| 12.2.0.0 | 9,115 | 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,693 | 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 |