Permissions to execute stored procedure

[jeffprandall]

I am trying to executive a stored procedure which executes another stored procedure to decrypt some data.  I get the unecrypted data but all the encrpyted data is blank.  I have made sure both SP's have the Execute permission using the account used in the Gateway credentials along with the service account the gateway service is running.  And when the Scheduled Refresh happens there is no errors.

[v-henryk-mstf]

Hi @jeffprandall ,

You can refer to the related blogs and documents provided below, hoping to help you.

Always Encrypted - SQL Server | Microsoft Docs

Power BI and SQL Always Encrypted (linkedin.com)

If the problem is still not resolved, please provide detailed error information screenshoot and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jeffprandall]

The database itself is not encrypted just the data in the column.  The stored procedure makes a OPEN SYMMETRIC KEY and DECRYPTION BY CERTIFICATE to unencrypt the data.

[v-henryk-mstf]

Hi @jeffprandall ,

Is your problem solved, do you need further help? Looking forward to your reply.

If the problem has been solved, you can mark the valuable reply as the correct answer to help the other members find it more quickly.

Best Regards,
Henry

[jeffprandall]

No it still does not work.

[jeffprandall]

Permissions ran - top user is the service account, bottom user is a SQL Account used in Gateway Credentials (tests do pass)