CODEWITHSUNDEEP
c#rsa.net-assemblyencryption-asymmetricsn
roopteja
roopteja

Reputation: 737

Create Asymmetric keys in sys.asymmetric_keys in SQL Server using existing private and public keys (.NET)

I have a scenario like this:

I have public and private keys in XML format:

Private Key

   <RSAKeyvalue>
      <Modulus>My privvate key </Modulus>
      <Exponent>AQAB</Exponent>
      <P>-----</P>
      <Q>-----</Q>
      <DP>----</DP>
      <DQ>----</DQ>
      <InverseQ>---</InverseQ>
      <D>-----</D>
   </RSAKeyvalue>

Public key

    <RSAKeyvalue>
        <Modulus>My public key </Modulus>
        <Exponent>AQAB</Exponent>
    </RSAKeyvalue>

Now I want to import these keys into sys.asymmetric_keys in SQL Server with CREATE ASYMMETRIC KEY command in T-SQL.

I already have some data encrypted with the XML keys, and after creating the key in asymmetric_keys, I want to decrypt the data.

Is there any way to achieve this ?

Thanks in advance

Upvotes: -3

Views: 43

Answers (0)

Related Questions