February 26, 2015 at 9:30 am
I have the following STIG to mitigate and hoped for some help
SQL2-00-023000
SQL Server must support the requirement to activate an alarm and/or automatically shut down the information system if an application component failure is detected. This can include conducting a graceful application shutdown to avoid losing information.
Check Content:
Check SQL Server configuration to verify the system activates and alarms and/or triggers a system shutdown when an application component failure is detected.
If SQL Server does not take either or both actions, this is a finding.
Fix Text:
Configure SQL Server to activate an alarm and/or trigger a system shutdown when an application component failure is detected.
Please let me know if you have any ideas on what can be done here. I am not interested in shutting my server down, but a trigger/alarm (email alert) would be what I am considering.
Your help is appreciated.
Jeff
February 26, 2015 at 11:09 am
As long as you didn't require administrative rights, you could configure the service failure response to run an application, just as you could with any other service. A simple thing to do is have a PowerShell script executes which fires an email.
K. Brian Kelley
@kbriankelley
February 26, 2015 at 11:27 am
Thank you very much and I will implement this.
I have to create a program that will send us an email and that may prove to be difficult because we do not have an SMTP Server in our environment.
Your help is appreciated.
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply