I am attempting to setup a custom SQL Server database with user import. When I call a stored procedure in the login script that has the SQL command, DECRYPTION BY CERTIFICATE, I get an error that states: “Cannot find the certificate ‘x’, because it does not exist or you do not have permission.”
The user is the same one that works when calling the stored procedure from within the network. Any idea of additional setup that’s needed to be able to use the SQL password certificate?