SqlServerDsc
12.5.0.0
Module with DSC Resources for deployment and configuration of Microsoft SQL Server.
Minimum PowerShell version
5.0
See the version list below for details.
Installation Options
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
- SqlServerDsc.nuspec
- Assert-TestEnvironment.ps1
- CHANGELOG.md
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- README.md
- SqlServerDsc.psd1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.psm1
- DSCResources\MSFT_SqlAG\MSFT_SqlAG.schema.mof
- DSCResources\MSFT_SqlAGDatabase\MSFT_SqlAGDatabase.psm1
- DSCResources\MSFT_SqlAGDatabase\MSFT_SqlAGDatabase.schema.mof
- DSCResources\MSFT_SqlAGDatabase\en-US\about_SqlAGDatabase.help.txt
- DSCResources\MSFT_SqlAGDatabase\en-US\MSFT_SqlAGDatabase.strings.psd1
- DSCResources\MSFT_SqlAgentOperator\MSFT_SqlAgentOperator.psm1
- DSCResources\MSFT_SqlAgentOperator\MSFT_SqlAgentOperator.schema.mof
- DSCResources\MSFT_SqlAgentOperator\en-US\MSFT_SqlAgentOperator.strings.psd1
- DSCResources\MSFT_SqlAGListener\MSFT_SqlAGListener.psm1
- DSCResources\MSFT_SqlAGListener\MSFT_SqlAGListener.schema.mof
- DSCResources\MSFT_SqlAGListener\en-US\MSFT_SqlAGListener.strings.psd1
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.psm1
- DSCResources\MSFT_SqlAGReplica\MSFT_SqlAGReplica.schema.mof
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.psm1
- DSCResources\MSFT_SqlAlias\MSFT_SqlAlias.schema.mof
- DSCResources\MSFT_SqlAlias\en-US\MSFT_SqlAlias.strings.psd1
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.psm1
- DSCResources\MSFT_SqlAlwaysOnService\MSFT_SqlAlwaysOnService.schema.mof
- DSCResources\MSFT_SqlAlwaysOnService\en-US\MSFT_SqlAlwaysOnService.strings.psd1
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.psm1
- DSCResources\MSFT_SqlDatabase\MSFT_SqlDatabase.schema.mof
- DSCResources\MSFT_SqlDatabase\en-US\MSFT_SqlDatabase.strings.psd1
- DSCResources\MSFT_SqlDatabaseDefaultLocation\MSFT_SqlDatabaseDefaultLocation.psm1
- DSCResources\MSFT_SqlDatabaseDefaultLocation\MSFT_SqlDatabaseDefaultLocation.schema.mof
- DSCResources\MSFT_SqlDatabaseDefaultLocation\en-US\MSFT_SqlDatabaseDefaultLocation.strings.psd1
- DSCResources\MSFT_SqlDatabaseOwner\MSFT_SqlDatabaseOwner.psm1
- DSCResources\MSFT_SqlDatabaseOwner\MSFT_SqlDatabaseOwner.schema.mof
- DSCResources\MSFT_SqlDatabaseOwner\en-US\MSFT_SqlDatabaseOwner.strings.psd1
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.psm1
- DSCResources\MSFT_SqlDatabasePermission\MSFT_SqlDatabasePermission.schema.mof
- DSCResources\MSFT_SqlDatabasePermission\en-US\MSFT_SqlDatabasePermission.strings.psd1
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.psm1
- DSCResources\MSFT_SqlDatabaseRecoveryModel\MSFT_SqlDatabaseRecoveryModel.schema.mof
- DSCResources\MSFT_SqlDatabaseRecoveryModel\en-US\MSFT_SqlDatabaseRecoveryModel.strings.psd1
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.psm1
- DSCResources\MSFT_SqlDatabaseRole\MSFT_SqlDatabaseRole.schema.mof
- DSCResources\MSFT_SqlDatabaseRole\en-US\MSFT_SqlDatabaseRole.strings.psd1
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.psm1
- DSCResources\MSFT_SqlRS\MSFT_SqlRS.schema.mof
- DSCResources\MSFT_SqlRS\en-US\MSFT_SqlRS.strings.psd1
- DSCResources\MSFT_SqlRSSetup\MSFT_SqlRSSetup.psm1
- DSCResources\MSFT_SqlRSSetup\MSFT_SqlRSSetup.schema.mof
- DSCResources\MSFT_SqlRSSetup\en-US\MSFT_SqlRSSetup.strings.psd1
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.psm1
- DSCResources\MSFT_SqlScript\MSFT_SqlScript.schema.mof
- DSCResources\MSFT_SqlScript\en-US\MSFT_SqlScript.strings.psd1
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.psm1
- DSCResources\MSFT_SqlScriptQuery\MSFT_SqlScriptQuery.schema.mof
- DSCResources\MSFT_SqlScriptQuery\en-US\MSFT_SqlScriptQuery.strings.psd1
- DSCResources\MSFT_SqlServerConfiguration\MSFT_SqlServerConfiguration.psm1
- DSCResources\MSFT_SqlServerConfiguration\MSFT_SqlServerConfiguration.schema.mof
- DSCResources\MSFT_SqlServerConfiguration\en-US\MSFT_SqlServerConfiguration.strings.psd1
- DSCResources\MSFT_SqlServerDatabaseMail\MSFT_SqlServerDatabaseMail.psm1
- DSCResources\MSFT_SqlServerDatabaseMail\MSFT_SqlServerDatabaseMail.schema.mof
- DSCResources\MSFT_SqlServerDatabaseMail\en-US\MSFT_SqlServerDatabaseMail.strings.psd1
- DSCResources\MSFT_SqlServerEndpoint\MSFT_SqlServerEndpoint.psm1
- DSCResources\MSFT_SqlServerEndpoint\MSFT_SqlServerEndpoint.schema.mof
- DSCResources\MSFT_SqlServerEndpoint\en-US\MSFT_SqlServerEndpoint.strings.psd1
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.psm1
- DSCResources\MSFT_SqlServerEndpointPermission\MSFT_SqlServerEndpointPermission.schema.mof
- DSCResources\MSFT_SqlServerEndpointPermission\en-US\MSFT_SqlServerEndpointPermission.strings.psd1
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.psm1
- DSCResources\MSFT_SqlServerEndpointState\MSFT_SqlServerEndpointState.schema.mof
- DSCResources\MSFT_SqlServerEndpointState\en-US\MSFT_SqlServerEndpointState.strings.psd1
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.psm1
- DSCResources\MSFT_SqlServerLogin\MSFT_SqlServerLogin.schema.mof
- DSCResources\MSFT_SqlServerLogin\en-US\MSFT_SqlServerLogin.strings.psd1
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.psm1
- DSCResources\MSFT_SqlServerMaxDop\MSFT_SqlServerMaxDop.schema.mof
- DSCResources\MSFT_SqlServerMaxDop\en-US\MSFT_SqlServerMaxDop.strings.psd1
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.psm1
- DSCResources\MSFT_SqlServerMemory\MSFT_SqlServerMemory.schema.mof
- DSCResources\MSFT_SqlServerMemory\en-US\MSFT_SqlServerMemory.strings.psd1
- DSCResources\MSFT_SqlServerNetwork\MSFT_SqlServerNetwork.psm1
- DSCResources\MSFT_SqlServerNetwork\MSFT_SqlServerNetwork.schema.mof
- DSCResources\MSFT_SqlServerNetwork\en-US\MSFT_SqlServerNetwork.strings.psd1
- DSCResources\MSFT_SqlServerPermission\MSFT_SqlServerPermission.psm1
- DSCResources\MSFT_SqlServerPermission\MSFT_SqlServerPermission.schema.mof
- DSCResources\MSFT_SqlServerPermission\en-US\MSFT_SqlServerPermission.strings.psd1
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.psm1
- DSCResources\MSFT_SqlServerReplication\MSFT_SqlServerReplication.schema.mof
- DSCResources\MSFT_SqlServerReplication\en-US\MSFT_SqlServerReplication.strings.psd1
- DSCResources\MSFT_SqlServerRole\MSFT_SqlServerRole.psm1
- DSCResources\MSFT_SqlServerRole\MSFT_SqlServerRole.schema.mof
- DSCResources\MSFT_SqlServerRole\en-US\MSFT_SqlServerRole.strings.psd1
- DSCResources\MSFT_SqlServerSecureConnection\MSFT_SqlServerSecureConnection.psm1
- DSCResources\MSFT_SqlServerSecureConnection\MSFT_SqlServerSecureConnection.schema.mof
- DSCResources\MSFT_SqlServerSecureConnection\en-US\MSFT_SqlServerSecureConnection.strings.psd1
- DSCResources\MSFT_SqlServiceAccount\MSFT_SqlServiceAccount.psm1
- DSCResources\MSFT_SqlServiceAccount\MSFT_SqlServiceAccount.schema.mof
- DSCResources\MSFT_SqlServiceAccount\en-US\MSFT_SqlServiceAccount.strings.psd1
- DSCResources\MSFT_SqlSetup\MSFT_SqlSetup.psm1
- DSCResources\MSFT_SqlSetup\MSFT_SqlSetup.schema.mof
- DSCResources\MSFT_SqlSetup\en-US\MSFT_SqlSetup.strings.psd1
- DSCResources\MSFT_SqlSetup\sv-SE\MSFT_SqlSetup.strings.psd1
- DSCResources\MSFT_SqlWaitForAG\MSFT_SqlWaitForAG.psm1
- DSCResources\MSFT_SqlWaitForAG\MSFT_SqlWaitForAG.schema.mof
- DSCResources\MSFT_SqlWaitForAG\en-US\MSFT_SqlWaitForAG.strings.psd1
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.psm1
- DSCResources\MSFT_SqlWindowsFirewall\MSFT_SqlWindowsFirewall.schema.mof
- DSCResources\MSFT_SqlWindowsFirewall\en-US\MSFT_SqlWindowsFirewall.strings.psd1
- Examples\README.md
- Examples\Resources\SqlAG\1-CreateAvailabilityGroup.ps1
- Examples\Resources\SqlAG\2-RemoveAvailabilityGroup.ps1
- Examples\Resources\SqlAG\3-CreateAvailabilityGroupDetailed.ps1
- Examples\Resources\SqlAGDatabase\1-AddDatabaseToAvailabilityGroup.ps1
- Examples\Resources\SqlAGDatabase\2-RemoveDatabaseFromAvailabilityGroup.ps1
- Examples\Resources\SqlAGDatabase\3-MatchDefinedDatabaseInAvailabilityGroup.ps1
- Examples\Resources\SqlAgentOperator\1-AddOperator.ps1
- Examples\Resources\SqlAgentOperator\2-RemoveOperator.ps1
- Examples\Resources\SqlAGListener\1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\SqlAGListener\2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\SqlAGListener\3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\SqlAGListener\4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\SqlAGListener\5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1
- Examples\Resources\SqlAGListener\6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1
- Examples\Resources\SqlAGReplica\1-CreateAvailabilityGroupReplica.ps1
- Examples\Resources\SqlAGReplica\2-RemoveAvailabilityGroupReplica.ps1
- Examples\Resources\SqlAlias\1-AddSqlAlias.ps1
- Examples\Resources\SqlAlias\2-RemoveSqlAlias.ps1
- Examples\Resources\SqlAlwaysOnService\1-EnableAlwaysOn.ps1
- Examples\Resources\SqlAlwaysOnService\2-DisableAlwaysOn.ps1
- Examples\Resources\SqlDatabase\1-CreateDatabase.ps1
- Examples\Resources\SqlDatabase\2-DeleteDatabase.ps1
- Examples\Resources\SqlDatabaseDefaultLocation\1-SetDatabaseDefaultLocation.ps1
- Examples\Resources\SqlDatabaseOwner\1-SetDatabaseOwner.ps1
- Examples\Resources\SqlDatabasePermission\1-GrantDatabasePermissions.ps1
- Examples\Resources\SqlDatabasePermission\2-RevokeDatabasePermissions.ps1
- Examples\Resources\SqlDatabasePermission\3-DenyDatabasePermissions.ps1
- Examples\Resources\SqlDatabaseRecoveryModel\1-SetDatabaseRecoveryModel.ps1
- Examples\Resources\SqlDatabaseRole\1-AddDatabaseRole.ps1
- Examples\Resources\SqlDatabaseRole\2-RemoveDatabaseRole.ps1
- Examples\Resources\SqlRS\1-DefaultConfiguration.ps1
- Examples\Resources\SqlRS\2-CustomConfiguration.ps1
- Examples\Resources\SqlRS\3-CustomConfigurationUsingSsl.ps1
- Examples\Resources\SqlRS\4-CompleteWithTwoInstances.ps1
- Examples\Resources\SqlRSSetup\1-InstallReportingServices.ps1
- Examples\Resources\SqlRSSetup\2-UninstallReportingServices.ps1
- Examples\Resources\SqlScript\1-RunScriptUsingSQLAuthentication.ps1
- Examples\Resources\SqlScript\2-RunScriptUsingWindowsAuthentication.ps1
- Examples\Resources\SqlScript\3-RunScriptCompleteExample.ps1
- Examples\Resources\SqlScriptQuery\1-RunScriptUsingSQLAuthentication.ps1
- Examples\Resources\SqlScriptQuery\2-RunScriptUsingWindowsAuthentication.ps1
- Examples\Resources\SqlScriptQuery\3-RunScriptCompleteExample.ps1
- Examples\Resources\SqlServerConfiguration\1-ConfigureTwoInstancesOnTheSameServerToEnableClr.ps1
- Examples\Resources\SqlServerConfiguration\2-ConfigureInstanceToEnablePriorityBoost.ps1
- Examples\Resources\SqlServerDatabaseMail\1-EnableDatabaseMail.ps1
- Examples\Resources\SqlServerDatabaseMail\2-DisableDatabaseMail.ps1
- Examples\Resources\SqlServerEndpoint\1-CreateEndpointWithDefaultValues.ps1
- Examples\Resources\SqlServerEndpoint\2-CreateEndpointWithSpecificPortIPAddressOwner.ps1
- Examples\Resources\SqlServerEndpoint\3-RemoveEndpoint.ps1
- Examples\Resources\SqlServerEndpointPermission\1-AddConnectPermission.ps1
- Examples\Resources\SqlServerEndpointPermission\2-RemoveConnectPermission.ps1
- Examples\Resources\SqlServerEndpointPermission\3-AddConnectPermissionToTwoReplicasEachWithDifferentServiceAccount.ps1
- Examples\Resources\SqlServerEndpointPermission\4-RemoveConnectPermissionForTwoReplicasEachWithDifferentServiceAccount.ps1
- Examples\Resources\SqlServerEndpointState\1-MakeSureEndpointIsStarted.ps1
- Examples\Resources\SqlServerEndpointState\2-MakeSureEndpointIsStopped.ps1
- Examples\Resources\SqlServerLogin\1-AddLogin.ps1
- Examples\Resources\SqlServerLogin\2-RemoveLogin.ps1
- Examples\Resources\SqlServerMaxDop\1-SetMaxDopToOne.ps1
- Examples\Resources\SqlServerMaxDop\2-SetMaxDopToAuto.ps1
- Examples\Resources\SqlServerMaxDop\3-SetMaxDopToDefault.ps1
- Examples\Resources\SqlServerMemory\1-SetMaxMemoryTo12GB.ps1
- Examples\Resources\SqlServerMemory\2-SetMaxMemoryToAuto.ps1
- Examples\Resources\SqlServerMemory\3-SetMinMemoryToFixedValueAndMaxMemoryToAuto.ps1
- Examples\Resources\SqlServerMemory\4-SetMaxMemoryToDefault.ps1
- Examples\Resources\SqlServerNetwork\1-EnableTcpIpWithStaticPort.ps1
- Examples\Resources\SqlServerNetwork\2-EnableTcpIpWithDynamicPort.ps1
- Examples\Resources\SqlServerPermission\1-AddServerPermissionForLogin.ps1
- Examples\Resources\SqlServerPermission\2-RemoveServerPermissionForLogin.ps1
- Examples\Resources\SqlServerReplication\1-ConfigureInstanceAsDistributor.ps1
- Examples\Resources\SqlServerReplication\2-ConfigureInstanceAsPublisher.ps1
- Examples\Resources\SqlServerRole\1-AddServerRole.ps1
- Examples\Resources\SqlServerRole\2-RemoveServerRole.ps1
- Examples\Resources\SqlServerRole\3-AddMembersToServerRole.ps1
- Examples\Resources\SqlServerRole\4-MembersToIncludeInServerRole.ps1
- Examples\Resources\SqlServerRole\5-MembersToExcludeInServerRole.ps1
- Examples\Resources\SqlServerSecureConnection\1-ForceSecureConnection.ps1
- Examples\Resources\SqlServerSecureConnection\2-SecureConnectionNotForced.ps1
- Examples\Resources\SqlServerSecureConnection\3-SecureConnectionAbsent.ps1
- Examples\Resources\SqlServerSecureConnection\4-SecureConnectionUsingSYSTEMAccount.ps1
- Examples\Resources\SqlServiceAccount\1-ConfigureServiceAccount-UserAccount.ps1
- Examples\Resources\SqlServiceAccount\2-ConfigureServiceAccount-VirtualAccount.ps1
- Examples\Resources\SqlSetup\1-InstallDefaultInstanceSingleServer.ps1
- Examples\Resources\SqlSetup\2-InstallNamedInstanceSingleServer.ps1
- Examples\Resources\SqlSetup\3-InstallNamedInstanceSingleServerFromUncPathUsingSourceCredential.ps1
- Examples\Resources\SqlSetup\4-InstallNamedInstanceInFailoverClusterFirstNode.ps1
- Examples\Resources\SqlSetup\5-InstallNamedInstanceInFailoverClusterSecondNode.ps1
- Examples\Resources\SqlSetup\6-InstallNamedInstanceSingleServerWithAgtSvcStartupTypeDisabled.ps1
- Examples\Resources\SqlSetup\7-InstallDefaultInstanceSingleServer2016OrLater.ps1
- Examples\Resources\SqlWaitForAG\1-WaitForASingleClusterGroup.ps1
- Examples\Resources\SqlWaitForAG\2-WaitForMultipleClusterGroups.ps1
- Examples\Resources\SqlWindowsFirewall\1-CreateInboundFirewallRules.ps1
- Examples\Resources\SqlWindowsFirewall\2-RemoveInboundFirewallRules.ps1
- Modules\DscResource.Common\DscResource.Common.psm1
- Modules\DscResource.Common\en-US\DscResource.Common.strings.psd1
- Modules\DscResource.Common\sv-SE\DscResource.Common.strings.psd1
- Modules\DscResource.LocalizationHelper\DscResource.LocalizationHelper.psm1
- Tests\Tests.depend.psd1
- Tests\Integration\MSFT_SqlAgentOperator.config.ps1
- Tests\Integration\MSFT_SqlAgentOperator.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlAlwaysOnService.config.ps1
- Tests\Integration\MSFT_SqlAlwaysOnService.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.config.ps1
- Tests\Integration\MSFT_SqlDatabaseDefaultLocation.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlRS.config.ps1
- Tests\Integration\MSFT_SqlRS.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlRSSetup.config.ps1
- Tests\Integration\MSFT_SqlRSSetup.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlScript.config.ps1
- Tests\Integration\MSFT_SqlScript.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlScriptQuery.config.ps1
- Tests\Integration\MSFT_SqlScriptQuery.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerDatabaseMail.config.ps1
- Tests\Integration\MSFT_SqlServerDatabaseMail.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerEndPoint.config.ps1
- Tests\Integration\MSFT_SqlServerEndPoint.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerLogin.config.ps1
- Tests\Integration\MSFT_SqlServerLogin.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerNetwork.config.ps1
- Tests\Integration\MSFT_SqlServerNetwork.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerRole.config.ps1
- Tests\Integration\MSFT_SqlServerRole.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServerSecureConnection.config.ps1
- Tests\Integration\MSFT_SqlServerSecureConnection.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlServiceAccount.config.ps1
- Tests\Integration\MSFT_SqlServiceAccount.Integration.Tests.ps1
- Tests\Integration\MSFT_SqlSetup.config.ps1
- Tests\Integration\MSFT_SqlSetup.Integration.Tests.ps1
- Tests\Integration\README.md
- Tests\TestHelpers\CommonTestHelper.psm1
- Tests\Unit\DscResource.Common.Tests.ps1
- Tests\Unit\DscResource.LocalizationHelper.Tests.ps1
- Tests\Unit\MSFT_SqlAG.Tests.ps1
- Tests\Unit\MSFT_SqlAGDatabase.Tests.ps1
- Tests\Unit\MSFT_SqlAgentOperator.Tests.ps1
- Tests\Unit\MSFT_SqlAGListener.Tests.ps1
- Tests\Unit\MSFT_SqlAGReplica.Tests.ps1
- Tests\Unit\MSFT_SqlAlias.Tests.ps1
- Tests\Unit\MSFT_SqlAlwaysOnService.Tests.ps1
- Tests\Unit\MSFT_SqlDatabase.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseDefaultLocation.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseOwner.Tests.ps1
- Tests\Unit\MSFT_SqlDatabasePermission.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseRecoveryModel.Tests.ps1
- Tests\Unit\MSFT_SqlDatabaseRole.Tests.ps1
- Tests\Unit\MSFT_SqlRS.Tests.ps1
- Tests\Unit\MSFT_SqlRSSetup.Tests.ps1
- Tests\Unit\MSFT_SqlScript.Tests.ps1
- Tests\Unit\MSFT_SqlScriptQuery.Tests.ps1
- Tests\Unit\MSFT_SqlServerConfiguration.Tests.ps1
- Tests\Unit\MSFT_SqlServerDatabaseMail.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpoint.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpointPermission.Tests.ps1
- Tests\Unit\MSFT_SqlServerEndpointState.Tests.ps1
- Tests\Unit\MSFT_SqlServerLogin.Tests.ps1
- Tests\Unit\MSFT_SqlServerMaxDop.Tests.ps1
- Tests\Unit\MSFT_SqlServerMemory.Tests.ps1
- Tests\Unit\MSFT_SqlServerNetwork.Tests.ps1
- Tests\Unit\MSFT_SqlServerPermission.Tests.ps1
- Tests\Unit\MSFT_SqlServerReplication.Tests.ps1
- Tests\Unit\MSFT_SqlServerRole.Tests.ps1
- Tests\Unit\MSFT_SqlServerSecureConnection.Tests.ps1
- Tests\Unit\MSFT_SqlServiceAccount.Tests.ps1
- Tests\Unit\MSFT_SqlSetup.Tests.ps1
- Tests\Unit\MSFT_SqlWaitForAG.Tests.ps1
- Tests\Unit\MSFT_SqlWindowsFirewall.Tests.ps1
- Tests\Unit\Stubs\SMO.cs
- Tests\Unit\Stubs\SqlPowerShellSqlExecutionException.cs
- Tests\Unit\Stubs\SQLPSStub.psm1
- Tests\Unit\Stubs\SQLServerStub.psm1
- Tests\Unit\Stubs\Write-ModuleStubFile.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
17.0.1-previ... | 20 | 10/29/2024 |
17.0.1-previ... | 6 | 10/26/2024 |
17.0.1-previ... | 14 | 10/7/2024 |
17.0.0 | 45,102 | 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,108 | 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,769 | 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,501 | 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,085 | 5/6/2023 |
16.3.1-previ... | 5 | 5/6/2023 |
16.3.1-previ... | 9 | 5/4/2023 |
16.3.0 | 42,253 | 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,154 | 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,571 | 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,607 | 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,639 | 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,393,062 | 2/12/2021 |
15.1.1-previ... | 18 | 2/12/2021 |
15.1.0 | 62,451 | 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,532 | 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,249 | 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,776 | 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 | 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,417 | 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,513 | 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,905 | 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 (current version) | 17,394 | 5/15/2019 |
12.4.0.0 | 21,747 | 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,233 | 5/2/2018 |
11.1.0.0 | 6,228 | 3/22/2018 |
11.0.0.0 | 13,502 | 2/8/2018 |
10.0.0.0 | 3,650 | 12/14/2017 |