Downloads of 0.1.0.2
SQL STIG 2014/2016
Configures all of the settings required by the SQL 2014 Draft STIG excluding the Logon Trigger requirement (I find this to essentially break everytime) and TDE.
Run both the Set-SQLInstanceStigItems and Set-SQLDatabaseStigItems to completely STIG the Instance. Requires some prior setup for SQL Agent Operators and Windows and/or Local Groups.
PS> Save-Module -Name SqlStig -Path <path>
PS> Install-Module -Name SqlStig
See Documentation for more details.
Modified the query to find the SQL agent account.
Removed a few functions that were not SQL specific to the HostUtilities module.
Did major code refactoring, but it does not impact the entry points to run the Instance STIG cmdlet and Database STIG cmdlet. The file permissions and auditing sections should produce much better results.
The Instance STIG cmdlet enables and sets up database mail. If an SMTP server is not provided, you'll need to update that afterwards. This just leaves creating Agent Operators before running the Datbase STIG cmdlet.
(c) 2016 . All rights reserved.
|SQL STIG 2014/2016 0.1.0.2 (this version)||344||Saturday, March 04 2017|
|SQL STIG 2014/2016 0.1.0.1||19||Thursday, March 02 2017|
|SQL 2014 STIG 0.0.0.3||204||Friday, May 13 2016|
|SQL 2014 STIG 0.0.0.2||4||Thursday, May 12 2016|
|SQL 2014 STIG 0.0.0.1||5||Wednesday, May 11 2016|