I have a new Win 11 laptop and the checkbox to enable column encryption is missing. Anyone seen this. It doesn't work in code either. To be clear, the checkbox is present on a machine upgraded from win 10 to 11.
lcConnStr = [Driver={ODBC Driver 13 for SQL Server};Server=LAPTOPXXXX\SQLEXPRESS;UID=xxxxxx;PWD=xxxxxx;APP=app name;DATABASE=bdname;ColumnEncryption=Enabled;]
nConn = SQLStringConnect(lcConnStr)
With column encryption on table, a select query on this connection will return plain data. Again it works on all 3 Win 10 machines. But they all have the Column Encryption checkbox just below Transparent Network IP Resolution.
I have ruled out the certificate being invalid because even SQL server errors if I delete the certificate. SQL server happily decrypts the encrypted columns when the certificate is re-imported back. It appears to be a win 11 issue. I have inspected the components of ODBC Data Sources app. They are identical on the 2 win 11 machines. It works as expected on the one upgraded from win 10.
I have attached the screenshot
Thanks in advance
Mathias
lcConnStr = [Driver={ODBC Driver 13 for SQL Server};Server=LAPTOPXXXX\SQLEXPRESS;UID=xxxxxx;PWD=xxxxxx;APP=app name;DATABASE=bdname;ColumnEncryption=Enabled;]
nConn = SQLStringConnect(lcConnStr)
With column encryption on table, a select query on this connection will return plain data. Again it works on all 3 Win 10 machines. But they all have the Column Encryption checkbox just below Transparent Network IP Resolution.
I have ruled out the certificate being invalid because even SQL server errors if I delete the certificate. SQL server happily decrypts the encrypted columns when the certificate is re-imported back. It appears to be a win 11 issue. I have inspected the components of ODBC Data Sources app. They are identical on the 2 win 11 machines. It works as expected on the one upgraded from win 10.
I have attached the screenshot
Thanks in advance
Mathias