SqlServerDsc

17.4.1-preview0001

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

This is a prerelease version of SqlServerDsc.

Installation Options

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

Install-Module -Name SqlServerDsc -AllowPrerelease

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

Install-PSResource -Name SqlServerDsc -Prerelease

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

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

Owners

Copyright

Copyright the DSC Community contributors. All rights reserved.

Package Details

Author(s)

  • DSC Community

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource SqlServer PowerBI ReportingServices ReportServer

Functions

Add-SqlDscFileGroup Add-SqlDscNode Add-SqlDscRSSslCertificateBinding Add-SqlDscRSUrlReservation Add-SqlDscTraceFlag Assert-SqlDscAgentOperator Assert-SqlDscLogin Backup-SqlDscDatabase Backup-SqlDscRSEncryptionKey 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-SqlDscDatabaseSnapshotIsolation Disable-SqlDscLogin Disable-SqlDscRsSecureConnection Disconnect-SqlDscDatabaseEngine Enable-SqlDscAgentOperator Enable-SqlDscAudit Enable-SqlDscDatabaseSnapshotIsolation Enable-SqlDscLogin Enable-SqlDscRsSecureConnection Get-SqlDscAgentAlert Get-SqlDscAgentOperator Get-SqlDscAudit Get-SqlDscBackupFileList Get-SqlDscCompatibilityLevel Get-SqlDscConfigurationOption Get-SqlDscDatabase Get-SqlDscDatabasePermission Get-SqlDscDateTime Get-SqlDscInstalledInstance Get-SqlDscLogin Get-SqlDscManagedComputer Get-SqlDscManagedComputerInstance Get-SqlDscManagedComputerService Get-SqlDscPreferredModule Get-SqlDscRole Get-SqlDscRSConfigFile Get-SqlDscRSConfiguration Get-SqlDscRSDatabaseInstallation Get-SqlDscRSExecutionLog Get-SqlDscRSIPAddress Get-SqlDscRSLogPath Get-SqlDscRSPackage Get-SqlDscRSServiceAccount Get-SqlDscRSSetupConfiguration Get-SqlDscRSSslCertificate Get-SqlDscRSSslCertificateBinding Get-SqlDscRSUrl Get-SqlDscRSUrlReservation Get-SqlDscRSVersion Get-SqlDscRSWebPortalApplicationName Get-SqlDscServerPermission Get-SqlDscServerProtocol Get-SqlDscServerProtocolName Get-SqlDscServerProtocolTcpIp Get-SqlDscSetupLog Get-SqlDscStartupParameter Get-SqlDscTraceFlag Grant-SqlDscServerPermission Import-SqlDscPreferredModule Initialize-SqlDscFailoverCluster Initialize-SqlDscImage Initialize-SqlDscRebuildDatabase Initialize-SqlDscRS Install-SqlDscFailoverCluster Install-SqlDscPowerBIReportServer Install-SqlDscReportingService Install-SqlDscServer Invoke-SqlDscQuery Invoke-SqlDscScalarQuery New-SqlDscAgentAlert New-SqlDscAgentOperator New-SqlDscAudit New-SqlDscDatabase New-SqlDscDatabaseSnapshot New-SqlDscDataFile New-SqlDscFileGroup New-SqlDscLogin New-SqlDscRole New-SqlDscRSEncryptionKey Remove-SqlDscAgentAlert Remove-SqlDscAgentOperator Remove-SqlDscAudit Remove-SqlDscDatabase Remove-SqlDscLogin Remove-SqlDscNode Remove-SqlDscRole Remove-SqlDscRSEncryptedInformation Remove-SqlDscRSEncryptionKey Remove-SqlDscRSSslCertificateBinding Remove-SqlDscRSUnattendedExecutionAccount Remove-SqlDscRSUrlReservation Remove-SqlDscTraceFlag Repair-SqlDscPowerBIReportServer Repair-SqlDscReportingService Repair-SqlDscServer Request-SqlDscRSDatabaseRightsScript Request-SqlDscRSDatabaseScript Request-SqlDscRSDatabaseUpgradeScript Restart-SqlDscRSService Restore-SqlDscDatabase Restore-SqlDscRSEncryptionKey Resume-SqlDscDatabase Revoke-SqlDscServerPermission Save-SqlDscSqlServerMediaFile Set-SqlDscAgentAlert Set-SqlDscAgentOperator Set-SqlDscAudit Set-SqlDscConfigurationOption Set-SqlDscDatabaseDefault Set-SqlDscDatabaseOwner Set-SqlDscDatabasePermission Set-SqlDscDatabaseProperty Set-SqlDscRSDatabaseConnection Set-SqlDscRSDatabaseTimeout Set-SqlDscRSServiceAccount Set-SqlDscRSSmtpConfiguration Set-SqlDscRSSslCertificateBinding Set-SqlDscRSUnattendedExecutionAccount Set-SqlDscRSUrlReservation Set-SqlDscRSVirtualDirectory Set-SqlDscServerPermission Set-SqlDscStartupParameter Set-SqlDscTraceFlag Start-SqlDscRSWebService Start-SqlDscRSWindowsService Stop-SqlDscRSWebService Stop-SqlDscRSWindowsService Suspend-SqlDscDatabase Test-SqlDscAgentAlertProperty Test-SqlDscBackupFile Test-SqlDscConfigurationOption Test-SqlDscDatabaseProperty Test-SqlDscIsAgentAlert Test-SqlDscIsAgentOperator Test-SqlDscIsDatabase Test-SqlDscIsDatabasePrincipal Test-SqlDscIsLogin Test-SqlDscIsLoginEnabled Test-SqlDscIsRole Test-SqlDscIsSupportedFeature Test-SqlDscRSAccessible Test-SqlDscRSInitialized Test-SqlDscRSInstalled Test-SqlDscServerPermission Uninstall-SqlDscPowerBIReportServer Uninstall-SqlDscReportingService Uninstall-SqlDscServer Update-SqlDscServer Update-SqlDscServerEdition

