SqlServerDsc

11.4.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 11.4.0.0

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

Install-PSResource -Name SqlServerDsc -Version 11.4.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 SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlRS SqlScript SqlScriptQuery SqlServerConfiguration SqlServerDatabaseMail SqlServerEndpoint SqlServerEndpointPermission SqlServerEndpointState SqlServerLogin SqlServerMaxDop SqlServerMemory SqlServerNetwork SqlServerPermission SqlServerReplication SqlServerRole SqlServiceAccount SqlSetup SqlWaitForAG SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

- Changes to SqlServerDsc
 - Updated helper function Restart-SqlService to have to new optional parameters
   `SkipClusterCheck` and `SkipWaitForOnline`. This was to support more aspects
   of the resource SqlServerNetwork.
 - Updated helper function `Import-SQLPSModule`
   - To only import module if the
     module does not exist in the session.
   - To always import the latest version of "SqlServer" or "SQLPS" module, if
     more than one version exist on the target node. It will still prefer to
     use "SqlServer" module.
 - Updated all the examples and integration tests to not use
   `PSDscAllowPlainTextPassword`, so examples using credentials or
   passwords by default are secure.
- Changes to SqlAlwaysOnService
 - Integration tests was updated to handle new IPv6 addresses on the AppVeyor
   build worker ([issue 1155](https://github.com/PowerShell/SqlServerDsc/issues/1155)).
- Changes to SqlServerNetwork
 - Refactor SqlServerNetwork to not load assembly from GAC ([issue 1151](https://github.com/PowerShell/SqlServerDsc/issues/1151)).
 - The resource now supports restarting the SQL Server service when both
   enabling and disabling the protocol.
 - Added integration tests for this resource
   ([issue 751](https://github.com/PowerShell/SqlServerDsc/issues/751)).
- Changes to SqlAG
 - Removed excess `Import-SQLPSModule` call.
- Changes to SqlSetup
 - Now after a successful install the "SQL PowerShell module" is reevaluated and
   forced to be reimported into the session. This is to support that a never
   version of SQL Server was installed side-by-side so that SQLPS module should
   be used instead.

FileList

Version History

Version Downloads Last updated
16.6.0-previ... 89 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 136,424 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,387 5/6/2023
16.3.1-previ... 4 5/6/2023
16.3.1-previ... 8 5/4/2023
16.3.0 42,103 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,991 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,465 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,629 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,630 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,463 2/12/2021
15.1.1-previ... 17 2/12/2021
15.1.0 62,284 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,033 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,999 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,716 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,570 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 217,414 7/6/2020
14.1.0-previ... 368 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,263 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,200 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,588 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 17,355 5/15/2019
12.4.0.0 21,699 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 (current version) 16,150 7/25/2018
11.3.0.0 7,377 6/13/2018
11.2.0.0 5,039 5/2/2018
11.1.0.0 6,197 3/22/2018
11.0.0.0 12,854 2/8/2018
10.0.0.0 3,648 12/14/2017
Show less