Command Line

 View Only
Back to discussions
Expand all | Collapse all

pgp:open keyrings (1001:could not open keyrings, file not found)

  • 1.  pgp:open keyrings (1001:could not open keyrings, file not found)

    Posted Feb 04, 2020 11:00 AM

    Hi guys.. 

    I need to create an automated process for encrypting financial information. I extract this information from SQL SERVER 2014 and save it in a text file. When I run the PGP encryption command (in sql server)

    exec xp_cmdshell 'pgp -e D: \ Proj_varios \ Outputs \ PagoBancolombia.txt -r user@bank.com.co'

    I get this error: pgp: open keyrings (1001: could not open keyrings, file not found)

    Now, if I build a .bat file with the same instruction, ¡it works!

    What am I doing wrong? Why on one side does it work and on the other does not? :(

    SO: Windows Server 2008R2