In this recipe, we are going to enable SQL Server's Common Criteria compliance feature.
These are the steps to enable Common Criteria compliance using PowerShell:
Open PowerShell ISE as an administrator.
Import the
SQLPS
module as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking
Add the following script and run:
#replace this with your instance name $instanceName = "localhost" $server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName $server.Configuration.CommonCriteriaComplianceEnabled.ConfigValue = $true $server.Configuration.Alter()
You can confirm this from SQL Server Management Studio. Right-click on your instance, click on Properties, and select the Security page from the Select a page pane. In the Options section at the bottom, you should see the Enable Common Criteria compliance checkbox checked.