DSCResources

SqlAgentAlert SqlAudit SqlDatabase SqlDatabasePermission SqlPermission SqlRSSetup SqlAG SqlAGDatabase SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlConfiguration 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.4.1-preview0001] - 2026-01-23

### Changed

- SqlServerDsc.Common
 - Moved functions into individual files and use ModuleBuilder to assemble.

- SqlServerDsc
 - Refactor integration tests for _SQL Server Reporting Services_ and _Power BI_
   _Report Server_ ([issue #2431](https://github.com/dsccommunity/SqlServerDsc/issues/2431)).

FileList

Version History

Version Downloads Last updated
17.4.1-previ... (current version) 4 1/23/2026
17.4.0 18,753 1/19/2026
17.4.0-previ... 8 1/19/2026
17.4.0-previ... 5 1/18/2026
17.4.0-previ... 6 1/17/2026
17.4.0-previ... 5 1/16/2026
17.4.0-previ... 5 1/16/2026
17.4.0-previ... 9 1/15/2026
17.4.0-previ... 6 1/13/2026
17.4.0-previ... 6 1/11/2026
17.4.0-previ... 5 1/10/2026
17.4.0-previ... 5 1/10/2026
17.4.0-previ... 6 1/7/2026
17.4.0-previ... 6 1/6/2026
17.4.0-previ... 7 1/5/2026
17.4.0-previ... 7 1/4/2026
17.4.0-previ... 5 1/4/2026
17.4.0-previ... 6 1/3/2026
17.4.0-previ... 6 1/2/2026
17.4.0-previ... 5 1/1/2026
17.4.0-previ... 5 12/31/2025
17.4.0-previ... 7 12/28/2025
17.4.0-previ... 5 12/28/2025
17.4.0-previ... 5 12/26/2025
17.4.0-previ... 5 12/24/2025
17.4.0-previ... 13 12/14/2025
17.4.0-previ... 7 12/12/2025
17.4.0-previ... 8 12/9/2025
17.4.0-previ... 6 12/7/2025
17.4.0-previ... 5 12/7/2025
17.4.0-previ... 6 12/7/2025
17.4.0-previ... 5 12/6/2025
17.4.0-previ... 5 12/5/2025
17.4.0-previ... 6 12/5/2025
17.4.0-previ... 9 12/3/2025
17.3.0 237,141 12/1/2025
17.3.0-previ... 10 11/29/2025
17.3.0-previ... 6 11/28/2025
17.3.0-previ... 10 11/28/2025
17.3.0-previ... 7 11/27/2025
17.3.0-previ... 10 11/25/2025
17.3.0-previ... 7 11/22/2025
17.3.0-previ... 18 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... 5 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... 4 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 309,043 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... 17 8/3/2025
17.1.0 519,926 5/22/2025
17.1.0-previ... 27 5/2/2025
17.1.0-previ... 6 5/1/2025
17.1.0-previ... 38 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... 10 10/26/2024
17.0.1-previ... 17 10/7/2024
17.0.0 3,047,246 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,595 5/17/2024
16.6.0-previ... 12 5/12/2024
16.6.0-previ... 6 5/11/2024
16.6.0-previ... 122 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 146,047 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,955 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,971 5/6/2023
16.3.1-previ... 10 5/6/2023
16.3.1-previ... 11 5/4/2023
16.3.0 42,440 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,396 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... 176 3/19/2023
16.2.0-previ... 29 3/7/2023
16.2.0-previ... 12 3/4/2023
16.1.0 175,798 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... 12 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... 35 11/11/2022
16.0.0 828,594 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... 93 4/26/2022
16.0.0-previ... 46 3/28/2022
16.0.0-previ... 68 2/12/2022
15.2.0 2,686,019 9/1/2021
15.2.0-previ... 24 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,456,469 2/12/2021
15.1.1-previ... 21 2/12/2021
15.1.0 62,678 2/2/2021
15.1.0-previ... 28 2/1/2021
15.1.0-previ... 22 1/31/2021
15.0.2-previ... 23 1/30/2021
15.0.2-previ... 27 1/24/2021
15.0.2-previ... 66 1/21/2021
15.0.2-previ... 69 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... 59 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,534 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,853 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... 77 6/28/2020
14.0.1-previ... 65 6/26/2020
14.0.0 10,855 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,513 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,495 1/17/2020
13.3.0-previ... 80 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,235 9/19/2019
13.1.0.0 35,086 8/8/2019
13.0.0.0 26,095 6/26/2019
12.5.0.0 17,621 5/15/2019
12.4.0.0 21,836 4/3/2019
12.3.0.0 40,239 2/20/2019
12.2.0.0 9,125 1/10/2019
12.1.0.0 23,387 10/25/2018
12.0.0.0 21,485 9/5/2018
11.4.0.0 16,164 7/25/2018
11.3.0.0 7,398 6/13/2018
11.2.0.0 5,723 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,658 12/14/2017
Show more