SQL Server 2008 ??? FIPS 140-2-?????? ??? ??? ????? ???? ?? ??? ???????

???? ?????? ???? ??????
???? ID: 955720 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???? Federal ??????? ??????? ???? (FIPS) 140 2 ????????? ?? FIPS 140-2-?????? ??? ??? Microsoft SQL Server 2008 ?? ????? ???? ?? ??? ???? ?? ????? ???? ???

???:???? "FIPS 140-2?compliant," "FIPS 140 2 ???????" ?? "FIPS 140-2-?????? ???" ???????? ???? ????? ?? ???????? ?? ???? ?? ?????? ???? ?????? ??? ?? ?? ?????? ?????? ??? ???????? ??? ??????? ????? ?? ?????? ????? ?? ??? FIPS 140 2 ?????? ?? ??????? ??? ???????????????? ??????? ??????? ?? ?????? ??? ??? ????????? ?? conformant ????? ?? ???? ????? ???????? ?? ???? ??? ?? ????????? ? FIPS 140-2-??????,"? FIPS 140 2 ???????," ?? ? FIPS 140-2-?????? ??? ? ???? ?? ???? ?? ?? SQL Server 2008 ???? FIPS 140-2-????? ?????????? ?????????? ?? ????? ???? ?? ?? ?? ?????????? ?? hashed ???? ??? ??? ???????????? ??? ?????? hashing ?? ???? ?? ??????? SQL Server 2008 ???? ?? ???? ?? ??? ??, ?? ?????? ???? ?? SQL Server 2008 ????? ??????? ???????? ?? ??????????????? ??????? 140-2-????? ??? FIPS ?????? ?? ??? ??? ???? ???????? ???? ????? ??????? ????????? ????? ????? ?? ????? ?????? functionalities ????? ??? ?? ????? ????

???? ???????

???? FIPS ???

FIPS Federal ??????? ??????? ???? ?? ???? ??? FIPS ?? ?????? bodies ?????? ?????? ???? ?????? ?? ??? ???? ?? ????????? ?????? ?? ???? ?? ??????? ????? ??? ???????????? ??? ???? ????? ??????? Establishment ????? ??? ??? FIPS ??? ?? ?? ?? ???????? ?? ??? (??????? ????? ?? ??????) federal ?????? operated IT ?????? ??? ????? ?? ??? mandated ???? ???

???? FIPS 140 2 ???

FIPS 140 2 ?? ?? ??? ?? "??????? ?????????? ??????????????? ??????? ?? ???." ?? ????????? ???? ?? ?? ??????????? ?????????? ?? ???-?? ?????? ?????????? ????? ???? ?? ???? ?? ???? ??????????? ????? ????? ?? ???????? ???? ?? ??? ???? ??? ?????????, ??????????, ?? ??????????? FIPS 140-2 ?????? ??????? ?? ???????? ?????????? ??? ????? ?? ???? ??? ????? ?? ??? ?? ???? ??? ?? ?? ?????? FIPS 140-2-?????? ?? ??? ??? ?? ??? ??? ?? ?? ???? ??? ????????? ???

???? ??? ????????? ?? "FIPS 140-2-??????" ?? "FIPS 140-2-?????" ?? ?? ???? ????????? ??? ???? ???

?? SQL Server 2008 FIPS 140-2-?????? ????????? ?? ??? ??? ????? ?? ??? ???????? ?? ???? ???? ??? ???? ?? ???, ?? ?? ???? FIPS 140-2-????? ??????????????? ???? ??????? ?? ????? ???? ?? ?? ????? ???? ??? ?? ?? ??????????????? ??????? ?????? ????? ?? ?? ?? ???????? ?????? ?? SQL Server 2008 ??? ???? ?????? ???? ??????? ?? ??????? ?? ??? ???? ??????? ???? ??? ?????????? ?? ????? ???? ?? ???? ??? Realize ?? ?? FIPS 140 2 ??? ?? ???????? ??????? ?????????? ?? ????? ???? ?? ??? ????????? ??? ?????????? FIPS 140-2 ?? ????? ???? ??? ?? ?? ?????? ?? ????? ???? ?????? ?????????? ?????? ???? ?? ??????? ??? ????????? ?????? ???????? ?????????? ?????? ??? Windows Server 2008, Windows Server 2003, ?? Windows XP ???????? ??????????????? ??????? ??? ??, ?? ?????????? ?? ????????? ?????????? ?? ????, ??????? ?? ??????? ?????????? ?? ?????? ????? ??? ???

