none
Problem in creating Asymmetric keys RRS feed

  • Question

  • I am a novice to the SQL server. I am trying to create Asymmetric key using the query

    CREATE ASYMMETRIC KEY PacificSales19 AUTHORIZATION dbo

    FROM FILE = ' C:\temp\temp1.snk'

    ENCRYPTION BY PASSWORD = 'ABC123!@#$';

    GO

    But I alwys get the follwing error

    The certificate, asymmetric key, or private key file does not exist or has invalid format.

    Can anyone please guide me as to how to go ablout creating the ASYMMETRIC KEY FROM FILE.

    Thanks and regards

     

     

     

    Monday, August 7, 2006 2:10 PM

Answers

  • The statement you are trying is correct - this is how you can create an asymmetric key from a file.

    You should check that the specified path is correct and that the file is not corrupted. How did you generate that file?

    Thanks
    Laurentiu

    Monday, August 7, 2006 7:42 PM
    Moderator

All replies

  • The statement you are trying is correct - this is how you can create an asymmetric key from a file.

    You should check that the specified path is correct and that the file is not corrupted. How did you generate that file?

    Thanks
    Laurentiu

    Monday, August 7, 2006 7:42 PM
    Moderator
  • How to generate the keypair file that can be imported into sql server? What is the valid format for it?

    Thursday, July 9, 2009 8:09 PM
  • See http://blogs.msdn.com/lcris/archive/2006/03/13/550904.aspx. You can use the strong name tool to generate strong name files. But if you don't already have a file, you should probably use certificates instead.
    This post is provided "AS IS" with no warranties, and confers no rights.
    Thursday, July 9, 2009 11:13 PM