SQL 2014 STD/Windows 2008r2/FIPS 140-2?


  • Does SQL 2014 STD on Windows Server 2008r2 support FIPS 140-2? I know that I can enable FIPS 140-2 in a group policy at the OS level, but does SQL honor/use it? If I enable it, how can I test it to ensure that SQL is then compliant? I found this  in an MS support article which I wasn't able to include in this post:

    How can SQL Server 2014 be configured to be FIPS 140-2–compliant?

    Operating system requirement

    You must install SQL Server 2014 on a server that is based on one of the following operating systems:

    • Windows Server 2012
    • Windows Server 2012 R2
    • Windows 8
    • Windows 8.1
    Windows 10

    but it does not list Windows 2008 r2.


    Wednesday, March 15, 2017 7:42 PM

All replies