SQL 2005 Available Encrytion Algoriths by OS Version

From: John Alfaro (johna_at_merlinsolutions.com)
Date: 11/27/05

  • Next message: Uri Dimant: "Re: User can't access his own objects" 
    Date: Sat, 26 Nov 2005 22:21:58 -0500

    I get the following when trying to create a symetric key on sql 2005 dev on
    windows xp.
        Command:
    create symmetric key sk_accountnumber with algorithm = aes_256 encryption by
    certificate cert_sk_admin;
        Error:
    Either no algorithm has been specified or the bitlength and the algorithm
    specified for the key are not available in this installation of Windows.

    I found elsewhere that some OS's don't support all of the encryptions
    algorithms. I've been unable to locate whats available on what platforms.
    Does anyone have a reference?

    Thanks.

  • Next message: Uri Dimant: "Re: User can't access his own objects"

    Relevant Pages

    • Re: Assembly Language
      ... >> Randy Hyde ... > it is all a question of the right algorithm for the job, ... "response time" and "throughput" (I don't recall Randy ever referring ... an example, a batch file is "throughput" friendly, while a Windows GUI ...
      (alt.lang.asm)
    • Re: CREATE SYMMETRIC KEY
      ... To test it out using encryption, I created a database, TestEncrypt, using ... CREATE SYMMETRIC KEY SSN_Key_01 ... Either no algorithm has been specified or the bitlength and the algorithm ... DECRYPTION BY CERTIFICATE HumanResources037; ...
      (microsoft.public.sqlserver.security)
    • Re: Crypto Question
      ... (Password Based Encryption) ... parameter for generating a random symmetric key. ... When choosing the algorithm to use you can also choose the length of the ... PGP / XML GATEWAY APPLIANCE ...
      (Security-Basics)
    • Re: Crypto Question
      ... (Password Based Encryption) ... parameter for generating a random symmetric key. ... When choosing the algorithm to use you can also choose the length of the ... PGP / XML GATEWAY APPLIANCE ...
      (Security-Basics)
    • Re: how these 2 functions may differ?
      ... I was thinking of turning the windows forms app I used as a test harness into a little general purpose encryption/decryption utility for the supported .net algorithms... ... you not using the encryption functions built in to Windows? ... This algorithm is supported by the Microsoft Base Cryptographic Provider. ... it should have been as simple as calling new CryptoAPITransform and passing the right algid. ...
      (microsoft.public.dotnet.languages.csharp)