SQL Server Always Encrypted with Azure Key Vault and Client Secret - can I view the unencrypted data in SSMS
I am using SQL Server Always Encrypted to encrypt some columns of sensitive data. I am using an Azure Key Vault to store the keys. Access to the key vault is granted via client secrets, not certificates. I would like to be able to view the unencrypted data in SQL Server Management Studio on my machine. I know that if we were using a certificate I could import the certificate into my machine and all would be good. I can't find a way to do this if you are using client secrets. Is this possible, and if so how? Thanks
Solution
Add to @MichaelHoward-MSFT's answer, your account should have the permission to access the Azure Key Vault.
- In the SQL Server Management Studio, we should select the account which has the permission to access the Azure Key Vault. Then click the Options button.
- Add the string
Column Encryption Setting=enabledto the tab as follows:
- When we connected to the server, then we can execute the sql query, it will pop up prompt box, then we click the Enable. Then we can see the Decrypted column.
- SSRS 2014 date range parameters not working with an OR clause
- Calculate duration using T-SQL
- Conversion failed when converting the nvarchar value to data type int while inserting records into table
- How can I run just the statement my cursor is on in SQL Server Management Studio?
- SQL rollup to add a total row for multiple columns
- Select SQL Server database size
- INSERT INTO a temp table, and have an IDENTITY field created, without first declaring the temp table?
- Create single image for database diagram in SQL Server
- Automatically define the DataTable in C# from the schema of SQL server tables?
- TSQL: how to write this query?
- CREATE TABLE permission denied in database 'tempdb'
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Does database compound index order matter if the first column is only queried with an equal operation?
- Difference between .NET, OLEDB, and Native Providers in SSIS
- Is there a way to populate a HTML table from a database? (SQL Server, VB.NET, ASP.NET)
- ExecuteScalar() not returning full contents of cell
- Why does normal execution resume after Raiserror in Catch block
- PRINT output doesn't appear immediately in the Messages pane in SSMS
- Comma delimiter is not being respected
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- Select all unique values in SQL table with additional information
- How to avoid the "divide by zero" error in SQL?
- How do I get list of all tables in a database using TSQL?
- Basic SQL commands in Terraform
- Could there be a deadlock when using optimistic locking?
- Get list of tables but not include system tables (SQL Server 2K)?
- How to change keyboard shortcut - F5 to Ctrl + Enter to execute SQL command in SQL Server Management Studio
- Self join to compare rows of table?
- Transform DateTime field to provided format in where clause
- SSMS crashes instantly