I have to build sql- server security architecture doc based on our existing PROD server, what all it takes to build a doc from scratch. Is there any good website for the template for the doc?
closed as not constructive by HopelessN00b, adaptr, Dave M, pauska, Chris S Jan 18 '13 at 16:42
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
locked by HopelessN00b Jan 22 '15 at 7:13
This question exists because it has historical significance, but it is not considered a good, on-topic question for this site so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. See the help center for guidance on writing a good question.
Read more about locked posts here.
I have to build sql- server security architecture doc based on our existing PROD server
Already you are Doing It Wrong -- define your security requirements, document an architecture that meets, them, then perform a gap analysis and show what must be done to make your production environment meet the security requirements.
Greg Askew already aimed you at some Microsoft documentation which will help.
I'm going to be brutally honest - If you need to come to Server Fault asking
what all it takes to build a doc from scratch (and you're not just asking about formatting) you are not qualified to take on this task. Security is something that takes experience, and you may want to consider getting a professional DBA with security experience to help you draft your security policy and ensure your system conforms to it.
SQL Server Security Best Practices - Operational and Administrative Tasks