Is this Normal? Encrypted data is still same after alter master key regenerate with new password has been executed.


hi all,

this may normal want make sure.

i have encrypted data in table. can decrypt correctly without issue. here 1 row pkid =1

0x00f353374962954f9419c3641e96de610100000085a8516dbd9c95bbd256143ff1deb39825cbb8cc0cb8b164809303c335569fff9cca3d68543266f412b05c7022124bad0195f5229c7d24f89751d7527918b72f

i executed below steps change master key.

open master key decryption password = 'my0ldp@55word'    go        alter master key regenerate encryption password = 'mym0strecentnewp@ssword'    go.

everything executed successfully.

below  encrypted data pkid =1 

0x00f353374962954f9419c3641e96de610100000085a8516dbd9c95bbd256143ff1deb39825cbb8cc0cb8b164809303c335569fff9cca3d68543266f412b05c7022124bad0195f5229c7d24f89751d7527918b72f

decryption working correctly.

i notice encrypted data same old key , new key. normal. expecting different pattern in encrypted data after master key change. 

thanks in advance,

snaseer

houston-tx

read

encryption hierarchy

you have changed key gives access other keys.  when issue "alter master key regenerate "

the regenerate option re-creates database master key , keys protects. keys first decrypted old master key, , encrypted new master key. resource-intensive operation should scheduled during period of low demand, unless master key has been compromised.

alter master key

the other keys not changed, decrypted , re-encrypted.  data encrypted other keys does not have decrypted , re-encrypted.

david

david http://blogs.msdn.com/b/dbrowne/




SQL Server  >  Getting started with SQL Server



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more