SqlServerDsc

15.0.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 15.0.1

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

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 SqlConfiguration SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseMail SqlDatabaseObjectPermission SqlDatabasePermission SqlDatabaseRole SqlDatabaseUser SqlEndpoint SqlEndpointPermission SqlLogin SqlMaxDop SqlMemory SqlPermission SqlProtocol SqlProtocolTcpIp SqlReplication SqlRole SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlSecureConnection SqlServiceAccount SqlSetup SqlTraceFlag SqlWaitForAG SqlWindowsFirewall SqlDatabaseOwner SqlDatabaseRecoveryModel SqlServerEndpointState SqlServerNetwork

Dependencies

This module has no dependencies.

Release Notes

## [15.0.1] - 2021-01-09

### Changed

- SqlServerDsc
 - Renamed `master` branch to `main` ([issue #1660](https://github.com/dsccommunity/SqlServerDsc/issues/1660)).
 - The module manifest property `DscResourcesToExport` now updates automatically
   using the pipeline.
 - Removed `Export-ModuleMember` from DSC resource that still had it.
 - The variable `$env:COMPUTERNAME` does not exist cross-platform which
   hinders development and testing on macOS and Linux. Instead the
   resources have been update to use the helper function `Get-ComputerName`
   which returns the current computer name cross-plattform.

### Fixed

- SqlAGDatabase
 - Fix for issue ([issue #1492](https://github.com/dsccommunity/SqlServerDsc/issues/1492))
   added AutomaticSeeding for this resource. In Set-TargetResource added logic that looks
   at all replicas of an availability group. When automatic seeding is found, it will use that.
 - Lots of extra tests to check AutomaticSeeding.
 - The parameter `BackupPath` is still needed just in case a database never has been backuped before.
 - Fixed a typo.
- SqlMaxDop
 - Fixes ([issue #396](https://github.com/dsccommunity/SqlServerDsc/issues/396)).
   Added three return values in Get-Target resource.
- SqlProtocol
 - Changed KeepAlive Type from UInt16 to Int32 to reflect the actual WMI.ManagementObject
   Fixes #1645 ([issue #1645](https://github.com/dsccommunity/SqlServerDsc/issues/1645)).
 - The verbose messages now correctly show that `$env:COMPUTERNAME` is used
   to get or set the configuration, while parameter **ServerName** is used
   to restart the instance.
- SqlProtocolTcpIp
 - The verbose messages now correctly show that `$env:COMPUTERNAME` is used
   to get or set the configuration, while parameter **ServerName** is used
   to restart the instance.
- SqlDatabaseMail
 - Now if a non-mandatory property is not part of the configuration it will
   not be enforced ([issue #1661](https://github.com/dsccommunity/SqlServerDsc/issues/1661)).
- SqlSetup
 - When the SqlSetup detects that the expected components was not installed
   and consequently throws an exception, that exception message now presents
   a link to an article on how to find the SQL Server setup logs ([issue #1420](https://github.com/dsccommunity/SqlServerDsc/issues/1420)).
- SqlRSSetup
 - If parameter `EditionUpgrade` is set to `$false` the `/EditionUpgrade`
   argument is no longer wrongly added ([issue #1398](https://github.com/dsccommunity/SqlServerDsc/issues/1398)).
- SqlServerDsc.Common
 - Updated `Get-ServerProtocolObject`, helper function to ensure an exception is
   thrown if the specified instance cannot be obtained ([issue #1628](https://github.com/dsccommunity/SqlServerDsc/issues/1628)).

Version History

Version Downloads Last updated
16.0.0-previ... 24 2/22/2021
15.1.1 122,432 2/12/2021
15.1.1-previ... 3 2/12/2021
15.1.0 58,838 2/2/2021
15.1.0-previ... 9 2/1/2021
15.1.0-previ... 5 1/31/2021
15.0.2-previ... 4 1/30/2021
15.0.2-previ... 11 1/24/2021
15.0.2-previ... 8 1/21/2021
15.0.2-previ... 7 1/12/2021
15.0.1 (current version) 141,557 1/9/2021
15.0.1-previ... 5 1/9/2021
15.0.1-previ... 8 1/6/2021
15.0.1-previ... 5 1/6/2021
15.0.1-previ... 13 12/27/2020
15.0.1-previ... 6 12/26/2020
15.0.1-previ... 6 12/23/2020
15.0.1-previ... 16 12/14/2020
15.0.1-previ... 5 12/13/2020
15.0.1-previ... 5 12/12/2020
15.0.1-previ... 5 12/10/2020
15.0.0 204,877 12/6/2020
15.0.0-previ... 5 12/6/2020
15.0.0-previ... 11 11/25/2020
15.0.0-previ... 5 11/22/2020
15.0.0-previ... 5 11/21/2020
14.3.0-previ... 42 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 621,604 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,615 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 104,838 7/6/2020
14.1.0-previ... 71 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,908 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 25,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,724 3/18/2020
13.4.0-previ... 5 3/18/2020
13.3.1-previ... 52 1/18/2020
13.3.0 466,079 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 779,092 9/19/2019
13.1.0.0 34,476 8/8/2019
13.0.0.0 25,870 6/26/2019
12.5.0.0 16,310 5/15/2019
12.4.0.0 21,328 4/3/2019
12.3.0.0 39,744 2/20/2019
12.2.0.0 8,541 1/10/2019
12.1.0.0 22,351 10/25/2018
12.0.0.0 21,162 9/5/2018
11.4.0.0 16,026 7/25/2018
11.3.0.0 7,208 6/13/2018
11.2.0.0 3,893 5/2/2018
11.1.0.0 5,874 3/22/2018
11.0.0.0 8,420 2/8/2018
10.0.0.0 3,532 12/14/2017
Show less