SQL Server 2008 Common Criteria Enabled

I need to turn on the SQL Server 2008 configuration, Common Criteria Compliance.  While I am able to turnon the setting, I am not able to find the script that finishes configuring SQL Server as a certified version.  In the MSDN library link  http://msdn.microsoft.com/en-us/library/bb153837.aspx it suggests that I can get this off of Microsofts SQL Server Common Criteria website but I am unable to locate it.  Can someone help find the sample compliance script that is supposedly on this website?  I would prefer a link to the source script if possible.  Thank you
tigermoonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ralmadaCommented:
The script just create a series of traces to log certain events. Indeed there used to be a script for SQL 2008 called SQL_Server2008_EAL1_trace.sql. But it seems that is no longer available for download.
There still exist a script for SQL 2005 SP1 which can be downloaded from:
 https://members.microsoft.com/sqlcommoncriteria/EAL1_trace.sql
So here are my suggestions:
1) You can try creating the traces manually from the script above. Pay particular attention to the commands like below:
exec sp_trace_setevent @TraceID, 14, 23, @on
And here is the details of what the 14, 23 etc means:
http://msdn.microsoft.com/en-us/library/ms186265.aspx 
2)  However, you need to keep in mind that in SQL 2008 there's a new AUDIT feature, which intends to replace the old traces (maybe that's why MS has removed the script from his site). So what I suggest is, based on the list of events being logged in the script above you need to do the same with the new Audit feature. More information about SQL 2008 auditing:
http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Audit-in-SQL-Server-2008.html?sfQueryTermInfo=1+2008+30+audit+sql 
http://msdn.microsoft.com/en-us/library/cc280386.aspx 

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tigermoonAuthor Commented:
Thank you, I will give this a try at work tomorrow...
tigermoonAuthor Commented:
Still don't understand the connection with common criteria compliance which should be different than C2 audit tracing which is deprecated from what I read.  This is a requirement for the job, but I will keep looking, thank you for your help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.