Module with DSC Resources for deployment and configuration of Microsoft SQL Server.

Minimum PowerShell version


Installation Options

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

Install-Module -Name xSQLServer -RequiredVersion

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


Microsoft Corporation


(c) 2014 Microsoft Corporation. All rights reserved.



DesiredStateConfiguration DSC DSCResourceKit DSCResource


xSQLAlias xSQLAOGroupEnsure xSQLAOGroupJoin xSQLDatabaseRecoveryModel xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseOwner xSQLServerDatabasePermissions xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFailoverClusterSetup xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerPowerPlan xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerSetup xWaitForAvailabilityGroup


This module has no dependencies.

Release Notes

* Added resources
 - xSQLServerReplication
 - xSQLServerScript
 - xSQLAlias  
 - xSQLServerRole
* Added tests for resources
 - xSQLServerPermission
 - xSQLServerEndpointState
 - xSQLServerEndpointPermission
 - xSQLServerAvailabilityGroupListener
 - xSQLServerLogin
 - xSQLAOGroupEnsure
 - xSQLAlias
 - xSQLServerRole
* Fixes in xSQLServerAvailabilityGroupListener
 - In one case the Get-method did not report that DHCP was configured.
 - Now the resource will throw "Not supported" when IP is changed between Static and DHCP.
 - Fixed an issue where sometimes the listener wasn"t removed.
 - Fixed the issue when trying to add a static IP to a listener was ignored.
* Fix in xSQLServerDatabase
 - Fixed so dropping a database no longer throws an error
 - BREAKING CHANGE: Fixed an issue where it was not possible to add the same database to two instances on the same server.
 - BREAKING CHANGE: The name of the parameter Database has changed. It is now called Name.
* Fixes in xSQLAOGroupEnsure
 - Added parameters to New-ListenerADObject to allow usage of a named instance.
 - pass setup credential correctly
* Changes to xSQLServerLogin
  - Fixed an issue when dropping logins.
  - BREAKING CHANGE: Fixed an issue where it was not possible to add the same login to two instances on the same server.
* Changes to xSQLServerMaxDop
  - BREAKING CHANGE: Made SQLInstance parameter a key so that multiple instances on the same server can be configured

Version History

Version Downloads Last updated 147,320 1/24/2018 7,137 11/15/2017 5,290 10/5/2017 5,525 8/23/2017 5,188 7/12/2017 6,239 5/31/2017 8,212 4/19/2017 10,736 3/8/2017 2,540 1/26/2017 2,314 12/14/2016 1,871 11/2/2016 (current version) 7,380 9/21/2016 25,738 8/10/2016 2,183 6/29/2016 1,233 5/18/2016 998 3/31/2016 1,583 2/3/2016 2,159 5/2/2015 480 2/19/2015 65 12/18/2014 73 10/24/2014
Show less