DSCResources/Resources/SqlServer.SqlProtocol.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
# Copyright (c) Microsoft Corporation. All rights reserved. # Licensed under the MIT License. $Rules = $Stig.RuleList | Select-Rule -Type SqlProtocolRule # Sets variables for Default and Named Instances. foreach ($instance in $serverInstance) { if ($instance -notmatch '\\') { $instanceName = 'MSSQLSERVER' $serverName = $instance } else { $instanceName = $instance.Split('{\}')[1] $serverName = $instance.Split('{\}')[0] } foreach ($rule in $rules) { $ruleEnabled = $null [void][bool]::TryParse($rule.Enabled, [ref]$ruleEnabled) SqlProtocol (Get-ResourceTitle -Rule $rule) { InstanceName = $instanceName ServerName = $serverName ProtocolName = $rule.ProtocolName Enabled = $ruleEnabled } } } |