Looking for Guidance on Encryption (SSL & TDE)

[former_member212248]

References • SSL o http://msdn.microsoft.com/en-us/library/ms189067.aspx o http://blogs.msdn.com/b/saponsqlserver/archive/2011/03/09/sql-server-network-encryption-with-sap.asp... • TDE o http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&cad=rja&uact=8&ved=0CEYQFjAEahUKEwjS0... Looking for recommendations, steps, etc. ... We are building out a new environment for our SAP system and going through a big upgrade: • Moving to Windows Server 2012 (from 2008 R2) • Moving to SQL Server 2014 (from 2008 R2) And, want to make sure that we do all of the best practices with regards to securing the environment.  Please share any knowledge, experience, and recommendations (both good and bad) with doing the following: • Enabling encryption for the database & server communication (i.e., SSL) -- but, it is not on current versions (see 'Reference' above) • Encrypt database files, log files, tempdb, and backups (i.e., TDE) Thanks in advance! ~ Melanie

[luisdarui]

Hi Melanie,

It seems that you have already the answer of your guidance:

http://blogs.msdn.com/b/saponsqlserver/archive/2011/03/09/sql-server-network-encryption-with-sap.asp...

This blog post contains also the SAP Note for TDE which is:

1380493 - SQL Server Transparent Data Encryption (TDE)

Do you have any specific question about this?

Kind regards,

Luis Darui

[former_member212248]

I guess I'm mostly looking for someone who has set this up -- any gotchas or watch out for, etc.  the link that I have for SSL is rather dated, so wasn't sure if this is still a recommendation or if there was something better to do. Thanks for your quick reply  :0)