?? ??? ????????? FIPS 140-2-?????? ?? ???? ???

??? ????????? ?? hashing ?? ??????????? ???? ?? Microsoft Windows ??????????????? ???? ??????? ?? ???????? ??????? ?? ????? ???? ?? ???????? ?????????? ?? ???? ???????? ???????????? ?? ????? ???? ??? ?????? ?? ???? ??? ?? ?? ????????? ?????? ?? ???? ????? ????? ?? ????? ??????? ?? ?????????? ?? ??? Windows ????? ?????? ?? ????? ?? ?? ????? ????? ?? ????????? ??? ????? ??????? ?? ?????????? ?? ?????? ?? ??????? ??? ??, ??? ?????? ???, noncompliant ?????????? ?? ??????????? ??? ?? ?????? ?? FIPS 140-2-?????? ?????????? ?????? ?? ???, ???, ?? ???????????? ??????? ???, ???? ??? ??? ?????????, ??????, ???? ?? ??????? ???? ?? ??? ???, ?? ??? ?? ???? ?? ?? ?????????? (wrapped) ?? FIPS-?????? ?????????? ?? ????? ?? ???? noncompliant ?????????? ?? ????? ?? ???? ?????????? ???? ?? ???? ???

?? ?? ?? ???? ?? SQL Server 2008 ?? ????? FIPS 140-2-???????

No. ???? ???? ?? ?? SQL Server 2008 FIPS 140-2-?????? ??? ??? ????? ?? ??? ???????? ???? ?? ?????

???? ?? ???? ??? SQL Server 2008 ???????? ???? ?? FIPS 140-2-????? ??????????????? ??????? ?? ????? ???? ?? ????

???????? ?????? ??????????

?? ?? Windows Server 2008-?????? ????????, Windows Vista-?????? ????????, Windows Server 2003-?????? ???????? ?? Windows XP-?????? ???????? ?? SQL Server 2008 ??????? ???? ?????? ???

Windows ?????? ?????????? ??????????

SQL Server 2008 ?? ??????? ???? ?? ???? ???? FIPS ??? ?? ????? ???? ?????? ??? ?? ??????? SQL Server 2008 ??? ????????? ?? FIPS ?????? ???? ??? FIPS ?? ????? ???? ?? ??? ????? ????? ?? ???? ?????

Windows Server 2008 ?? Windows Vista ?? ???
  1. ???????? ?? ??? ?? ???? ?? ??? ???????????? ????????????? ?? ????? ?????
  2. ??? ?? Windows Server 2008 ?? ????? ?? ??? ???, ????? ???????????????? ????,???????????:gpedit. msc???? ????, ?? ???? ??? ENTER ?????.. ??????? ???? ???? ?????? ????? ??? ??? ?? Windows Vista-?????? ???????? ?? ????? ?? ??? ???, ????? ?????????????????:gpedit. msc???????? ??????? ????????? ???, ?? ???? ??? ???? ?????..
  3. ??????? ???? ???? ?????? ???, ???-????? ????Windows ???????? ??????????????? ??????????????, ?? ?? ???-????? ??????????? ????????.
  4. ?? ?????????????? ???????????, ???-????? ??????????? ?????? ????-????? ????, ?? ???? ?????????? ??????.
  5. ????? ??? ??? ??? ????? ?????????? ??????????????: ???????????, hashing, ?? ????????? ???? ?? ??? ????? FIPS-?????? ??????????.
  6. ??????????? ??????????????: ???????????, hashing, ?? ????????? ???? ?? ??? ????? FIPS-?????? ??????????????? ????? ???, ????? ????????? ???? ????? ????-????? ????, ?? ???? ???OK????? ????? ??? ?????
  7. ??????? ???? ???? ?????? ??? ?????
