SqlServerDsc
17.3.0-preview0020
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-SqlDscFileGroup Add-SqlDscNode Add-SqlDscTraceFlag Assert-SqlDscAgentOperator Assert-SqlDscLogin Complete-SqlDscFailoverCluster Complete-SqlDscImage Connect-SqlDscDatabaseEngine ConvertFrom-SqlDscDatabasePermission ConvertFrom-SqlDscServerPermission ConvertTo-SqlDscDatabasePermission ConvertTo-SqlDscDataFile ConvertTo-SqlDscEditionName ConvertTo-SqlDscFileGroup 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-SqlDscDatabaseSnapshot New-SqlDscDataFile New-SqlDscFileGroup 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-preview0020] - 2025-11-24
### 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).
- Removed parameter `DatabaseSnapshotBaseName`. Database snapshots should be
created using the `New-SqlDscDatabaseSnapshot`, or the `New-SqlDscDatabase`
command with the `-DatabaseSnapshotBaseName` parameter.
- Removed parameter `DefaultSchema`. Default schema is a user-level property,
not a database-level property. See [issue #2177](https://github.com/dsccommunity/SqlServerDsc/issues/2177).
### Added
- Added public command `New-SqlDscDatabaseSnapshot` to create database snapshots
in a SQL Server Database Engine instance using SMO. This command provides an
automated and DSC-friendly approach to snapshot management by leveraging
`New-SqlDscDatabase` for the actual creation. The command now supports `FileGroup`
and `DataFile` parameters to allow control over snapshot file placement and
structure ([issue #2341](https://github.com/dsccommunity/SqlServerDsc/issues/2341)).
- Added public command `New-SqlDscFileGroup` to create FileGroup objects for SQL
Server databases. This command simplifies creating FileGroup objects that can be
used with `New-SqlDscDatabase` and other database-related commands. The `Database`
parameter is optional, allowing FileGroup objects to be created standalone and
added to a Database later using `Add-SqlDscFileGroup`.
- Added public command `New-SqlDscDataFile` to create DataFile objects for SQL
Server FileGroups. This command simplifies creating DataFile objects with
specified physical file paths, supporting both regular database files (.mdf, .ndf)
and sparse files for database snapshots (.ss). The `FileGroup` parameter is
mandatory, requiring DataFile objects to be created with an associated FileGroup.
- Added public command `Add-SqlDscFileGroup` to add one or more FileGroup objects
to a Database. This command provides a clean way to associate FileGroup objects
with a Database after they have been created.
- Added public command `ConvertTo-SqlDscDataFile` to convert `DatabaseFileSpec`
objects to SMO DataFile objects.
- Added public command `ConvertTo-SqlDscFileGroup` to convert `DatabaseFileGroupSpec`
objects to SMO FileGroup objects.
- Added class `DatabaseFileSpec` to define data file specifications without requiring
a database or SMO context.
- Added class `DatabaseFileGroupSpec` to define file group specifications with
associated data files without requiring a database or SMO context.
- `New-SqlDscDatabase`
- Added `FileGroup` and `DataFile` parameters to allow specifying custom file
locations and structure. These parameters apply to both regular databases and
database snapshots, enabling control over file placement for snapshots (sparse
files) and custom filegroup/datafile configuration for regular databases
([issue #2341](https://github.com/dsccommunity/SqlServerDsc/issues/2341)).
- 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
FileList
- SqlServerDsc.nuspec
- SqlServerDsc.psm1
- DSCResources\DSC_SqlAG\DSC_SqlAG.psm1
- SqlServerDsc.psd1
- DSCResources\DSC_SqlAG\DSC_SqlAG.schema.mof
- en-US\about_SqlPermission.help.txt
- DSCResources\DSC_SqlAG\README.md
- en-US\about_SqlAgentAlert.help.txt
- DSCResources\DSC_SqlAGReplica\README.md
- en-US\SqlServerDsc-help.xml
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.psm1
- en-US\SqlServerDsc.strings.psd1
- DSCResources\DSC_SqlAGReplica\DSC_SqlAGReplica.schema.mof
- en-US\SqlDatabasePermission.strings.psd1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.schema.mof
- en-US\SqlAudit.strings.psd1
- DSCResources\DSC_SqlDatabase\DSC_SqlDatabase.psm1
- en-US\SqlResourceBase.strings.psd1
- DSCResources\DSC_SqlDatabase\README.md
- en-US\SqlAgentAlert.strings.psd1
- DSCResources\DSC_SqlEndpoint\README.md
- en-US\SqlPermission.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.schema.mof
- en-US\SqlRSSetup.strings.psd1
- DSCResources\DSC_SqlEndpoint\DSC_SqlEndpoint.psm1
- en-US\about_SqlDatabasePermission.help.txt
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.schema.mof
- en-US\about_SqlAudit.help.txt
- DSCResources\DSC_SqlAlwaysOnService\DSC_SqlAlwaysOnService.psm1
- en-US\about_SqlRSSetup.help.txt
- DSCResources\DSC_SqlAlwaysOnService\README.md
- en-US\about_SqlServerDsc.help.txt
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psd1
- DSCResources\DSC_SqlScript\DSC_SqlScript.schema.mof
- Modules\SqlServerDsc.Common\SqlServerDsc.Common.psm1
- DSCResources\DSC_SqlScript\README.md
- DSCResources\DSC_SqlScript\en-US\about_SqlScript.help.txt
- DSCResources\DSC_SqlScript\DSC_SqlScript.psm1
- DSCResources\DSC_SqlScript\en-US\DSC_SqlScript.strings.psd1
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.psm1
- DSCResources\DSC_SqlScriptQuery\en-US\about_SqlScriptQuery.help.txt
- DSCResources\DSC_SqlScriptQuery\DSC_SqlScriptQuery.schema.mof
- DSCResources\DSC_SqlScriptQuery\en-US\DSC_SqlScriptQuery.strings.psd1
- DSCResources\DSC_SqlScriptQuery\README.md
- DSCResources\DSC_SqlDatabaseMail\en-US\about_SqlDatabaseMail.help.txt
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.schema.mof
- DSCResources\DSC_SqlDatabaseMail\en-US\DSC_SqlDatabaseMail.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\DSC_SqlDatabaseMail.psm1
- DSCResources\DSC_SqlDatabaseRole\en-US\DSC_SqlDatabaseRole.strings.psd1
- DSCResources\DSC_SqlDatabaseMail\README.md
- DSCResources\DSC_SqlDatabaseRole\en-US\about_SqlDatabaseRole.help.txt
- DSCResources\DSC_SqlDatabaseRole\README.md
- DSCResources\DSC_SqlRole\en-US\DSC_SqlRole.strings.psd1
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.psm1
- DSCResources\DSC_SqlRole\en-US\about_SqlRole.help.txt
- DSCResources\DSC_SqlDatabaseRole\DSC_SqlDatabaseRole.schema.mof
- DSCResources\DSC_SqlMaxDop\en-US\DSC_SqlMaxDop.strings.psd1
- DSCResources\DSC_SqlRole\DSC_SqlRole.schema.mof
- DSCResources\DSC_SqlMaxDop\en-US\about_SqlMaxDop.help.txt
- DSCResources\DSC_SqlRole\README.md
- DSCResources\DSC_SqlDatabaseUser\en-US\about_SqlDatabaseUser.help.txt
- DSCResources\DSC_SqlRole\DSC_SqlRole.psm1
- DSCResources\DSC_SqlDatabaseUser\en-US\DSC_SqlDatabaseUser.strings.psd1
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.schema.mof
- DSCResources\DSC_SqlMemory\en-US\DSC_SqlMemory.strings.psd1
- DSCResources\DSC_SqlMaxDop\README.md
- DSCResources\DSC_SqlMemory\en-US\about_SqlMemory.help.txt
- DSCResources\DSC_SqlMaxDop\DSC_SqlMaxDop.psm1
- DSCResources\DSC_SqlWindowsFirewall\en-US\about_SqlWindowsFirewall.help.txt
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.schema.mof
- DSCResources\DSC_SqlWindowsFirewall\en-US\DSC_SqlWindowsFirewall.strings.psd1
- DSCResources\DSC_SqlDatabaseUser\README.md
- DSCResources\DSC_SqlRS\en-US\about_SqlRS.help.txt
- DSCResources\DSC_SqlDatabaseUser\DSC_SqlDatabaseUser.psm1
- DSCResources\DSC_SqlRS\en-US\DSC_SqlRS.strings.psd1
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.psm1
- DSCResources\DSC_SqlAgentFailsafe\en-US\about_SqlAgentFailsafe.help.txt
- DSCResources\DSC_SqlMemory\README.md
- DSCResources\DSC_SqlAgentFailsafe\en-US\DSC_SqlAgentFailsafe.strings.psd1
- DSCResources\DSC_SqlMemory\DSC_SqlMemory.schema.mof
- DSCResources\DSC_SqlProtocol\en-US\about_SqlProtocol.help.txt
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.schema.mof
- DSCResources\DSC_SqlProtocol\en-US\DSC_SqlProtocol.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\README.md
- DSCResources\DSC_SqlSetup\en-US\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlWindowsFirewall\DSC_SqlWindowsFirewall.psm1
- DSCResources\DSC_SqlSetup\en-US\about_SqlSetup.help.txt
- DSCResources\DSC_SqlRS\DSC_SqlRS.schema.mof
- DSCResources\DSC_SqlSetup\sv-SE\DSC_SqlSetup.strings.psd1
- DSCResources\DSC_SqlRS\README.md
- DSCResources\DSC_SqlAgentOperator\en-US\about_SqlAgentOperator.help.txt
- DSCResources\DSC_SqlRS\DSC_SqlRS.psm1
- DSCResources\DSC_SqlAgentOperator\en-US\DSC_SqlAgentOperator.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.psm1
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\about_SqlDatabaseObjectPermission.help.txt
- DSCResources\DSC_SqlAgentFailsafe\DSC_SqlAgentFailsafe.schema.mof
- DSCResources\DSC_SqlDatabaseObjectPermission\en-US\DSC_SqlDatabaseObjectPermission.strings.psd1
- DSCResources\DSC_SqlAgentFailsafe\README.md
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\DSC_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.psm1
- DSCResources\DSC_SqlDatabaseDefaultLocation\en-US\about_SqlDatabaseDefaultLocation.help.txt
- DSCResources\DSC_SqlProtocol\README.md
- DSCResources\DSC_SqlLogin\en-US\DSC_SqlLogin.strings.psd1
- DSCResources\DSC_SqlProtocol\DSC_SqlProtocol.schema.mof
- DSCResources\DSC_SqlLogin\en-US\about_SqlLogin.help.txt
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.psm1
- DSCResources\DSC_SqlSecureConnection\en-US\about_SqlSecureConnection.help.txt
- DSCResources\DSC_SqlSetup\README.md
- DSCResources\DSC_SqlSecureConnection\en-US\DSC_SqlSecureConnection.strings.psd1
- DSCResources\DSC_SqlSetup\DSC_SqlSetup.schema.mof
- DSCResources\DSC_SqlAGListener\en-US\about_SqlAGListener.help.txt
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.schema.mof
- DSCResources\DSC_SqlAGListener\en-US\DSC_SqlAGListener.strings.psd1
- DSCResources\DSC_SqlAgentOperator\README.md
- DSCResources\DSC_SqlEndpointPermission\en-US\DSC_SqlEndpointPermission.strings.psd1
- DSCResources\DSC_SqlAgentOperator\DSC_SqlAgentOperator.psm1
- DSCResources\DSC_SqlEndpointPermission\en-US\about_SqlEndpointPermission.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.schema.mof
- DSCResources\DSC_SqlAGDatabase\en-US\DSC_SqlAGDatabase.strings.psd1
- DSCResources\DSC_SqlDatabaseObjectPermission\README.md
- DSCResources\DSC_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\DSC_SqlDatabaseObjectPermission\DSC_SqlDatabaseObjectPermission.psm1
- DSCResources\DSC_SqlWaitForAG\en-US\DSC_SqlWaitForAG.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\DSC_SqlWaitForAG\en-US\about_SqlWaitForAG.help.txt
- DSCResources\DSC_SqlDatabaseDefaultLocation\README.md
- DSCResources\DSC_SqlReplication\en-US\DSC_SqlReplication.strings.psd1
- DSCResources\DSC_SqlDatabaseDefaultLocation\DSC_SqlDatabaseDefaultLocation.psm1
- DSCResources\DSC_SqlReplication\en-US\about_SqlReplication.help.txt
- DSCResources\DSC_SqlLogin\README.md
- DSCResources\DSC_SqlAlias\en-US\DSC_SqlAlias.strings.psd1
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.schema.mof
- DSCResources\DSC_SqlAlias\en-US\about_SqlAlias.help.txt
- DSCResources\DSC_SqlLogin\DSC_SqlLogin.psm1
- DSCResources\DSC_SqlTraceFlag\en-US\DSC_SqlTraceFlag.strings.psd1
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.psm1
- DSCResources\DSC_SqlTraceFlag\en-US\about_SqlTraceFlag.help.txt
- DSCResources\DSC_SqlSecureConnection\README.md
- DSCResources\DSC_SqlServiceAccount\en-US\about_SqlServiceAccount.help.txt
- DSCResources\DSC_SqlSecureConnection\DSC_SqlSecureConnection.schema.mof
- DSCResources\DSC_SqlServiceAccount\en-US\DSC_SqlServiceAccount.strings.psd1
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.schema.mof
- DSCResources\DSC_SqlConfiguration\en-US\DSC_SqlConfiguration.strings.psd1
- DSCResources\DSC_SqlAGListener\DSC_SqlAGListener.psm1
- DSCResources\DSC_SqlConfiguration\en-US\about_SqlConfiguration.help.txt
- DSCResources\DSC_SqlAGListener\README.md
- DSCResources\DSC_SqlProtocolTcpIp\en-US\DSC_SqlProtocolTcpIp.strings.psd1
- DSCResources\DSC_SqlEndpointPermission\README.md
- DSCResources\DSC_SqlProtocolTcpIp\en-US\about_SqlProtocolTcpIp.help.txt
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.schema.mof
- DSCResources\DSC_SqlAG\en-US\about_SqlAG.help.txt
- DSCResources\DSC_SqlEndpointPermission\DSC_SqlEndpointPermission.psm1
- DSCResources\DSC_SqlAG\en-US\DSC_SqlAG.strings.psd1
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.psm1
- DSCResources\DSC_SqlAGReplica\en-US\DSC_SqlAGReplica.strings.psd1
- DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.schema.mof
- DSCResources\DSC_SqlAGReplica\en-US\about_SqlAGReplica.help.txt
- DSCResources\DSC_SqlAGDatabase\README.md
- DSCResources\DSC_SqlDatabase\en-US\DSC_SqlDatabase.strings.psd1
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.psm1
- DSCResources\DSC_SqlDatabase\en-US\about_SqlDatabase.help.txt
- DSCResources\DSC_SqlWaitForAG\README.md
- DSCResources\DSC_SqlEndpoint\en-US\DSC_SqlEndpoint.strings.psd1
- DSCResources\DSC_SqlWaitForAG\DSC_SqlWaitForAG.schema.mof
- DSCResources\DSC_SqlEndpoint\en-US\about_SqlEndpoint.help.txt
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.psm1
- DSCResources\DSC_SqlAlwaysOnService\en-US\about_SqlAlwaysOnService.help.txt
- DSCResources\DSC_SqlReplication\README.md
- DSCResources\DSC_SqlAlwaysOnService\en-US\DSC_SqlAlwaysOnService.strings.psd1
- DSCResources\DSC_SqlReplication\DSC_SqlReplication.schema.mof
- Modules\DscResource.Common\0.24.4\DscResource.Common.psd1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.psm1
- Modules\DscResource.Common\0.24.4\DscResource.Common.psm1
- DSCResources\DSC_SqlAlias\README.md
- Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlAlias\DSC_SqlAlias.schema.mof
- Modules\SqlServerDsc.Common\sv-SE\SqlServerDsc.Common.strings.psd1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.schema.mof
- Modules\DscResource.Base\1.4.0\DscResource.Base.psm1
- DSCResources\DSC_SqlTraceFlag\README.md
- Modules\DscResource.Base\1.4.0\DscResource.Base.psd1
- DSCResources\DSC_SqlTraceFlag\DSC_SqlTraceFlag.psm1
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlServiceAccount\README.md
- Modules\DscResource.Common\0.24.4\en-US\about_DscResource.Common.help.txt
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.schema.mof
- Modules\DscResource.Common\0.24.4\en-US\DscResource.Common.strings.psd1
- DSCResources\DSC_SqlServiceAccount\DSC_SqlServiceAccount.psm1
- Modules\DscResource.Base\1.4.0\en-US\ResourceBase.strings.psd1
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.psm1
- Modules\DscResource.Base\1.4.0\en-US\about_DscResource.Base.help.txt
- DSCResources\DSC_SqlConfiguration\DSC_SqlConfiguration.schema.mof
- Modules\DscResource.Base\1.4.0\en-US\DscResource.Base.strings.psd1
- DSCResources\DSC_SqlConfiguration\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psd1
- DSCResources\DSC_SqlProtocolTcpIp\README.md
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\DscResource.Common.psm1
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.psm1
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\DscResource.Common-help.xml
- DSCResources\DSC_SqlProtocolTcpIp\DSC_SqlProtocolTcpIp.schema.mof
- Modules\DscResource.Base\1.4.0\Modules\DscResource.Common\0.23.0\en-US\about_DscResource.Common.help.txt
- 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) | 4 | 11/25/2025 |
| 17.3.0-previ... | 7 | 11/22/2025 |
| 17.3.0-previ... | 17 | 11/2/2025 |
| 17.3.0-previ... | 3 | 11/1/2025 |
| 17.3.0-previ... | 3 | 11/1/2025 |
| 17.3.0-previ... | 3 | 10/31/2025 |
| 17.3.0-previ... | 3 | 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 | 287,219 | 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... | 16 | 8/3/2025 |
| 17.1.0 | 519,794 | 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... | 9 | 10/26/2024 |
| 17.0.1-previ... | 17 | 10/7/2024 |
| 17.0.0 | 2,616,496 | 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... | 8 | 5/22/2024 |
| 16.6.0 | 93,377 | 5/17/2024 |
| 16.6.0-previ... | 12 | 5/12/2024 |
| 16.6.0-previ... | 6 | 5/11/2024 |
| 16.6.0-previ... | 121 | 3/3/2024 |
| 16.6.0-previ... | 48 | 1/20/2024 |
| 16.6.0-previ... | 8 | 1/19/2024 |
| 16.5.1-previ... | 71 | 12/15/2023 |
| 16.5.1-previ... | 93 | 11/19/2023 |
| 16.5.1-previ... | 49 | 11/2/2023 |
| 16.5.0 | 145,989 | 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... | 9 | 8/25/2023 |
| 16.4.0 | 111,894 | 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... | 79 | 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,872 | 5/6/2023 |
| 16.3.1-previ... | 8 | 5/6/2023 |
| 16.3.1-previ... | 11 | 5/4/2023 |
| 16.3.0 | 42,420 | 4/26/2023 |
| 16.3.0-previ... | 11 | 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... | 11 | 4/12/2023 |
| 16.2.0 | 75,364 | 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... | 175 | 3/19/2023 |
| 16.2.0-previ... | 29 | 3/7/2023 |
| 16.2.0-previ... | 12 | 3/4/2023 |
| 16.1.0 | 175,792 | 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... | 11 | 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... | 53 | 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... | 15 | 11/24/2022 |
| 16.0.1-previ... | 34 | 11/11/2022 |
| 16.0.0 | 828,496 | 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,905 | 9/1/2021 |
| 15.2.0-previ... | 22 | 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,451,283 | 2/12/2021 |
| 15.1.1-previ... | 21 | 2/12/2021 |
| 15.1.0 | 62,672 | 2/2/2021 |
| 15.1.0-previ... | 28 | 2/1/2021 |
| 15.1.0-previ... | 22 | 1/31/2021 |
| 15.0.2-previ... | 22 | 1/30/2021 |
| 15.0.2-previ... | 27 | 1/24/2021 |
| 15.0.2-previ... | 66 | 1/21/2021 |
| 15.0.2-previ... | 66 | 1/12/2021 |
| 15.0.1 | 143,086 | 1/9/2021 |
| 15.0.1-previ... | 63 | 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... | 67 | 12/23/2020 |
| 15.0.1-previ... | 73 | 12/14/2020 |
| 15.0.1-previ... | 65 | 12/13/2020 |
| 15.0.1-previ... | 65 | 12/12/2020 |
| 15.0.1-previ... | 64 | 12/10/2020 |
| 15.0.0 | 214,908 | 12/6/2020 |
| 15.0.0-previ... | 66 | 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... | 58 | 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,447 | 8/14/2020 |
| 14.2.1-previ... | 62 | 8/13/2020 |
| 14.2.1-previ... | 64 | 8/11/2020 |
| 14.2.1-previ... | 61 | 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... | 67 | 7/23/2020 |
| 14.2.0-previ... | 68 | 7/19/2020 |
| 14.2.0-previ... | 77 | 7/13/2020 |
| 14.2.0-previ... | 69 | 7/10/2020 |
| 14.2.0-previ... | 65 | 7/9/2020 |
| 14.1.1-previ... | 66 | 7/9/2020 |
| 14.1.0 | 221,838 | 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... | 76 | 6/28/2020 |
| 14.0.1-previ... | 65 | 6/26/2020 |
| 14.0.0 | 10,854 | 6/12/2020 |
| 14.0.0-previ... | 67 | 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... | 76 | 5/13/2020 |
| 14.0.0-previ... | 82 | 5/12/2020 |
| 14.0.0-previ... | 73 | 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,418 | 1/17/2020 |
| 13.3.0-previ... | 79 | 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,133 | 9/19/2019 |
| 13.1.0.0 | 35,069 | 8/8/2019 |
| 13.0.0.0 | 26,094 | 6/26/2019 |
| 12.5.0.0 | 17,618 | 5/15/2019 |
| 12.4.0.0 | 21,830 | 4/3/2019 |
| 12.3.0.0 | 40,239 | 2/20/2019 |
| 12.2.0.0 | 9,116 | 1/10/2019 |
| 12.1.0.0 | 23,382 | 10/25/2018 |
| 12.0.0.0 | 21,464 | 9/5/2018 |
| 11.4.0.0 | 16,164 | 7/25/2018 |
| 11.3.0.0 | 7,397 | 6/13/2018 |
| 11.2.0.0 | 5,712 | 5/2/2018 |
| 11.1.0.0 | 6,265 | 3/22/2018 |
| 11.0.0.0 | 13,554 | 2/8/2018 |
| 10.0.0.0 | 3,657 | 12/14/2017 |