4

I have a certificate with my SQL Server Database. What will happen after the certificate gets expired?

Will the record insertion, selection, deletion will work after certificate gets expired?

sms247
  • 4,404
  • 5
  • 35
  • 45

2 Answers2

3

If your certificate gets expired there will be no effect. Certificate expiration is not enforced when the certificate is used for encryption.

Check this post for more information.

sms247
  • 4,404
  • 5
  • 35
  • 45
0

It looks like you're using Transparent Data Encryption. If the certificate that protects the database master key expires, I'm pretty sure that the database will fail to start.

Ben Thul
  • 31,080
  • 4
  • 45
  • 68
  • yes i'm using the same, but I found nothing on the internet that what happens after it's get expired. – sms247 Feb 07 '14 at 03:57
  • There will be no effect if certificate is expired according to this post. [link](http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d9a80843-51d9-469c-b14f-07f5e7827514/alter-the-expiration-date-of-my-certificate-tde-sql2008?forum=sqlsecurity) – sms247 Feb 07 '14 at 05:01