SqlStig
0.0.0.3
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 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 Set-SQLInstanceDefaultTrace Add-SQLInstanceLogin Add-SQLInstanceServerRole New-SQLInstanceJobCategory New-SQLAgentJob New-SQLAgentJobStep New-SQLAgentJobSchedule Set-SQLDatabaseTrustworthy Get-SQLInstanceServerRoleMembership New-SQLDatabaseDDLTrigger Get-SQLInstanceErrorLogPath Get-SQLServer Get-SQLInstanceVersion Get-SQLInstanceDetails Get-SQLInstanceDataDirectories 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
Added functionality to use sql credentials to run the Set-SQLInstanceStigItems and Set-SQLDatabaseStigItems. Fixed setting the force encryption option remotely.
FileList
- SqlStig.nuspec
- SqlStig.psd1
- SqlStig.psm1
Version History
Version | Downloads | Last updated |
---|---|---|
0.1.0.2 | 1,193 | 3/4/2017 |
0.1.0.1 | 35 | 3/2/2017 |
0.0.0.3 (current version) | 221 | 5/13/2016 |
0.0.0.2 | 19 | 5/12/2016 |
0.0.0.1 | 21 | 5/11/2016 |