SqlServerDsc

14.2.1

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

Minimum PowerShell version

5.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

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

Install-Module -Name SqlServerDsc -RequiredVersion 14.2.1

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy 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

Author(s)

DSC Community

Copyright

Copyright the DSC Community contributors. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

SqlAG SqlAGDatabase SqlAgentAlert SqlAgentFailsafe SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabaseObjectPermission SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlDatabaseUser SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlConfiguration SqlDatabaseMail SqlEndpoint SqlEndpointPermission SqlServerEndpointState SqlLogin SqlMaxDop SqlMemory SqlServerNetwork SqlPermission SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlSecureConnection SqlServiceAccount SqlSetup SqlWaitForAG SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

## [14.2.1] - 2020-08-14

### Changed

- SqlServerDsc
 - Document changes in the file `build.yml`.
 - The regular expression for `major-version-bump-message` in the file
   `GitVersion.yml` was changed to only raise major version when the
   commit message contain the phrase `breaking change`, or when it contain
   the word `breaking` or `major`.
- SqlSetup
 - Duplicate function Get-SqlMajorVersion was removed and instead the
   helper function `Get-FilePathMajorVersion` from the helper module
   SqlServerDsc.Common is used ([issue #1178](https://github.com/PowerShell/SqlServerDsc/issues/1178)).
- SqlWindowsFirewall
 - Duplicate function Get-SqlMajorVersion was removed and instead the
   helper function `Get-FilePathMajorVersion` from the helper module
   SqlServerDsc.Common is used ([issue #1178](https://github.com/PowerShell/SqlServerDsc/issues/1178)).
- SqlServerDsc.Common
 - Function `Get-FilePathMajorVersion` was added. The function `Get-SqlMajorVersion`
   from the resources _SqlSetup_ and _SqlWindowsFirewall_ was moved and
   renamed without any functional changes ([issue #1178](https://github.com/PowerShell/SqlServerDsc/issues/1178)).

### Fixed

- SqlServerDsc
 - Removed helper functions that was moved to the module _DscResource.Common_.
   DSC resources using those functions are using them from the module
   _DscResource.Common_.
- SqlDatabaseObjectPermission
 - Fixed method invocation failed because of missing `Where()` method ([issue #1600](https://github.com/PowerShell/SqlServerDsc/issues/1600)).
   - New integration tests to verify scenarios when passing a single permission.
 - To enforce a scenario where a permission must be changed from `'GrantWithGrant'`
   to `'Grant'` a new parameter **Force** was added ([issue #1602](https://github.com/dsccommunity/SqlServerDsc/issues/1602)).
   The parameter **Force** is used to enforce the desired state in those
   scenarios where revocations must be performed to enforce the desired
   state, even if that encompasses cascading revocations. If parameter
   **Force** is _not_ set to `$true` an exception is thrown in those
   scenarios where a revocation must be performed to enforce the desired
   state.
   - New integration tests to verify scenarios when current state for a
     permission is `'GrantWithGrant'` but desired state should be `'Grant'`.
- SqlSetup
 - The example `4-InstallNamedInstanceInFailoverClusterFirstNode.ps1` was
   updated to no longer reference the issue #405 and issue #444 in the
   comment-based help. The issues was fixed a while back and _SqlSetup_
   now supports the built-in parameter `PsDscRunAsCredential` ([issue #975](https://github.com/PowerShell/SqlServerDsc/issues/975)).

Version History

Version Downloads Last updated
15.0.0-previ... 6 11/25/2020
15.0.0-previ... 5 11/22/2020
15.0.0-previ... 5 11/21/2020
14.3.0-previ... 40 10/5/2020
14.3.0-previ... 1 10/3/2020
14.3.0-previ... 1 10/2/2020
14.2.2-previ... 51 8/19/2020
14.2.2-previ... 4 8/16/2020
14.2.1 (current version) 565,318 8/14/2020
14.2.1-previ... 4 8/13/2020
14.2.1-previ... 6 8/11/2020
14.2.1-previ... 4 8/11/2020
14.2.1-previ... 14 7/31/2020
14.2.1-previ... 3 7/28/2020
14.2.0 71,554 7/23/2020
14.2.0-previ... 5 7/23/2020
14.2.0-previ... 5 7/19/2020
14.2.0-previ... 11 7/13/2020
14.2.0-previ... 6 7/10/2020
14.2.0-previ... 5 7/9/2020
14.1.1-previ... 3 7/9/2020
14.1.0 22,248 7/6/2020
14.1.0-previ... 34 7/5/2020
14.1.0-previ... 3 7/4/2020
14.1.0-previ... 3 7/4/2020
14.1.0-previ... 3 7/3/2020
14.1.0-previ... 6 7/1/2020
14.0.1-previ... 12 6/28/2020
14.0.1-previ... 4 6/26/2020
14.0.0 9,803 6/12/2020
14.0.0-previ... 5 6/12/2020
14.0.0-previ... 9 6/11/2020
14.0.0-previ... 8 6/10/2020
14.0.0-previ... 8 6/10/2020
14.0.0-previ... 43 5/28/2020
14.0.0-previ... 21 5/25/2020
14.0.0-previ... 3 5/25/2020
14.0.0-previ... 15 5/19/2020
14.0.0-previ... 11 5/19/2020
14.0.0-previ... 18 5/17/2020
14.0.0-previ... 4 5/17/2020
14.0.0-previ... 3 5/16/2020
14.0.0-previ... 4 5/14/2020
14.0.0-previ... 6 5/13/2020
14.0.0-previ... 11 5/12/2020
14.0.0-previ... 3 5/12/2020
14.0.0-previ... 3 5/12/2020
14.0.0-previ... 17 5/8/2020
14.0.0-previ... 3 5/6/2020
14.0.0-previ... 5 5/5/2020
14.0.0-previ... 5 5/4/2020
14.0.0-previ... 4 5/3/2020
14.0.0-previ... 3 5/3/2020
14.0.0-previ... 18 4/27/2020
14.0.0-previ... 10 4/26/2020
13.5.0 24,406 4/12/2020
13.5.0-previ... 9 4/11/2020
13.5.0-previ... 11 4/11/2020
13.4.1-previ... 37 3/31/2020
13.4.0 121,535 3/18/2020
13.4.0-previ... 5 3/18/2020
13.3.1-previ... 52 1/18/2020
13.3.0 463,415 1/17/2020
13.3.0-previ... 5 1/17/2020
13.3.0-previ... 12 1/12/2020
13.3.0-previ... 6 1/8/2020
13.3.0-previ... 9 1/7/2020
13.3.0-previ... 5 1/3/2020
13.3.0-previ... 5 1/2/2020
13.3.0-previ... 7 1/2/2020
13.2.0.0 778,777 9/19/2019
13.1.0.0 34,461 8/8/2019
13.0.0.0 25,847 6/26/2019
12.5.0.0 16,257 5/15/2019
12.4.0.0 21,243 4/3/2019
12.3.0.0 39,725 2/20/2019
12.2.0.0 8,511 1/10/2019
12.1.0.0 21,975 10/25/2018
12.0.0.0 20,980 9/5/2018
11.4.0.0 16,018 7/25/2018
11.3.0.0 7,195 6/13/2018
11.2.0.0 3,868 5/2/2018
11.1.0.0 5,780 3/22/2018
11.0.0.0 8,305 2/8/2018
10.0.0.0 3,525 12/14/2017
Show less