578

Downloads

344

Downloads of 0.1.0.2

2017-03-04

Last published

SQL STIG 2014/2016

0.1.0.2

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.

Inspect

PS> Save-Module -Name SqlStig -Path <path>

Install

PS> Install-Module -Name SqlStig

Deploy

See Documentation for more details.

Release Notes

0.1.0.2*
Modified the query to find the SQL agent account.

0.1.0.1*
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.

Owners

Authors

Michael Haken

Copyright

(c) 2016 . All rights reserved.

FileList

Show
  • SqlStig.nuspec
  • SqlStig.psd1
  • SqlStig.psm1
  • Tags

    Functions

    Dependencies

    Version History

    Version Downloads Last updated
    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