SqlStig
0.0.0.1
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 Database Mail and Windows Groups.
Installation Options
Owners
Copyright
(c) 2016 . All rights reserved.
Package Details
Author(s)
- Michael Haken
Tags
Functions
Set-SQLInstanceStigItems Set-SQLDatabaseStigItems Get-SQLInstanceDetails Get-SQLInstanceDataDirectories Get-SQLInstanceVersion Set-SQLInstanceForceEncryption Set-SQLInstanceDatabaseFilePermissions Set-SQLInstanceInstallationFilesPermissionsAndAuditing Set-SQLInstanceAuditFilePermissions Set-SQLInstanceAuditors Set-SQLInstanceAuditing Set-SQLDatabaseAuditing Set-SQLInstanceManagementRoles Rename-SQLInstanceAccount Disable-SQLInstanceAccount Set-SQLInstanceXPCmdShell Set-SQLInstanceLoginPasswordPolicies Set-SQLInstanceProtocols Get-SQLServer Set-SQLInstanceDefaultTrace Add-SQLInstanceLogin Add-SQLInstanceServerRole New-SQLInstanceJobCategory New-SQLAgentJob New-SQLAgentJobStep New-SQLAgentJobSchedule Set-SQLDatabaseTrustworthy Get-SQLInstanceServerRoleMembership New-SQLDatabaseDDLTrigger Get-SQLInstanceErrorLogPath Get-SQLInstanceDefaultTraceFile Get-SQLInstanceAuditCommandText Get-SQLDatabaseDdlTriggerCommandText New-SQLInstanceDatabaseDirectoryAccessRuleSet New-SQLInstanceAuditLogAccessRuleSet New-SQLInstanceInstallationDirectoryAccessRuleSet New-SQLInstanceInstallationDirectoryAuditRuleSet Get-SQLAuditObjectTypes Import-SqlModule Get-AccountSid Set-FilePermissions Reset-InheritedPermissions Set-Auditing Where-NotMatchIn
Dependencies
This module has no dependencies.
Release Notes
Beta release for this module. If you run in to any problems with it or have any questions, feel free to ask.
FileList
- SqlStig.nuspec
- SqlStig.psd1
- SqlStig.psm1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 0.1.0.2 | 1,199 | 3/4/2017 |
| 0.1.0.1 | 35 | 3/2/2017 |
| 0.0.0.3 | 221 | 5/13/2016 |
| 0.0.0.2 | 19 | 5/12/2016 |
| 0.0.0.1 (current version) | 21 | 5/11/2016 |