How to use Always Encrypted feature with temp table

Surapally Sravan Kumar 0

Hi,We are using Always Encryption in our Azure SQL hosted database(PaaS) and when we are using temp table in an stored procedure which is being used to store and Join with encrypted table's column for UPDATE/INSERT operation, getting error : 'Msg 33293 Level 16 Cannot find the column encryption key because it does not exists or you do not have permissions'.

ShaktiSingh-MSFT 14,701 Reputation points

2024-07-10T09:24:31.9933333+00:00

Hi Surapally Sravan Kumar •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

1 answer

ShaktiSingh-MSFT 14,701 Reputation points

2024-07-09T08:56:25.29+00:00

Hi Surapally Sravan Kumar •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting error 'Msg 33293 Level 16 Cannot find the column encryption key because it does not exists or you do not have permissions' in Azure SQL DB.

Please try creating of CMK and CEK in tempdb as described here in the article:

https://dba.stackexchange.com/questions/187548/can-sql-server-always-encrypted-be-used-for-temporary-tables

Also refer to similar post here and let us know if this helped.

Thanks
Please sign in to rate this answer.
Surapally Sravan Kumar 0 Reputation points

2024-07-11T08:12:57.72+00:00

Hi ShaktiSingh-MSFT ,
Thank you for your response.but

There’s no accessibility of TempDb in Azure SQL Database (PaaS).
when ever we are placing the "USE Temp DB" it is giving an error like "Msg 40508, Level 16, State 1, Line 1 USE statement is not supported to switch between databases. Use a new connection to connect to a different database."

ShaktiSingh-MSFT 14,701 Reputation points

2024-07-11T08:20:40.5233333+00:00

I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

Surapally Sravan Kumar 0 Reputation points

2024-07-17T08:01:19.55+00:00

Hi Shakti Singh,

Thanks for the prompt response !!

We not have support plan , please help on other options

ShaktiSingh-MSFT 14,701 Reputation points

2024-07-18T05:36:21.23+00:00

Hi Surapally Sravan Kumar •,

Could you send an email to AzCommunity@Microsoft.com with your Subscription ID and thread link to this post, and I will enable a one-time free support request for your subscription.

Please reference this forum thread in the Email Subject:

ATTN: SHAKTI - How to use Always Encrypted feature with temp table

Regards,

@ShaktiSingh-MSFT

Surapally Sravan Kumar 0 Reputation points

2024-07-18T08:19:34.68+00:00

Hi ShaktiSingh,

Thanks for the support!!

I sent email shared email id and please look into it.
Sign in to comment

Share via

How to use Always Encrypted feature with temp table

1 answer