I'm working with two external clients who need to send me encrypted flat files, which I will upload into SQL Server 2005. One client wants to use a PGP key pair, the other wants to use GPG. I've used the code from the online documentation to try and create a key on my end....
CREATE ASYMMETRIC KEY PacificSales19
FROM FILE = insert_path_here
ENCRYPTION BY PASSWORD = '35698ofg0sjlkfLKJ4548872$$$2';
...and supplied the path to the pgp key file as the FROM FILE argument.
The error I get is....
Msg 15208, Level 16, State 1, Line 1
The certificate, asymmetric key, or private key file does not exist or has invalid format.
What am I missing?
Thanks in advance.