If you specify "Engine Default" when encrypting a SQL CE database, what specific type of encryption does it use? (Let's assume version 3.5)
A:
If it is the same as SQL Server - and I imagine it is - then it will be Triple DES
Mark Brittingham
2009-03-26 20:01:02
Is there a reason to assume that it is?
brian
2009-03-26 20:04:34
Well, just the assumption that they would re-use code already put in place for the main SQL Server engine. But again, I do not know this for sure.
Mark Brittingham
2009-03-26 22:20:48
That's a really poor assumption, especially since the two products share zero code and are done by completely different teams.
ctacke
2009-04-14 17:01:04
There's no need to be rude, ctacke. I think my answer is pretty clear that I am just passing along the encryption used in SQL Server. Would you care to provide some reference regarding your assertion that they share "zero" code? This seems like a far more controversial claim than anything that I've said.
Mark Brittingham
2009-04-17 12:45:15
+2
A:
Engine Default is AES128 (it's not compatible with Windows Mobile 2003 or Windows CE 4.2)
Shane O'Grady
2009-04-14 12:49:40
Wikipedia says 128 bit but not what scheme. Shane, do you have a reference for your answer?
brian
2009-04-14 19:44:04
brian: No definitive reference, but these may help.http://www.pluralsight.com/community/blogs/jimw/archive/2007/07/31/48117.aspxhttp://social.msdn.microsoft.com/forums/en-US/sqlce/thread/0120994f-807b-40d1-9e65-d1f21224980e/Also, since DBs encrypted with "Engine Default" cannot be opened on Windows Mobile 2003 (which cannot handle AES) I am pretty certain that is what it uses.
Shane O'Grady
2009-04-29 11:35:27