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
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
No comments:
Post a Comment