Solved

SQL 2012 STIGS

Posted on 2014-12-18
3
71 Views
Last Modified: 2015-12-30
I wanted to know if anyone has existing scripts that lockdown a 2012 SQL server with 2012 STIGS?
0
Comment
Question by:sarafara1
3 Comments
 
LVL 63

Accepted Solution

by:
btan earned 500 total points
ID: 40508623
The more  easier approach is using various means of script since various SQL components are involved and manual verification rather than one script as to lockdown specific to the STIG or any other benchmark. It is not straightforward, to align just to a standard and required some manual mapping on script lockdown and field of interest to STIG. Here is one good reference covering various component which I believe can be fulfiling the lockdown though not necessarily all STIG req. e.g. http://www.derekseaman.com/2010/07/automate-and-secure-your-sql-2008-r2.html

Consider using MS SQL has  best practice analyser https://labs.portcullis.co.uk/blog/ms-sql-server-audit-introduction/ that listed various areas but most of the surfaced area may not necessary be script easily.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: btan
The intent is not to repeat what many has know about Ransomware but more to join its dots of what is it, who are the victims, why it exists, when and how we respond on infection. Lastly, sum up in a glance to share such information with more to help…
Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question