We have SQL Server succesfully set up for FIPS Compliance, But require to setup the same Compliance for the Encryption of Data in Analysis services 2008 enterprise on the same Win 2008 server.
If we browse to the SAS Data Folder for our Project on the Fips Compliant Instance We can view the Data Files and the Data is Visible in Plain Text. Depite the security setting being set to DataProtectMode 1 (Encryption).
So my Questions:
1. Is Analysis Services 2008 enterprise Fips Compliant ?
2. if it is How do we set it up
3. how do we prove to security Auditors that it is Set up and Working in Compliant Mode.
We have done Exaustive Searches of msdn Google blogs, sql-cat etc and found no relevent articles to Answer these specific Questions and are reluctant to Go to Chargeable support until we have exausted other available avenues.
View Complete Post