SqlServerDsc

14.0.0

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.0.0

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

Install-PSResource -Name SqlServerDsc -Version 14.0.0

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

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.0.0] - 2020-06-12

### Remove

- SqlServerDsc
 - BREAKING CHANGE: Since the operating system Windows Server 2008 R2 and
   the product SQL Server 2008 R2 has gone end-of-life the DSC resources
   will no longer try to maintain compatibility with them. Moving forward,
   and including this release, there may be code changes that will break
   the resource on Windows Server 2008 R2 or with SQL Server 2008 R2
   ([issue #1514](https://github.com/dsccommunity/SqlServerDsc/issues/1514)).

### Deprecated

The documentation, examples, unit test, and integration tests have been
removed for these deprecated resources. These resources will be removed
in a future release.

- SqlDatabaseOwner
 - This resource is now deprecated. The functionality is now covered by
   a property in the resource _SqlDatabase_ ([issue #966](https://github.com/dsccommunity/SqlServerDsc/issues/966)).
- SqlDatabaseRecoveryModel
 - This resource is now deprecated. The functionality is now covered by
   a property in the resource _SqlDatabase_ ([issue #967](https://github.com/dsccommunity/SqlServerDsc/issues/967)).
- SqlServerEndpointState
 - This resource is now deprecated. The functionality is covered by a
   property in the resource _SqlEndpoint_ ([issue #968](https://github.com/dsccommunity/SqlServerDsc/issues/968)).
- SqlServerNetwork
 - This resource is now deprecated. The functionality is now covered by
   the resources _SqlProtocol_ and _SqlProtocolTcpIp_.

### Added

- SqlSetup
 - Added support for major version upgrade ([issue #1561](https://github.com/dsccommunity/SqlServerDsc/issues/1561)).
- SqlServerDsc
 - Added new resource SqlProtocol ([issue #1377](https://github.com/dsccommunity/SqlServerDsc/issues/1377)).
 - Added new resource SqlProtocolTcpIp ([issue #1378](https://github.com/dsccommunity/SqlServerDsc/issues/1378)).
 - Added new resource SqlDatabaseObjectPermission ([issue #1119](https://github.com/dsccommunity/SqlServerDsc/issues/1119)).
 - Fixing a problem with the latest ModuleBuild 1.7.0 that breaks the CI
   pipeline.
 - Prepare repository for auto-documentation by adding README.md to each
   resource folder with the content from the root README.md.
- SqlServerDsc.Common
 - Added function `Import-Assembly` that can help import an assembly
   into the PowerShell session.
 - Prepared unit tests to support Pester 5 so a minimal conversation
   is only needed later.
 - Updated `Import-SQLPSModule` to better support unit tests.
- CommonTestHelper
 - Added the functions `Get-InvalidOperationRecord` and `Get-InvalidResultRecord`
   that is needed for evaluate localized error message strings for unit tests.
- SqlEndpoint
 - BREAKING CHANGE: A new required property `EndpointType` was added to
   support different types of endpoints in the future. For now the only
   endpoint type that is supported is the database mirror endpoint type
   (`DatabaseMirroring`).
 - Added the property `State` to be able to specify if the endpoint should
   be running, stopped, or disabled. _This property was moved from the now_
   _deprecated DSC resource `SqlServerEndpointState`_.
- SqlSetup
 - A read only property `IsClustered` was added that can be used to determine
   if the instance is clustered.
 - Added the properties `NpEnabled` and `TcpEnabled` ([issue #1161](https://github.com/dsccommunity/SqlServerDsc/issues/1161)).
 - Added the property `UseEnglish` ([issue #1473](https://github.com/dsccommunity/SqlServerDsc/issues/1473)).
- SqlReplication
 - Add integration tests ([issue #755](https://github.com/dsccommunity/SqlServerDsc/issues/755).
- SqlDatabase
 - The property `OwnerName` was added.
- SqlDatabasePermission
 - Now possible to change permissions for database user-defined roles
   (e.g. public) and database application roles ([issue #1498](https://github.com/dsccommunity/SqlServerDsc/issues/1498).
- SqlServerDsc.Common
 - The helper function `Restart-SqlService` was improved to handle Failover
   Clusters better. Now the SQL Server service will only be taken offline
   and back online again if the service is online to begin with.
 - The helper function `Restart-SqlServer` learned the new parameter
   `OwnerNode`. The parameter `OwnerNode` takes an array of Cluster node
   names. Using this parameter the cluster group will only be taken
   offline and back online if the cluster group owner is one specified
   in this parameter.
 - The helper function `Compare-ResourcePropertyState` was improved to
   handle embedded instances by adding a parameter `CimInstanceKeyProperties`
   that can be used to identify the unique parameter for each embedded
   instance in a collection.
 - The helper function `Test-DscPropertyState` was improved to evaluate
   the properties in a single CIM instance or a collection of CIM instances
   by recursively call itself.
 - When the helper function `Test-DscPropertyState` evaluated an array
   the verbose messages was not very descriptive. Instead of outputting
   the side indicator from the compare it now outputs a descriptive
   message.

### Changed

- SqlServerDsc
 - BREAKING CHANGE: Some DSC resources have been renamed ([issue #1540](https://github.com/dsccommunity/SqlServerDsc/issues/1540)).
   - `SqlServerConfiguration` was renamed to `SqlConfiguration`.
   - `SqlServerDatabaseMail` was renamed to `SqlDatabaseMail`.
   - `SqlServerEndpoint` was renamed to `SqlEndpoint`.
   - `SqlServerEndpointPermission` was renamed to `SqlEndpointPermission`.
   - `SqlServerLogin` was renamed to `SqlLogin`.
   - `SqlServerMaxDop` was renamed to `SqlMaxDop`.
   - `SqlServerMemory` was renamed to `SqlMemory`.
   - `SqlServerPermission` was renamed to `SqlPermission`.
   - `SqlServerProtocol` was renamed to `SqlProtocol`.
   - `SqlServerProtocolTcpIp` was renamed to `SqlProtocolTcpIp`.
   - `SqlServerReplication` was renamed to `SqlReplication`.
   - `SqlServerRole` was renamed to `SqlRole`.
   - `SqlServerSecureConnection` was renamed to `SqlSecureConnection`.
 - Changed all resource prefixes from `MSFT_` to `DSC_` ([issue #1496](https://github.com/dsccommunity/SqlServerDsc/issues/1496)).
   _Deprecated resource has not changed prefix._
 - All resources are now using the common module DscResource.Common.
 - When a PR is labelled with 'ready for merge' it is no longer being
   marked as stale if the PR is not merged for 30 days (for example it is
   dependent on something else) ([issue #1504](https://github.com/dsccommunity/SqlServerDsc/issues/1504)).
 - Updated the CI pipeline to use latest version of the module ModuleBuilder.
 - Changed to use the property `NuGetVersionV2` from GitVersion in the
   CI pipeline.
 - The unit tests now run on PowerShell 7 to optimize the total run time.
- SqlServerDsc.Common
 - The helper function `Invoke-InstallationMediaCopy` was changed to
   handle a breaking change in PowerShell 7 ([issue #1530](https://github.com/dsccommunity/SqlServerDsc/issues/1530)).
 - Removed the local helper function `Set-PSModulePath` as it was
   implemented in the module DscResource.Common.
- CommonTestHelper
 - The test helper function `New-SQLSelfSignedCertificate` was changed
   to install the dependent module `PSPKI` through `RequiredModules.psd1`.
- SqlAlwaysOnService
 - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and
   defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)).
 - Normalize parameter descriptive text for default values.
- SqlDatabase
 - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and
   defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)).
 - BREAKING CHANGE: The non-mandatory parameters was removed from the
   function `Get-TargetResource` since they were not needed.
 - BREAKING CHANGE: The properties `CompatibilityLevel` and `Collation`
   are now only enforced if the are specified in the configuration.
 - Normalize parameter descriptive text for default values.
- SqlDatabaseDefaultLocation
 - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and
   defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)).
 - Normalize parameter descriptive text for default values.
- SqlDatabaseOwner
 - BREAKING CHANGE: Database changed to DatabaseName for consistency with
   other modules ([issue #1484](https://github.com/dsccommunity/SqlServerDsc/issues/1484)).
- SqlDatabasePermission
 - BREAKING CHANGE: The parameter `ServerName` is now non-mandatory and
   defaults to `$env:COMPUTERNAME` ([issue #319](https://github.com/dsccommunity/SqlServerDsc/issues/319)).
 - Normalize parameter descriptive text for default values.
 - BREAKING CHANGE: Database changed to DatabaseName for consistency with
   other modules ([issue #1484](https://github.com/dsccommunity/SqlServerDsc/issues/1484)).
 - BREAKING CHANGE: The resource no longer create the database user if
   it does not exist. Use the resource _SqlDatabaseUser_ to enforce that
   the database user exist in the database prior to setting permissions
   using this resource ([issue #848](https://github.com/dsccommunity/SqlServerDsc/issues/848)).
 - BREAKING CHANGE: The resource no longer checks if a login exist so that
   it is possible to set permissions for database users that does not
   have a login, e.g. the database user 'guest' ([issue #1134](https://github.com/dsccommunity/SqlServerDsc/issues/1134)).
 - Updated examples.
 - Added integration tests ([issue #741](https://github.com/dsccommunity/SqlServerDsc/issues/741)).
 - Get-TargetResource will no longer throw an exception if the database
   does not exist.
- SqlDatabaseRecoveryModel
 - BREAKING CHANGE: The para

FileList

Version History

Version Downloads Last updated
17.0.1-previ... 17 10/29/2024
17.0.1-previ... 6 10/26/2024
17.0.1-previ... 14 10/7/2024
17.0.0 40,841 9/30/2024
17.0.0-previ... 4 9/29/2024
17.0.0-previ... 48 8/13/2024
16.6.1-previ... 118 5/23/2024
16.6.1-previ... 5 5/22/2024
16.6.0 91,058 5/17/2024
16.6.0-previ... 10 5/12/2024
16.6.0-previ... 4 5/11/2024
16.6.0-previ... 104 3/3/2024
16.6.0-previ... 46 1/20/2024
16.6.0-previ... 6 1/19/2024
16.5.1-previ... 68 12/15/2023
16.5.1-previ... 91 11/19/2023
16.5.1-previ... 47 11/2/2023
16.5.0 144,721 10/5/2023
16.5.0-previ... 12 10/1/2023
16.5.0-previ... 7 9/29/2023
16.5.0-previ... 47 9/1/2023
16.5.0-previ... 7 8/26/2023
16.4.1-previ... 6 8/25/2023
16.4.0 111,489 8/22/2023
16.4.0-previ... 5 8/20/2023
16.4.0-previ... 5 8/20/2023
16.4.0-previ... 6 8/19/2023
16.4.0-previ... 76 5/18/2023
16.4.0-previ... 20 5/10/2023
16.4.0-previ... 6 5/9/2023
16.4.0-previ... 7 5/8/2023
16.3.1 460,073 5/6/2023
16.3.1-previ... 5 5/6/2023
16.3.1-previ... 9 5/4/2023
16.3.0 42,245 4/26/2023
16.3.0-previ... 7 4/26/2023
16.3.0-previ... 7 4/25/2023
16.3.0-previ... 6 4/24/2023
16.3.0-previ... 6 4/23/2023
16.3.0-previ... 21 4/18/2023
16.3.0-previ... 5 4/16/2023
16.2.1-previ... 7 4/12/2023
16.2.0 75,151 4/10/2023
16.2.0-previ... 5 4/10/2023
16.2.0-previ... 5 4/8/2023
16.2.0-previ... 5 4/8/2023
16.2.0-previ... 10 4/6/2023
16.2.0-previ... 10 4/1/2023
16.2.0-previ... 11 3/28/2023
16.2.0-previ... 10 3/26/2023
16.2.0-previ... 5 3/25/2023
16.2.0-previ... 170 3/19/2023
16.2.0-previ... 27 3/7/2023
16.2.0-previ... 10 3/4/2023
16.1.0 175,566 2/28/2023
16.1.0-previ... 6 2/28/2023
16.1.0-previ... 9 2/25/2023
16.1.0-previ... 6 2/24/2023
16.1.0-previ... 48 2/13/2023
16.1.0-previ... 28 2/12/2023
16.1.0-previ... 25 2/5/2023
16.1.0-previ... 11 2/1/2023
16.1.0-previ... 29 1/25/2023
16.1.0-previ... 8 1/24/2023
16.1.0-previ... 5 1/24/2023
16.1.0-previ... 12 1/22/2023
16.1.0-previ... 346 1/4/2023
16.1.0-previ... 6 1/3/2023
16.1.0-previ... 15 12/26/2022
16.1.0-previ... 50 12/19/2022
16.1.0-previ... 13 12/17/2022
16.1.0-previ... 115 12/11/2022
16.1.0-previ... 13 12/4/2022
16.1.0-previ... 36 11/26/2022
16.1.0-previ... 11 11/24/2022
16.0.1-previ... 31 11/11/2022
16.0.0 827,595 9/9/2022
16.0.0-previ... 30 8/21/2022
16.0.0-previ... 24 8/13/2022
16.0.0-previ... 15 8/13/2022
16.0.0-previ... 26 8/1/2022
16.0.0-previ... 81 6/14/2022
16.0.0-previ... 25 6/8/2022
16.0.0-previ... 18 6/6/2022
16.0.0-previ... 15 6/6/2022
16.0.0-previ... 89 4/26/2022
16.0.0-previ... 45 3/28/2022
16.0.0-previ... 66 2/12/2022
15.2.0 2,684,611 9/1/2021
15.2.0-previ... 16 9/1/2021
15.2.0-previ... 45 7/23/2021
15.2.0-previ... 76 6/6/2021
15.2.0-previ... 66 4/18/2021
15.2.0-previ... 86 3/12/2021
15.1.1 1,391,855 2/12/2021
15.1.1-previ... 18 2/12/2021
15.1.0 62,442 2/2/2021
15.1.0-previ... 25 2/1/2021
15.1.0-previ... 20 1/31/2021
15.0.2-previ... 19 1/30/2021
15.0.2-previ... 25 1/24/2021
15.0.2-previ... 63 1/21/2021
15.0.2-previ... 62 1/12/2021
15.0.1 143,076 1/9/2021
15.0.1-previ... 59 1/9/2021
15.0.1-previ... 64 1/6/2021
15.0.1-previ... 60 1/6/2021
15.0.1-previ... 69 12/27/2020
15.0.1-previ... 61 12/26/2020
15.0.1-previ... 63 12/23/2020
15.0.1-previ... 71 12/14/2020
15.0.1-previ... 62 12/13/2020
15.0.1-previ... 60 12/12/2020
15.0.1-previ... 61 12/10/2020
15.0.0 214,513 12/6/2020
15.0.0-previ... 61 12/6/2020
15.0.0-previ... 66 11/25/2020
15.0.0-previ... 58 11/22/2020
15.0.0-previ... 62 11/21/2020
14.3.0-previ... 99 10/5/2020
14.3.0-previ... 55 10/3/2020
14.3.0-previ... 61 10/2/2020
14.2.2-previ... 105 8/19/2020
14.2.2-previ... 61 8/16/2020
14.2.1 642,161 8/14/2020
14.2.1-previ... 60 8/13/2020
14.2.1-previ... 61 8/11/2020
14.2.1-previ... 57 8/11/2020
14.2.1-previ... 72 7/31/2020
14.2.1-previ... 60 7/28/2020
14.2.0 72,592 7/23/2020
14.2.0-previ... 63 7/23/2020
14.2.0-previ... 65 7/19/2020
14.2.0-previ... 74 7/13/2020
14.2.0-previ... 65 7/10/2020
14.2.0-previ... 62 7/9/2020
14.1.1-previ... 64 7/9/2020
14.1.0 221,770 7/6/2020
14.1.0-previ... 369 7/5/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 62 7/4/2020
14.1.0-previ... 64 7/3/2020
14.1.0-previ... 66 7/1/2020
14.0.1-previ... 72 6/28/2020
14.0.1-previ... 61 6/26/2020
14.0.0 (current version) 10,843 6/12/2020
14.0.0-previ... 62 6/12/2020
14.0.0-previ... 68 6/11/2020
14.0.0-previ... 70 6/10/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 103 5/28/2020
14.0.0-previ... 78 5/25/2020
14.0.0-previ... 68 5/25/2020
14.0.0-previ... 80 5/19/2020
14.0.0-previ... 76 5/19/2020
14.0.0-previ... 82 5/17/2020
14.0.0-previ... 71 5/17/2020
14.0.0-previ... 69 5/16/2020
14.0.0-previ... 70 5/14/2020
14.0.0-previ... 72 5/13/2020
14.0.0-previ... 80 5/12/2020
14.0.0-previ... 70 5/12/2020
14.0.0-previ... 70 5/12/2020
14.0.0-previ... 83 5/8/2020
14.0.0-previ... 69 5/6/2020
14.0.0-previ... 73 5/5/2020
14.0.0-previ... 71 5/4/2020
14.0.0-previ... 70 5/3/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 84 4/27/2020
14.0.0-previ... 79 4/26/2020
13.5.0 28,415 4/12/2020
13.5.0-previ... 76 4/11/2020
13.5.0-previ... 78 4/11/2020
13.4.1-previ... 105 3/31/2020
13.4.0 122,350 3/18/2020
13.4.0-previ... 71 3/18/2020
13.3.1-previ... 117 1/18/2020
13.3.0 480,496 1/17/2020
13.3.0-previ... 74 1/17/2020
13.3.0-previ... 79 1/12/2020
13.3.0-previ... 73 1/8/2020
13.3.0-previ... 76 1/7/2020
13.3.0-previ... 73 1/3/2020
13.3.0-previ... 74 1/2/2020
13.3.0-previ... 75 1/2/2020
13.2.0.0 861,904 9/19/2019
13.1.0.0 35,024 8/8/2019
13.0.0.0 26,042 6/26/2019
12.5.0.0 17,394 5/15/2019
12.4.0.0 21,746 4/3/2019
12.3.0.0 40,231 2/20/2019
12.2.0.0 9,018 1/10/2019
12.1.0.0 23,280 10/25/2018
12.0.0.0 21,441 9/5/2018
11.4.0.0 16,156 7/25/2018
11.3.0.0 7,383 6/13/2018
11.2.0.0 5,232 5/2/2018
11.1.0.0 6,228 3/22/2018
11.0.0.0 13,489 2/8/2018
10.0.0.0 3,650 12/14/2017
Show less