Release v2.0.0 - PuppetForge

Version 2.0.0

• BREAKING CHANGE : Require puppetlabs/dsc compiled with SQLServerDSC >= 10.0.0.0
• BREAKING CHANGE : Changed $sqlservicecredential_username and $sqlagentservicecredential_username format. User accounts now required WITHOUT Netbios Domain Name prefix.
• BREAKING CHANGE : Removed $domainName class parameter. Used facts instead.
• BREAKING CHANGE : Removed $domainNetbiosName class parameter. Used custom fact instead.
• Changed database availability mode to SynchronousCommit

Puppet Forge link : https://forge.puppet.com/virtualdesktopdevops/sqlserveralwayson

Initial release

This modules install a fully working SQL Server AlwaysOn cluster. It has been designed to install both primary replica nodes with the following features:

• SPN creation on sql service account (service account not yet created by this module, schedulded in next release)
• SQL server installation and initial configuration (MaxDop Firewall, Memory, Admin rights, ...)
• Failover cluster creation (primary node) or join (replica node) with File Share witness
• AlwaysOn configuration (availability group, server endpoints, availability group listener) on both primary and replica nodes.

Requires puppetlabs/dsc compiled wit the following DSC resources:

• xSQLServer v8.2.0.0
• xFailOverCluster v1.8.0.0
• xActiveDirectory with SPN support (https://github.com/claudiospizzi/xActiveDirectory/tree/xADServicePrincipalName)