SQL Server automatic encryption

Hi, thank you for your interest. This is indeed slated for a later CTP. Regarding the re-attach, the detached database is still encrypted. To use this on a new server, you would need to migrate (backup and restore) the certificate protecting the data to your new server as well. Otherwise, the reattach will fail. This is not handled by SQL Server Manager; this is a user controlled process.

Please let me know if you would like further info or have any more questions.

Thanks,

Sung

SungMSFT at 2007-10-2 >

Hi Rodney,

Thanks for your interest. We are only considering the transparent encryption feature for Enterprise Edition at this time and no plans have been announced to support any other SKU.

The encryption features introduced in SQL Server 2005 will continue to be availble on all SKU's.

Thanks,

Sung

SungMSFT at 2007-10-2 >

Hi Umesh,

SQL Server 2008 will be introducing a new feature called "Extensible Key Management" (EKM) which allows for third party cryptographic providers and key stores to be used alongside the encryption and key management shipped as part of the server. Does your question relate to the EKM feature or general SQL Server key management?

For general SQL Server key management documentation, please refer to (NOTE: this is unchanged from SQL Server 2005):

http://msdn2.microsoft.com/en-us/library/ms189586.aspx

There is a also a TechNet presentation available:

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032293594&CountryCode=US

Hope this helps,

Sung

SungMSFT at 2007-10-2 >