Windows Server 2003 ?? Windows XP ?? ???
  1. ???????? ?? ??? ?? ???? ?? ??? ???????????? ????????????? ?? ????? ?????
  2. ????? ????,???????????? ????,???????????:gpedit. msc???? ????, ?? ???? ??? ENTER ?????..
  3. ???? ???? ????? ??? ??? ????? ????Windows ???????? ??????????????? ??????????????, ?? ?? ???-????? ??????????? ????????.
  4. ?? ?????????????? ???????????, ???-????? ??????????? ?????? ????-????? ????, ?? ???? ?????????? ??????.
  5. ????? ??? ??? ??? ????? ?????????? ??????????????: ???????????, hashing, ?? ????????? ???? ?? ??? ????? FIPS-?????? ??????????.
  6. ??????????? ??????????????: ???????????, hashing, ?? ????????? ???? ?? ??? ????? FIPS-?????? ??????????????? ????? ???, ????? ????????? ???? ????? ????-????? ????, ?? ???? ???OK????? ????? ??? ?????
  7. ???? ???? ????? ??? ?????

SQL Server 2008 ?????????? ???

  • SQL Server 2008 ???? ?? ??? ????? ?? ?? ????????? ?? ??? FIPS ??? ????? ??, ?? SQL Server 2008 SQL ????? ?????? ??? ??? ????? ????? ??? ?? ????:
    ???? Broker ??????????? FIPS ??????? ??? ??? ?? ??? ??
    ??? ??, ????????? ??? ??? ????? ????? ??? ?? ???? ???:
    ??????? Mirroring ??????????? FIPS ??????? ??? ??? ?? ??? ??
    ???????? ???? ?? ????? FIPS ??? ??? ?? ??? ??, ?? ????? ?? ?????? ??????
  • ?????? ?? ??? ????? ?? ??????? ?? ??????? ???? ?? ??? ??????????? ????????? ????? ????? FIPS ?????????? ??????? ?? ????? ??????????? ???? (AES) ??? FIPS ??? ????? ???? ??? ??? ??? FIPS ??? ????? ???? ??? ??, ??????????? ????????? RC4 ?? ????? ???? ???
  • ?? ?? FIPS ??? ??? ???? ???? Broker ????? ????? ????????? ????, ???? Broker ?? ??? ?? "AES" ????????? ???? ????? ????? ????? RC4 ???? ?? ??? ???????? ???? ??? ??, ??? SQL ????? ?????? ?? ????? ??? ?????, ??????? ???? ??????? ???? ?????

