SqlServerDsc

12.5.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 12.5.0.0

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

Install-PSResource -Name SqlServerDsc -Version 12.5.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

(c) 2018 Microsoft Corporation. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

SqlAG SqlAGDatabase SqlAgentOperator SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlRS SqlRSSetup SqlScript SqlScriptQuery SqlServerConfiguration SqlServerDatabaseMail SqlServerEndpoint SqlServerEndpointPermission SqlServerEndpointState SqlServerLogin SqlServerMaxDop SqlServerMemory SqlServerNetwork SqlServerPermission SqlServerReplication SqlServerRole SqlServerSecureConnection SqlServiceAccount SqlSetup SqlWaitForAG SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

- Changes to SqlServerSecureConnection
 - Updated README and added example for SqlServerSecureConnection,
   instructing users to use the "SYSTEM" service account instead of
   "LocalSystem".
- Changes to SqlScript
 - Correctly passes the `$VerbosePreference` to the helper function
   `Invoke-SqlScript` so that `PRINT` statements is outputted correctly
   when verbose output is requested, e.g
   `Start-DscConfiguration -Verbose`.
 - Added en-US localization ([issue 624](https://github.com/PowerShell/SqlServerDsc/issues/624)).
 - Added additional unit tests for code coverage.
- Changes to SqlScriptQuery
 - Correctly passes the `$VerbosePreference` to the helper function
   `Invoke-SqlScript` so that `PRINT` statements is outputted correctly
   when verbose output is requested, e.g
   `Start-DscConfiguration -Verbose`.
 - Added en-US localization.
 - Added additional unit tests for code coverage.
- Changes to SqlSetup
 - Concatenated Robocopy localization strings ([issue 694](https://github.com/PowerShell/SqlServerDsc/issues/694)).
 - Made the error message more descriptive when the Set-TargetResource
   function calls the Test-TargetResource function to verify the desired
   state.
- Changes to SqlWaitForAG
 - Added en-US localization ([issue 625](https://github.com/PowerShell/SqlServerDsc/issues/625)).
- Changes to SqlServerPermission
 - Added en-US localization ([issue 619](https://github.com/PowerShell/SqlServerDsc/issues/619)).
- Changes to SqlServerMemory
 - Added en-US localization ([issue 617](https://github.com/PowerShell/SqlServerDsc/issues/617)).
 - No longer will the resource set the MinMemory value if it was provided
   in a configuration that also set the `Ensure` parameter to "Absent"
   ([issue 1329](https://github.com/PowerShell/SqlServerDsc/issues/1329)).
 - Refactored unit tests to simplify them add add slightly more code
   coverage.
- Changes to SqlServerMaxDop
 - Added en-US localization ([issue 616](https://github.com/PowerShell/SqlServerDsc/issues/616)).
- Changes to SqlRS
 - Reporting Services are restarted after changing settings, unless
   `$SuppressRestart` parameter is set ([issue 1331](https://github.com/PowerShell/SqlServerDsc/issues/1331)).
   `$SuppressRestart` will also prevent Reporting Services restart after initialization.
 - Fixed one of the error handling to use localization, and made the
   error message more descriptive when the Set-TargetResource function
   calls the Test-TargetResource function to verify the desired
   state. *This was done prior to adding full en-US localization.*
 - Fixed ([issue 1258](https://github.com/PowerShell/SqlServerDsc/issues/1258)).
   When initializing Reporting Services, there is no need to execute `InitializeReportServer`
   CIM method, since executing `SetDatabaseConnection` CIM method initializes
   Reporting Services.
 - [issue 864](https://github.com/PowerShell/SqlServerDsc/issues/864) SqlRs
   can now initialise SSRS 2017 instances
- Changes to SqlServerLogin
 - Added en-US localization ([issue 615](https://github.com/PowerShell/SqlServerDsc/issues/615)).
 - Added unit tests to improved code coverage.
- Changes to SqlWindowsFirewall
 - Added en-US localization ([issue 614](https://github.com/PowerShell/SqlServerDsc/issues/614)).
- Changes to SqlServerEndpoint
 - Added en-US localization ([issue 611](https://github.com/PowerShell/SqlServerDsc/issues/611)).
- Changes to SqlServerEndpointPermission
 - Added en-US localization ([issue 612](https://github.com/PowerShell/SqlServerDsc/issues/612)).
- Changes to SqlServerEndpointState
 - Added en-US localization ([issue 613](https://github.com/PowerShell/SqlServerDsc/issues/613)).
- Changes to SqlDatabaseRole
 - Added en-US localization ([issue 610](https://github.com/PowerShell/SqlServerDsc/issues/610)).
- Changes to SqlDatabaseRecoveryModel
 - Added en-US localization ([issue 609](https://github.com/PowerShell/SqlServerDsc/issues/609)).
- Changes to SqlDatabasePermission
 - Added en-US localization ([issue 608](https://github.com/PowerShell/SqlServerDsc/issues/608)).
- Changes to SqlDatabaseOwner
 - Added en-US localization ([issue 607](https://github.com/PowerShell/SqlServerDsc/issues/607)).
- Changes to SqlDatabase
 - Added en-US localization ([issue 606](https://github.com/PowerShell/SqlServerDsc/issues/606)).
- Changes to SqlAGListener
 - Added en-US localization ([issue 604](https://github.com/PowerShell/SqlServerDsc/issues/604)).
- Changes to SqlAlwaysOnService
 - Added en-US localization ([issue 603](https://github.com/PowerShell/SqlServerDsc/issues/608)).
- Changes to SqlAlias
 - Added en-US localization ([issue 602](https://github.com/PowerShell/SqlServerDsc/issues/602)).
 - Removed ShouldProcess for the code, since it has no purpose in a DSC
   resource ([issue 242](https://github.com/PowerShell/SqlServerDsc/issues/242)).
- Changes to SqlServerReplication
 - Added en-US localization ([issue 620](https://github.com/PowerShell/SqlServerDsc/issues/620)).
 - Refactored Get-TargetResource slightly so it provide better verbose
   messages.

FileList

Version History

Version Downloads Last updated
16.6.0-previ... 79 3/3/2024
16.6.0-previ... 45 1/20/2024
16.6.0-previ... 5 1/19/2024
16.5.1-previ... 67 12/15/2023
16.5.1-previ... 90 11/19/2023
16.5.1-previ... 46 11/2/2023
16.5.0 135,303 10/5/2023
16.5.0-previ... 11 10/1/2023
16.5.0-previ... 6 9/29/2023
16.5.0-previ... 46 9/1/2023
16.5.0-previ... 6 8/26/2023
16.4.1-previ... 5 8/25/2023
16.4.0 111,242 8/22/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 5 8/19/2023
16.4.0-previ... 75 5/18/2023
16.4.0-previ... 19 5/10/2023
16.4.0-previ... 5 5/9/2023
16.4.0-previ... 6 5/8/2023
16.3.1 459,332 5/6/2023
16.3.1-previ... 4 5/6/2023
16.3.1-previ... 8 5/4/2023
16.3.0 42,101 4/26/2023
16.3.0-previ... 6 4/26/2023
16.3.0-previ... 5 4/25/2023
16.3.0-previ... 5 4/24/2023
16.3.0-previ... 5 4/23/2023
16.3.0-previ... 20 4/18/2023
16.3.0-previ... 4 4/16/2023
16.2.1-previ... 6 4/12/2023
16.2.0 74,988 4/10/2023
16.2.0-previ... 4 4/10/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 9 4/6/2023
16.2.0-previ... 9 4/1/2023
16.2.0-previ... 10 3/28/2023
16.2.0-previ... 9 3/26/2023
16.2.0-previ... 4 3/25/2023
16.2.0-previ... 169 3/19/2023
16.2.0-previ... 26 3/7/2023
16.2.0-previ... 9 3/4/2023
16.1.0 175,451 2/28/2023
16.1.0-previ... 5 2/28/2023
16.1.0-previ... 8 2/25/2023
16.1.0-previ... 5 2/24/2023
16.1.0-previ... 47 2/13/2023
16.1.0-previ... 27 2/12/2023
16.1.0-previ... 24 2/5/2023
16.1.0-previ... 10 2/1/2023
16.1.0-previ... 28 1/25/2023
16.1.0-previ... 7 1/24/2023
16.1.0-previ... 4 1/24/2023
16.1.0-previ... 11 1/22/2023
16.1.0-previ... 345 1/4/2023
16.1.0-previ... 5 1/3/2023
16.1.0-previ... 14 12/26/2022
16.1.0-previ... 49 12/19/2022
16.1.0-previ... 12 12/17/2022
16.1.0-previ... 114 12/11/2022
16.1.0-previ... 12 12/4/2022
16.1.0-previ... 35 11/26/2022
16.1.0-previ... 10 11/24/2022
16.0.1-previ... 30 11/11/2022
16.0.0 826,587 9/9/2022
16.0.0-previ... 29 8/21/2022
16.0.0-previ... 23 8/13/2022
16.0.0-previ... 14 8/13/2022
16.0.0-previ... 25 8/1/2022
16.0.0-previ... 80 6/14/2022
16.0.0-previ... 24 6/8/2022
16.0.0-previ... 17 6/6/2022
16.0.0-previ... 14 6/6/2022
16.0.0-previ... 88 4/26/2022
16.0.0-previ... 44 3/28/2022
16.0.0-previ... 65 2/12/2022
15.2.0 2,683,576 9/1/2021
15.2.0-previ... 15 9/1/2021
15.2.0-previ... 44 7/23/2021
15.2.0-previ... 75 6/6/2021
15.2.0-previ... 65 4/18/2021
15.2.0-previ... 85 3/12/2021
15.1.1 1,379,278 2/12/2021
15.1.1-previ... 17 2/12/2021
15.1.0 62,279 2/2/2021
15.1.0-previ... 24 2/1/2021
15.1.0-previ... 19 1/31/2021
15.0.2-previ... 18 1/30/2021
15.0.2-previ... 24 1/24/2021
15.0.2-previ... 62 1/21/2021
15.0.2-previ... 61 1/12/2021
15.0.1 143,028 1/9/2021
15.0.1-previ... 58 1/9/2021
15.0.1-previ... 63 1/6/2021
15.0.1-previ... 59 1/6/2021
15.0.1-previ... 68 12/27/2020
15.0.1-previ... 59 12/26/2020
15.0.1-previ... 62 12/23/2020
15.0.1-previ... 70 12/14/2020
15.0.1-previ... 61 12/13/2020
15.0.1-previ... 59 12/12/2020
15.0.1-previ... 60 12/10/2020
15.0.0 213,987 12/6/2020
15.0.0-previ... 60 12/6/2020
15.0.0-previ... 65 11/25/2020
15.0.0-previ... 57 11/22/2020
15.0.0-previ... 61 11/21/2020
14.3.0-previ... 98 10/5/2020
14.3.0-previ... 54 10/3/2020
14.3.0-previ... 60 10/2/2020
14.2.2-previ... 104 8/19/2020
14.2.2-previ... 60 8/16/2020
14.2.1 639,684 8/14/2020
14.2.1-previ... 59 8/13/2020
14.2.1-previ... 60 8/11/2020
14.2.1-previ... 56 8/11/2020
14.2.1-previ... 71 7/31/2020
14.2.1-previ... 59 7/28/2020
14.2.0 72,555 7/23/2020
14.2.0-previ... 62 7/23/2020
14.2.0-previ... 64 7/19/2020
14.2.0-previ... 73 7/13/2020
14.2.0-previ... 64 7/10/2020
14.2.0-previ... 61 7/9/2020
14.1.1-previ... 63 7/9/2020
14.1.0 216,682 7/6/2020
14.1.0-previ... 367 7/5/2020
14.1.0-previ... 60 7/4/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 63 7/3/2020
14.1.0-previ... 65 7/1/2020
14.0.1-previ... 71 6/28/2020
14.0.1-previ... 60 6/26/2020
14.0.0 10,834 6/12/2020
14.0.0-previ... 61 6/12/2020
14.0.0-previ... 67 6/11/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 68 6/10/2020
14.0.0-previ... 102 5/28/2020
14.0.0-previ... 77 5/25/2020
14.0.0-previ... 67 5/25/2020
14.0.0-previ... 79 5/19/2020
14.0.0-previ... 75 5/19/2020
14.0.0-previ... 81 5/17/2020
14.0.0-previ... 70 5/17/2020
14.0.0-previ... 68 5/16/2020
14.0.0-previ... 69 5/14/2020
14.0.0-previ... 71 5/13/2020
14.0.0-previ... 79 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 82 5/8/2020
14.0.0-previ... 68 5/6/2020
14.0.0-previ... 72 5/5/2020
14.0.0-previ... 70 5/4/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 68 5/3/2020
14.0.0-previ... 83 4/27/2020
14.0.0-previ... 78 4/26/2020
13.5.0 28,256 4/12/2020
13.5.0-previ... 75 4/11/2020
13.5.0-previ... 77 4/11/2020
13.4.1-previ... 104 3/31/2020
13.4.0 122,342 3/18/2020
13.4.0-previ... 70 3/18/2020
13.3.1-previ... 116 1/18/2020
13.3.0 480,197 1/17/2020
13.3.0-previ... 73 1/17/2020
13.3.0-previ... 78 1/12/2020
13.3.0-previ... 72 1/8/2020
13.3.0-previ... 75 1/7/2020
13.3.0-previ... 72 1/3/2020
13.3.0-previ... 73 1/2/2020
13.3.0-previ... 74 1/2/2020
13.2.0.0 860,530 9/19/2019
13.1.0.0 34,990 8/8/2019
13.0.0.0 26,018 6/26/2019
12.5.0.0 (current version) 17,342 5/15/2019
12.4.0.0 21,698 4/3/2019
12.3.0.0 40,221 2/20/2019
12.2.0.0 8,926 1/10/2019
12.1.0.0 23,219 10/25/2018
12.0.0.0 21,421 9/5/2018
11.4.0.0 16,150 7/25/2018
11.3.0.0 7,375 6/13/2018
11.2.0.0 5,032 5/2/2018
11.1.0.0 6,197 3/22/2018
11.0.0.0 12,845 2/8/2018
10.0.0.0 3,648 12/14/2017
Show less