Posted on 2014-12-18
Medium Priority
Last Modified: 2015-12-30
I wanted to know if anyone has existing scripts that lockdown a 2012 SQL server with 2012 STIGS?
Question by:sarafara1
1 Comment
LVL 66

Accepted Solution

btan earned 2000 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.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article investigates the question of whether a computer can really be cleaned once it has been infected, and what the best ways of cleaning a computer might be (in this author's opinion).
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

607 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