Share via

Connect Excel to SQL with Always Encrypted

Anonymous
2017-02-03T23:49:51+00:00

I'm experimenting with SQL 2016 Always Encrypted. I have a test database with a table that has two columns encrypted.

I built a little Visual Studio app that can read and decrypt the columns. So I have everything work (encryption, certificate, ect). As we use Excel for viewing SQL data quite often, I'm attempting to get Excel connected to the database and decrypt the columns for display. I've been unsuccessful in my pursuit and am looking for pointers.

I've created an ODBC connection using the ODBC Driver 13 for SQL Server driver which I read was required. When I walk through the Data Connection Wizard in Excel utilizing this ODBC connection it only displays the non-encrypted columns. When I open the New Query wizard and connect to the database, I see all the columns but the encrypted columns show "binary" in the fields. I'm assuming I need to add

I'm assuming I need to add something similar to ColumnEncryptionSetting=Enabled somewhere in Excel similary as I did with my Visual Studio app but cannot figure out where.

Can someone point me in the right direction on how to connect Excel to a SQL database that is utilizing Always Encrypted columns.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-07T16:59:57+00:00

    I have not. I gave up after posting this.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-09-03T05:00:34+00:00

    Hi,

    I'm trying to retrieve my data just like you did and have the same issue. Have you found a solution to fix it ?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-02-11T15:45:29+00:00

    No one?

    Was this answer helpful?

    0 comments