Does SQL Server2005 play well with PGP and GPG

Last Post 29 Mar 2007 07:35 AM by dubtime. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dubtime
New Member
New Member

--
29 Mar 2007 07:35 AM
Hi all:
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';
GO

...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.


Acceptable Use Policy
---