Search code examples
sql-serverc#-4.0ado.netconnection-stringtde

TDE Enabled database connection string in ADO.Net using C#

I have a .mdf file and i can attach it at run time and access it from C#.But if the same file is TDE enabled i am not getting the format of connection string to be used for attaching it.Please help

Solution

  • A TDE database cannot be attached from the connections string. It has to be permanently attached to a an Enterprise Edition server and the decryption certificate must be properly set.