The struggle with configuration data in DSC configurations – SQL Alias and reusability

Today I was very happy to find a neat solution to handle configuration data for a DSC configuration. I was facing the following challenge:

In a SharePoint DSC Configuration I want to reuse several SQL Aliases that are created during run time of the DSC configuration based on the configuration data.

In recent DSC setups my configuration did look like this:

	@{
	AllNodes = @(
	@{
	NodeName = "*"
	PSDscAllowPlainTextPassword = $true
	PSDscAllowDomainUser = $true
	ServerRole = "invalid"
	},
	@{
	NodeName = "SharePointServer"
	ServerRole = "SingleServerFarm"
	CentralAdmin = $true
	IsMasterNode = $true
	ServiceInstances = @(
	)
	}
	)
	NonNodeData = @{
	SqlServerAlias = @(
	@{
	ServerName = "SqlServer\Content"
	Name = "SharePoint-Content"
	Protocol = "TCP"
	UseDynamicTcpPort = $true
	TcpPort = $false
	},
	@{
	ServerName = "SqlServer1\Config"
	Name = "SharePoint-Config"
	Protocol = "TCP"
	UseDynamicTcpPort = $true
	TcpPort = $false
	}
	)
	}
	}

view raw ConfigurationData.Old.psd1 hosted with ❤ by GitHub

and I created the SQL Alias with the following lines of code:

	$ConfigurationData.NonNodeData.SqlServerAlias | ForEach-Object -Process {
	SqlAlias $_.Name
	{
	Name = $_.Name
	ServerName = $_.ServerName
	Protocol = $_.Protocol
	UseDynamicTcpPort = $_.UseDynamicTcpPort
	TcpPort = $_.TcpPort
	Ensure = 'Present'
	PsDscRunAsCredential = $SpSetupAccount
	}
	}

view raw SqlServerAlias.Old.ps1 hosted with ❤ by GitHub

This far there was no struggle at all. Creating a SQL Alias with DSC is very straight forward, even if there is the need to create more than one.

The struggle got real the moment I had to reuse the Alias Name in SharePoint. How do I properly access the Alias? Do I iterate over all aliases again and filter or do I hard code the alias name or…? None of the before felt right.

My solutions is pretty simple: Why not change the array to another hash table – A hash table allows to access the data more easily. 🙂

	@{
	AllNodes = @(
	@{
	NodeName = "*"
	PSDscAllowPlainTextPassword = $true
	PSDscAllowDomainUser = $true
	ServerRole = "invalid"
	},
	@{
	NodeName = "SharePointServer"
	ServerRole = "SingleServerFarm"
	CentralAdmin = $true
	IsMasterNode = $true
	ServiceInstances = @(
	)
	}
	)
	NonNodeData = @{
	SqlServerAlias = @{
	Content = @{
	ServerName = "SqlServer\Content"
	Name = "SharePoint-Content"
	Protocol = "TCP"
	UseDynamicTcpPort = $true
	TcpPort = $false
	}
	Config = @{
	ServerName = "SqlServer1\Config"
	Name = "SharePoint-Config"
	Protocol = "TCP"
	UseDynamicTcpPort = $true
	TcpPort = $false
	}
	}
	}
	}

view raw ConfigurationData.New.psd1 hosted with ❤ by GitHub

Final challenge: How can I iterate over a hash table? A hash table object has two properties: keys and values:

	$ConfigurationData.NonNodeData.SqlServerAlias.Keys | ForEach-Object -Process {
	SqlAlias $ConfigurationData.NonNodeData.SqlServerAlias[$_].Name
	{
	Name = $ConfigurationData.NonNodeData.SqlServerAlias[$_].Name
	ServerName = $ConfigurationData.NonNodeData.SqlServerAlias[$_].ServerName
	Protocol = $ConfigurationData.NonNodeData.SqlServerAlias[$_].Protocol
	UseDynamicTcpPort = $ConfigurationData.NonNodeData.SqlServerAlias[$_].UseDynamicTcpPort
	TcpPort = $ConfigurationData.NonNodeData.SqlServerAlias[$_].TcpPort
	Ensure = 'Present'
	PsDscRunAsCredential = $SpSetupAccount
	}
	}

view raw SqlServerAlias.New.ps1 hosted with ❤ by GitHub

So what changed in my SharePointDsc configuration part? Now I can address my SQL Alias properly without having any troubles:

	Previously:
	SPFarm SharePointFarm
	{
	DatabaseServer = ¯\_(ツ)_/¯
	IsSingleInstance = "Yes"
	FarmConfigDatabaseName = "SP_Config"
	AdminContentDatabaseName = "SP_AdminContent"
	Passphrase = $Passphrase
	FarmAccount = $FarmAccount
	RunCentralAdmin = $true
	PsDscRunAsCredential = $SpSetupAccount
	}
	Now:
	SPFarm SharePointFarm
	{
	DatabaseServer = $ConfigurationData.NonNodeData.SqlServerAlias.Config.Name
	IsSingleInstance = "Yes"
	FarmConfigDatabaseName = "SP_Config"
	AdminContentDatabaseName = "SP_AdminContent"
	Passphrase = $Passphrase
	FarmAccount = $FarmAccount
	RunCentralAdmin = $true
	PsDscRunAsCredential = $SpSetupAccount
	}

view raw SharePoint.ps1 hosted with ❤ by GitHub

Advertisement

AutoSpInstaller XML to SharePointDsc Converter – Preview – Update 2018/04/19

Today the first preview of a web based AutoSpInstaller to SharePoint DSC converter got released.

There are still some limitations, as the mapping of the xml file to SharePointDsc is not complete jet. This is a preview to demonstrate the capabilities.

The converter targets the following use case:

As a user with an AutoSpInstaller XML available I want want to switch to SharePointDsc.

Currently the converter is able to create a multi node SharePoint DSC configuration based on the input of the contents of the AutoSPInstaller XML file. The configuration will contain the following elements:

• one node block for each server name. If you are using localhost mixed with real server names, there will be an additional node for localhost.
  • On each node the following configuration is placed:
    • SQLAliases
    • SharePoint Prerequistes
    • SharePoint Binary Installation
    • Farm create or join
• The following components are currently extracted from the AutoSPInstaller xml file:
  • Basic Farm setup
  • Managed Accounts
  • Web Applications
  • Site Collections
  • Managed Paths
  • Diagnostics Logging Service
  • State Service Application
  • Sandboxed Code Service
  • Claims to Windows Token Service
  • Outgoing Mail
  • Distributed Cache
  • Workflow Timer Setting
• Update 2018/04/19 – There are the following additions:
  • Creation of Application Pools for Web Applications, Search, Serivces
  • User Profile Service Application
  • Search Service Application
  • Managed Metadata Service Application