SQL Server 2008 FIPS 140-2-?????? ??? ??? ???? ????? ???? ???

  • ??? Windows ??? FIPS ??? ???? ?? ?? ??? ?????????? ?? ?????????? ???? ?? ??? ?? ???? ?? ??? ???? ?? ???? ??? ??? ??? ?????? ?? ???? ??? ??? ?????? ??, SQL Server 2008 operates FIPS 140-2-?????? ??? ??? ??? SQL Server 2008 CryptoAPI ?? ????? ?????, ?? ?????????? ?? ???? ???????? ???????????? ?? ????? ??????
  • If FIPS mode is turned on and if the user has a choice of whether to use encryption, SQL Server 2008 will either allow for only FIPS 140-2-compliant encryption or it will not allow for any encryption.
  • Important information for developers

    If you write your own code for encryption or hashing, you must use only the CryptoAPI. You must specify only the algorithms that are allowed by FIPS 140-2. Specifically, use only the Triple Data Encryption Standard (3DES) or AES for encryption and only SHA-1 for hashing. You can use the following keywords in SQL Server 2008 for the respective FIPS 140-2-validated algorithms:
    • DESX (Three-key triple DES)
    • Triple-DES (Two-key triple DES)
    • TRIPLE_DES_3KEY (Three-key triple DES)
    • TRIPLE_DES_2KEY (Two-key triple DES)
    ???:Selecting DESX does not provide a DESX algorithm in SQL Server 2005 or in SQL Server 2008. In both cases, selecting DESX provides a validated instance of Three-key triple DES.
  • Important information for developers

    SQL Server 2008 ?? ?? ??? ?????-???? ????????? ?????? ??????? (HSM) ?? ??????????????? ???????? ??????? ?? ????? ???? ?? ?? ???? ??????????? ????? ??????? (EKM) ?????? ?? ?????? ???? ??? FIPS 140-2-?????? ??? ??? ????? ?? ??? ?? EKM ?? ????? ???? ?? ???, ????? ?? ????????? ??? ?? ??? ?? ???? ???? ?????:
    • ????? ??????????????? ??????? FIPS 140-2 ????? ???? ?????? ???
    • ??? ??????????????? ??????? ?????? ????? ??? ???? ??? ?? ?????????? FIPS 140-2 ????? ???? ?????? ??? ?? FIPS 140-2-?????? ??????????? ?? ?????????? ???? ?? ??? ?? ?? ???? ?? ??? ?? SQL ????? ?? ???? ?? ??????? ???? ?? ??? ?????? ??, ?? ???? ?? ???????????? ?? ???????? ?????????? ?? ????? ?????
    ??? ??, ???? ?? ????? ?????????? ?? ????? ??????????????? ??????? ?????? ????????? ?????? ?? ???? ???????????? ??????? ??? FIPS 140-2-????? ??????? ?? ????? ???

???? FIPS 140-2-?????? ??? ??? SQL Server 2008 ??? ??? ?? ?????? ???

  • Stronger ??????????? ?? ????? ??? ???? ???? ?? ????? ??????????? ?????? ?? ????????? ?? ??? ??? FIPS 140-2-?????? ???????? ???? ?? ?? ?? ?? ??????????? ?? ??? ???????? ?? ?????? ??? ???? ???
  • ??? ?? ??? SSIS ??????????? (UseEncryption ??? =) ?? ?????? ??????????? FIPS ??????? ?? ??? ????? ?? ?? ?? ?????? ???? ?? ?? ?????? ????? ????? ?????? ????? ?????? ???, ????????? ????? ?? ??? ??????????? ???? ??? ???
  • ??????????? ?? ??? ?????? ???? ??????????????? ?????? (DTS) ?? ????? FIPS 140-2-?????? ???? ??? ??? ????, DTS ?? ??? Windows ??? FIPS ??? ?? ???? ??? ??? ?????? ????, ?? ??? ???? ???? ??????????? ?? ??? ???? ?????
  • ??????? SQL Server 2008 ??????????? ?? ??????????? ?? ???? ?? ?? hashing ?? FIPS 140-2-????? ??????????????? ??????? ?? ?????? ?????, ??? ?? ???? ????????? ??? ??? ????? FIPS 140-2-?????? FIPS ??? ???? ???? ?? Windows ???, ?? ??????? ????? ?? ????????? ?? ???????? ?? ?? ?? ?????

???? ??? ??? ???? FIPS 140 2 ?? ???? ??? ?????

FIPS ???? ?? ?? ??? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? NIST ??? ???? ?? ????:
HTTP://csrc.nist.gov/cryptval/140-2.htm
?????? ?????? ???? ??? ???? ?????? ???? ?? ??? Microsoft ???? ?????-???? ?????? ??????? ?????? ????? ??.. ?? ?????? ??????? ???? ???? ????? ????? ?? ??? ???? ??.. Microsoft ?? ?????-???? ?????? ??????? ?? ??? ???? ?? ??? ?????? ???? ????..

??????

FIPS 140-2-?????? ??? ??? SQL Server 2005 ?? ????? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
920995????????? ?? ????? ???? ?? ??? SQL Server 2005 ?????? ??? 1 ?? SQL ????? ?? ???? ??? ???? ??????? ??? FIPS 140 2 ?????? ???

???

???? ID: 955720 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
??????: 
sql2008relnoteconfiguration sql2008relnote kbhowto kbexpertiseadvanced kbinfo kbmt KB955720 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:955720

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com