xSQLServer
9.1.0.0
Module with DSC Resources for deployment and configuration of Microsoft SQL Server. This module has been renamed to SqlServerDsc. Development of these resources will continue under that module. This specific module (xSQLServer) is now deprecated and use of SqlServerDsc is recommended.
Minimum PowerShell version
5.0
Installation Options
Owners
Copyright
(c) 2018 Microsoft Corporation. All rights reserved.
Package Details
Author(s)
- Microsoft Corporation
Tags
DesiredStateConfiguration DSC DSCResourceKit DSCResource
DSCResources
xSQLServerAlias xSQLServerAlwaysOnAvailabilityGroup xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership xSQLServerAlwaysOnAvailabilityGroupReplica xSQLServerAlwaysOnService xSQLServerAvailabilityGroupListener xSQLServerConfiguration xSQLServerDatabase xSQLServerDatabaseDefaultLocation xSQLServerDatabaseOwner xSQLServerDatabasePermission xSQLServerDatabaseRecoveryModel xSQLServerDatabaseRole xSQLServerEndpoint xSQLServerEndpointPermission xSQLServerEndpointState xSQLServerFirewall xSQLServerLogin xSQLServerMaxDop xSQLServerMemory xSQLServerNetwork xSQLServerPermission xSQLServerReplication xSQLServerRole xSQLServerRSConfig xSQLServerRSSecureConnectionLevel xSQLServerScript xSQLServerServiceAccount xSQLServerSetup xWaitForAvailabilityGroup
Dependencies
This module has no dependencies.
Release Notes
This module has been renamed to SqlServerDsc. Development of these resources will continue under that module. This specific module (xSQLServer) is now deprecated and use of SqlServerDsc is recommended. The only change between version 9.0.0.0 and 9.1.0.0 is the addition of this note to the description of the module. There are no other changes.
FileList
- xSQLServer.nuspec
- CHANGELOG.md
- CONTRIBUTING.md
- LICENSE
- PSGetModuleInfo.xml
- README.md
- xSQLServer.psd1
- xSQLServerHelper.psm1
- DSCResources\CommonResourceHelper.psm1
- DSCResources\MSFT_xSQLServerAlias\MSFT_xSQLServerAlias.psm1
- DSCResources\MSFT_xSQLServerAlias\MSFT_xSQLServerAlias.schema.mof
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroup\MSFT_xSQLServerAlwaysOnAvailabilityGroup.psm1
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroup\MSFT_xSQLServerAlwaysOnAvailabilityGroup.schema.mof
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.psm1
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.schema.mof
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\en-US\about_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.help.txt
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\en-US\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.strings.psd1
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.psm1
- DSCResources\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.schema.mof
- DSCResources\MSFT_xSQLServerAlwaysOnService\MSFT_xSQLServerAlwaysOnService.psm1
- DSCResources\MSFT_xSQLServerAlwaysOnService\MSFT_xSQLServerAlwaysOnService.schema.mof
- DSCResources\MSFT_xSQLServerAvailabilityGroupListener\MSFT_xSQLServerAvailabilityGroupListener.psm1
- DSCResources\MSFT_xSQLServerAvailabilityGroupListener\MSFT_xSQLServerAvailabilityGroupListener.schema.mof
- DSCResources\MSFT_xSQLServerConfiguration\MSFT_xSQLServerConfiguration.psm1
- DSCResources\MSFT_xSQLServerConfiguration\MSFT_xSQLServerConfiguration.schema.mof
- DSCResources\MSFT_xSQLServerDatabase\MSFT_xSQLServerDatabase.psm1
- DSCResources\MSFT_xSQLServerDatabase\MSFT_xSQLServerDatabase.schema.mof
- DSCResources\MSFT_xSQLServerDatabaseDefaultLocation\MSFT_xSQLServerDatabaseDefaultLocation.psm1
- DSCResources\MSFT_xSQLServerDatabaseDefaultLocation\MSFT_xSQLServerDatabaseDefaultLocation.schema.mof
- DSCResources\MSFT_xSQLServerDatabaseDefaultLocation\en-US\MSFT_xSQLServerDatabaseDefaultLocation.strings.psd1
- DSCResources\MSFT_xSQLServerDatabaseOwner\MSFT_xSQLServerDatabaseOwner.psm1
- DSCResources\MSFT_xSQLServerDatabaseOwner\MSFT_xSQLServerDatabaseOwner.schema.mof
- DSCResources\MSFT_xSQLServerDatabasePermission\MSFT_xSQLServerDatabasePermission.psm1
- DSCResources\MSFT_xSQLServerDatabasePermission\MSFT_xSQLServerDatabasePermission.schema.mof
- DSCResources\MSFT_xSQLServerDatabaseRecoveryModel\MSFT_xSQLServerDatabaseRecoveryModel.psm1
- DSCResources\MSFT_xSQLServerDatabaseRecoveryModel\MSFT_xSQLServerDatabaseRecoveryModel.schema.mof
- DSCResources\MSFT_xSQLServerDatabaseRole\MSFT_xSQLServerDatabaseRole.psm1
- DSCResources\MSFT_xSQLServerDatabaseRole\MSFT_xSQLServerDatabaseRole.schema.mof
- DSCResources\MSFT_xSQLServerEndpoint\MSFT_xSQLServerEndpoint.psm1
- DSCResources\MSFT_xSQLServerEndpoint\MSFT_xSQLServerEndpoint.schema.mof
- DSCResources\MSFT_xSQLServerEndpointPermission\MSFT_xSQLServerEndpointPermission.psm1
- DSCResources\MSFT_xSQLServerEndpointPermission\MSFT_xSQLServerEndpointPermission.schema.mof
- DSCResources\MSFT_xSQLServerEndpointState\MSFT_xSQLServerEndpointState.psm1
- DSCResources\MSFT_xSQLServerEndpointState\MSFT_xSQLServerEndpointState.schema.mof
- DSCResources\MSFT_xSQLServerFirewall\MSFT_xSQLServerFirewall.psm1
- DSCResources\MSFT_xSQLServerFirewall\MSFT_xSQLServerFirewall.schema.mof
- DSCResources\MSFT_xSQLServerLogin\MSFT_xSQLServerLogin.psm1
- DSCResources\MSFT_xSQLServerLogin\MSFT_xSQLServerLogin.schema.mof
- DSCResources\MSFT_xSQLServerMaxDop\MSFT_xSQLServerMaxDop.psm1
- DSCResources\MSFT_xSQLServerMaxDop\MSFT_xSQLServerMaxDop.schema.mof
- DSCResources\MSFT_xSQLServerMemory\MSFT_xSQLServerMemory.psm1
- DSCResources\MSFT_xSQLServerMemory\MSFT_xSQLServerMemory.schema.mof
- DSCResources\MSFT_xSQLServerNetwork\MSFT_xSQLServerNetwork.psm1
- DSCResources\MSFT_xSQLServerNetwork\MSFT_xSQLServerNetwork.schema.mof
- DSCResources\MSFT_xSQLServerNetwork\en-US\MSFT_xSQLServerNetwork.strings.psd1
- DSCResources\MSFT_xSQLServerPermission\MSFT_xSQLServerPermission.psm1
- DSCResources\MSFT_xSQLServerPermission\MSFT_xSQLServerPermission.schema.mof
- DSCResources\MSFT_xSQLServerReplication\MSFT_xSQLServerReplication.psm1
- DSCResources\MSFT_xSQLServerReplication\MSFT_xSQLServerReplication.schema.mof
- DSCResources\MSFT_xSQLServerRole\MSFT_xSQLServerRole.psm1
- DSCResources\MSFT_xSQLServerRole\MSFT_xSQLServerRole.schema.mof
- DSCResources\MSFT_xSQLServerRSConfig\MSFT_xSQLServerRSConfig.psm1
- DSCResources\MSFT_xSQLServerRSConfig\MSFT_xSQLServerRSConfig.schema.mof
- DSCResources\MSFT_xSQLServerRSSecureConnectionLevel\MSFT_xSQLServerRSSecureConnectionLevel.psm1
- DSCResources\MSFT_xSQLServerRSSecureConnectionLevel\MSFT_xSQLServerRSSecureConnectionLevel.schema.mof
- DSCResources\MSFT_xSQLServerScript\MSFT_xSQLServerScript.psm1
- DSCResources\MSFT_xSQLServerScript\MSFT_xSQLServerScript.schema.mof
- DSCResources\MSFT_xSQLServerServiceAccount\MSFT_xSQLServerServiceAccount.psm1
- DSCResources\MSFT_xSQLServerServiceAccount\MSFT_xSQLServerServiceAccount.schema.mof
- DSCResources\MSFT_xSQLServerServiceAccount\en-US\MSFT_xSQLServerServiceAccount.strings.psd1
- DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.psm1
- DSCResources\MSFT_xSQLServerSetup\MSFT_xSQLServerSetup.schema.mof
- DSCResources\MSFT_xSQLServerSetup\en-US\MSFT_xSQLServerSetup.strings.psd1
- DSCResources\MSFT_xSQLServerSetup\sv-SE\MSFT_xSQLServerSetup.strings.psd1
- DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.psm1
- DSCResources\MSFT_xWaitForAvailabilityGroup\MSFT_xWaitForAvailabilityGroup.schema.mof
- en-US\xSQLServerHelper.strings.psd1
- Examples\DSCClusterSqlBuild.ps1
- Examples\DSCFCISqlBuild.ps1
- Examples\DSCSqlBuild.ps1
- Examples\DSCSQLBuildEncrypted.ps1
- Examples\SQL-ClusterDB.ps1
- Examples\SQL-Standalone.ps1
- Examples\SQLPush_SingleServer.ps1
- Examples\Resources\xSQLServerAlias\1-AddSQLServerAlias.ps1
- Examples\Resources\xSQLServerAlias\2-RemoveSQLServerAlias.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroup\1-CreateAvailabilityGroup.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroup\2-RemoveAvailabilityGroup.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroup\3-CreateAvailabilityGroupDetailed.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\1-AddDatabasesToAvailabilityGroup.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\2-RemoveDatabasesFromAvailabilityGroup.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership\3-MatchDefinedDatabasesInAvailabilityGroup.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\1-CreateAvailabilityGroupReplica.ps1
- Examples\Resources\xSQLServerAlwaysOnAvailabilityGroupReplica\2-RemoveAvailabilityGroupReplica.ps1
- Examples\Resources\xSQLServerAlwaysOnService\1-EnableAlwaysOn.ps1
- Examples\Resources\xSQLServerAlwaysOnService\2-DisableAlwaysOn.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\1-AddAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\2-AddAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\3-RemoveAvailabilityGroupListenerWithSameNameAsVCO.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\4-RemoveAvailabilityGroupListenerWithDifferentNameAsVCO.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\5-AddAvailabilityGroupListenerUsingDHCPWithDefaultServerSubnet.ps1
- Examples\Resources\xSQLServerAvailabilityGroupListener\6-AddAvailabilityGroupListenerUsingDHCPWithSpecificSubnet.ps1
- Examples\Resources\xSQLServerConfiguration\1-ConfigureTwoInstancesOnTheSameServerToEnableClr.ps1
- Examples\Resources\xSQLServerConfiguration\2-ConfigureInstanceToEnablePriorityBoost.ps1
- Examples\Resources\xSQLServerDatabase\1-CreateDatabase.ps1
- Examples\Resources\xSQLServerDatabase\2-DeleteDatabase.ps1
- Examples\Resources\xSQLServerDatabaseDefaultLocation\1-SetDatabaseDefaultLocation.ps1
- Examples\Resources\xSQLServerDatabaseOwner\1-SetDatabaseOwner.ps1
- Examples\Resources\xSQLServerDatabasePermission\1-GrantDatabasePermissions.ps1
- Examples\Resources\xSQLServerDatabasePermission\2-RevokeDatabasePermissions.ps1
- Examples\Resources\xSQLServerDatabasePermission\3-DenyDatabasePermissions.ps1
- Examples\Resources\xSQLServerDatabaseRecoveryModel\1-SetDatabaseRecoveryModel.ps1
- Examples\Resources\xSQLServerDatabaseRole\1-AddDatabaseRole.ps1
- Examples\Resources\xSQLServerDatabaseRole\2-RemoveDatabaseRole.ps1
- Examples\Resources\xSQLServerEndpoint\1-CreateEndpointWithDefaultValues.ps1
- Examples\Resources\xSQLServerEndpoint\2-CreateEndpointWithSpecificPortAndIPAddress.ps1
- Examples\Resources\xSQLServerEndpoint\3-RemoveEndpoint.ps1
- Examples\Resources\xSQLServerEndpointPermission\1-AddConnectPermission.ps1
- Examples\Resources\xSQLServerEndpointPermission\2-RemoveConnectPermission.ps1
- Examples\Resources\xSQLServerEndpointPermission\3-AddConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
- Examples\Resources\xSQLServerEndpointPermission\4-RemoveConnectPermissionToAlwaysOnPrimaryAndSecondaryReplicaEachWithDifferentSqlServiceAccounts.ps1
- Examples\Resources\xSQLServerEndpointState\1-MakeSureEndpointIsStarted.ps1
- Examples\Resources\xSQLServerEndpointState\2-MakeSureEndpointIsStopped.ps1
- Examples\Resources\xSQLServerFirewall\1-CreateInboundFirewallRules.ps1
- Examples\Resources\xSQLServerFirewall\2-RemoveInboundFirewallRules.ps1
- Examples\Resources\xSQLServerLogin\1-AddLogin.ps1
- Examples\Resources\xSQLServerLogin\2-RemoveLogin.ps1
- Examples\Resources\xSQLServerMaxDop\1-SetMaxDopToOne.ps1
- Examples\Resources\xSQLServerMaxDop\2-SetMaxDopToAuto.ps1
- Examples\Resources\xSQLServerMaxDop\3-SetMaxDopToDefault.ps1
- Examples\Resources\xSQLServerMemory\1-SetMaxMemoryTo12GB.ps1
- Examples\Resources\xSQLServerMemory\2-SetMaxMemoryToAuto.ps1
- Examples\Resources\xSQLServerMemory\3-SetMinMemoryToFixedValueAndMaxMemoryToAuto.ps1
- Examples\Resources\xSQLServerMemory\4-SetMaxMemoryToDefault.ps1
- Examples\Resources\xSQLServerNetwork\1-EnableTcpIpWithStaticPort.ps1
- Examples\Resources\xSQLServerNetwork\2-EnableTcpIpWithDynamicPort.ps1
- Examples\Resources\xSQLServerPermission\1-AddServerPermissionForLogin.ps1
- Examples\Resources\xSQLServerPermission\2-RemoveServerPermissionForLogin.ps1
- Examples\Resources\xSQLServerReplication\1-ConfigureInstanceAsDistributor.ps1
- Examples\Resources\xSQLServerReplication\2-ConfigureInstanceAsPublisher.ps1
- Examples\Resources\xSQLServerRole\1-AddServerRole.ps1
- Examples\Resources\xSQLServerRole\2-RemoveServerRole.ps1
- Examples\Resources\xSQLServerRole\3-AddMembersToServerRole.ps1
- Examples\Resources\xSQLServerRole\4-MembersToIncludeInServerRole.ps1
- Examples\Resources\xSQLServerRole\5-MembersToExcludeInServerRole.ps1
- Examples\Resources\xSQLServerRSConfig\1-DefaultConfiguration.ps1
- Examples\Resources\xSQLServerRSConfig\2-CustomConfiguration.ps1
- Examples\Resources\xSQLServerScript\1-RunScriptUsingSQLAuthentication.ps1
- Examples\Resources\xSQLServerScript\2-RunScriptUsingWindowsAuthentication.ps1
- Examples\Resources\xSQLServerServiceAccount\1-ConfigureServiceAccount-UserAccount.ps1
- Examples\Resources\xSQLServerServiceAccount\2-ConfigureServiceAccount-VirtualAccount.ps1
- Examples\Resources\xSQLServerSetup\1-InstallDefaultInstanceSingleServer.ps1
- Examples\Resources\xSQLServerSetup\2-InstallNamedInstanceSingleServer.ps1
- Examples\Resources\xSQLServerSetup\3-InstallNamedInstanceSingleServerFromUncPathUsingSourceCredential.ps1
- Examples\Resources\xSQLServerSetup\4-InstallNamedInstanceInFailoverClusterFirstNode.ps1
- Examples\Resources\xSQLServerSetup\5-InstallNamedInstanceInFailoverClusterSecondNode.ps1
- Examples\Resources\xWaitForAvailabilityGroup\1-WaitForASingleClusterGroup.ps1
- Examples\Resources\xWaitForAvailabilityGroup\2-WaitForMultipleClusterGroups.ps1
- sv-SE\xSQLServerHelper.strings.psd1
- Tests\xSQLServerCommon.Tests.ps1
- Tests\Integration\MSFT_xSQLServerAlwaysOnService.config.ps1
- Tests\Integration\MSFT_xSQLServerAlwaysOnService.Integration.Tests.ps1
- Tests\Integration\MSFT_xSQLServerDatabaseDefaultLocation.config.ps1
- Tests\Integration\MSFT_xSQLServerDatabaseDefaultLocation.Integration.Tests.ps1
- Tests\Integration\MSFT_xSQLServerRSConfig.config.ps1
- Tests\Integration\MSFT_xSQLServerRSConfig.Integration.Tests.ps1
- Tests\Integration\MSFT_xSQLServerSetup.config.ps1
- Tests\Integration\MSFT_xSQLServerSetup.Integration.Tests.ps1
- Tests\TestHelpers\CommonTestHelper.psm1
- Tests\Unit\CommonResourceHelper.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAlias.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroup.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroupDatabaseMembership.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAlwaysOnAvailabilityGroupReplica.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAlwaysOnService.Tests.ps1
- Tests\Unit\MSFT_xSQLServerAvailabilityGroupListener.Tests.ps1
- Tests\Unit\MSFT_xSQLServerConfiguration.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabase.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabaseDefaultLocation.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabaseOwner.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabasePermission.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabaseRecoveryModel.Tests.ps1
- Tests\Unit\MSFT_xSQLServerDatabaseRole.Tests.ps1
- Tests\Unit\MSFT_xSQLServerEndpoint.Tests.ps1
- Tests\Unit\MSFT_xSQLServerEndpointPermission.Tests.ps1
- Tests\Unit\MSFT_xSQLServerEndpointState.Tests.ps1
- Tests\Unit\MSFT_xSQLServerFirewall.Tests.ps1
- Tests\Unit\MSFT_xSQLServerLogin.Tests.ps1
- Tests\Unit\MSFT_xSQLServerMaxDop.Tests.ps1
- Tests\Unit\MSFT_xSQLServerMemory.Tests.ps1
- Tests\Unit\MSFT_xSQLServerNetwork.Tests.ps1
- Tests\Unit\MSFT_xSQLServerPermission.Tests.ps1
- Tests\Unit\MSFT_xSQLServerReplication.Tests.ps1
- Tests\Unit\MSFT_xSQLServerRole.Tests.ps1
- Tests\Unit\MSFT_xSQLServerRSConfig.Tests.ps1
- Tests\Unit\MSFT_xSQLServerScript.Tests.ps1
- Tests\Unit\MSFT_xSQLServerServiceAccount.Tests.ps1
- Tests\Unit\MSFT_xSQLServerSetup.Tests.ps1
- Tests\Unit\MSFT_xWaitForAvailabilityGroup.Tests.ps1
- Tests\Unit\xSQLServerHelper.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 |
---|---|---|
9.1.0.0 (current version) | 290,988 | 1/24/2018 |
9.0.0.0 | 7,302 | 11/15/2017 |
8.2.0.0 | 5,487 | 10/5/2017 |
8.1.0.0 | 5,962 | 8/23/2017 |
8.0.0.0 | 5,770 | 7/12/2017 |
7.1.0.0 | 6,874 | 5/31/2017 |
7.0.0.0 | 8,221 | 4/19/2017 |
6.0.0.0 | 10,772 | 3/8/2017 |
5.0.0.0 | 2,550 | 1/26/2017 |
4.0.0.0 | 2,354 | 12/14/2016 |
3.0.0.0 | 1,929 | 11/2/2016 |
2.0.0.0 | 7,390 | 9/21/2016 |
1.8.0.0 | 28,529 | 8/10/2016 |
1.7.0.0 | 2,193 | 6/29/2016 |
1.6.0.0 | 1,331 | 5/18/2016 |
1.5.0.0 | 1,008 | 3/31/2016 |
1.4.0.0 | 1,595 | 2/3/2016 |
1.3.0.0 | 2,169 | 5/2/2015 |
1.2.1.0 | 503 | 2/19/2015 |
1.2.0.0 | 77 | 12/18/2014 |
1.1.0.0 | 87 | 10/24/2014 |