0

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

Siddharood
  • 908
  • 1
  • 12
  • 24

1 Answers1

1

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.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
  • I am using TDE Enabled mdf file and SqlLocalDb.I need connection string format to use mdf file using C# or else is there any alternative to secure mdf file preventing from attaching and restoring. – Siddharood Dec 19 '12 at 11:09
  • the answer is the same as above. – Remus Rusanu Dec 19 '12 at 11:11