cannot attach encrypted database

Question

Hi people,

I've got the following problem. We had our instance of SQL setup for SQL 2012 CTP3 on our dev environment. Now that SQL 2012 is out, we uninstalled the previous instance. Now that I have sql installed i'm trying to reattach some of the databases. I have the following items : Certificate, Password and Private key. When I try and run the following script i am getting the error :

USE MASTER
GO
CREATE CERTIFICATE CERTIFICATE FROM FILE = 'C:\Users\me\Desktop\TDE\Certificate.cer'
WITH PRIVATE KEY (FILE = 'C:\Users\me\Desktop\TDE\Private_Key.pvk',
DECRYPTION BY PASSWORD = 'password');

The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it.

Can someone please help me with what i'm missing? Thanks...

Update : I have been messing around with permissions etc. I have now managed to create my certificate from the files, but i still cannot attach the database. I am getting

Cannot find server certificate with thumbprint '0xD7AABE7C1B2A50A85BEC01AC5F204B77339492AC'.

I'm giving up... i think somehow we've got a certificate mix up... thanks for your help anyway, off to create a new dev environment and backup certificates!

Answer 1

0

It sounds like you don't have permission to access the folder where the certificate is. Make sure the SQL Server service account has access rights to the folder and try again.

answered May 14 '12 at 02:39 PM

WilliamD
25.3k ● 16 ● 18 ● 41

(comments are locked)

Answer 2

0

Not sure if this will fix it, but you are missing the "\" in the path for the certificate & key. That might have been just a formatting thing when you posted the question.

USE MASTER
GO
CREATE CERTIFICATE CERTIFICATE FROM FILE = 'C:\UsersmeDesktopTDECertificate.cer'  WITH PRIVATE KEY (FILE = 'C:\UsersmeDesktopTDEPrivate_Key.pvk',  DECRYPTION BY PASSWORD = 'password');

Hope this helps!

answered May 14 '12 at 02:20 PM

JohnM
4.5k ● 1 ● 3 ● 7

na... Shawn edited my post and removed them for some reason. I have been using backslashes...

May 14 '12 at 02:27 PM jhowe

I figured as much, but I still thought that I'd point it out. ;-) You can completely disregard my answer then. =)

May 14 '12 at 02:32 PM JohnM

(comments are locked)

cannot attach encrypted database

Follow this question

Related Questions