mssql-docker icon indicating copy to clipboard operation
mssql-docker copied to clipboard

TDE failing to initialize

Open jbful opened this issue 8 years ago • 8 comments

Creating database encryption key fails with generic error in RC1, works in CTP2.1: Msg 15508, Level 16, State 24, Line 11 An error occurred while generating a key required by this operation.

Master and TDE certificate created

jbful avatar Jul 20 '17 18:07 jbful

@jbful Can you share your SQL Server errorlog found in /var/opt/mssql/logs?

meet-bhagdev avatar Jul 21 '17 19:07 meet-bhagdev

@jbful And can you tell us what the sequence of sequence of sequence of t-sql commands led to this? We are trying to repro this

meet-bhagdev avatar Jul 21 '17 19:07 meet-bhagdev

@jbful Also, are you running sqlserver on Windows or Linux?

sayeedh avatar Jul 21 '17 20:07 sayeedh

@jbful : Ok, I was able to repro this. So, I do not need the above information, at least for now.

sayeedh avatar Jul 22 '17 02:07 sayeedh

Sorry, was out of town this weekend. For the record, SQL on linux docker. My sqlcmd snippet is attached and works in 2,1 but not RC1. Assuming you do not needs logs if reproducible.

tde.txt

jbful avatar Jul 24 '17 14:07 jbful

thanks

sayeedh avatar Jul 24 '17 18:07 sayeedh

@jbful @sayeedh, is this issue resolved or do we need anything else?

meet-bhagdev avatar Oct 13 '17 22:10 meet-bhagdev

How is this issue still open almost 6 years later?!

shawndewet avatar Sep 26 '23 08:09 shawndewet