Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Certificate Backup Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 9:00 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 529, Visits: 617
Hi, I am unable to do back up of certificate and private key. It giving the error message


BACKUP CERTIFICATE TDECertificate
TO FILE= 'C:\Program Files\Microsoft SQL Server\Key\TDECertificate.certbak’
WITH PRIVATE KEY
(FILE='C:\Program Files\Microsoft SQL Server\Key\TDECertificate.pkbak',
ENCRYPTION BY PASSWORD= 'Chinni1');

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '\'.
Msg 105, Level 15, State 1, Line 5
Unclosed quotation mark after the character string ');
Post #1522741
Posted Friday, December 13, 2013 10:24 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:13 PM
Points: 31,040, Visits: 15,472
When I grab this, the quote after the filename for the public side of the cert isn't a single quote, it's a literary quote.








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1522791
Posted Friday, December 13, 2013 11:14 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 554, Visits: 1,620
I hope that's not the actual password you're using other places.
Post #1522810
Posted Monday, December 16, 2013 7:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 529, Visits: 617
If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only but there is no decryption. When I want to restore this database backup from this instance in another instance, how can I do?
Post #1523240
Posted Monday, December 16, 2013 7:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 529, Visits: 617
If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only but there is no decryption. When I want to restore this database backup from this instance in another instance, how can I do?
Post #1523242
Posted Monday, December 16, 2013 8:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:13 PM
Points: 31,040, Visits: 15,472
Create a master key in master, restore this certificate, then the restore of a TDE database is the same as any other database restore.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1523258
Posted Wednesday, December 18, 2013 3:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:00 PM
Points: 529, Visits: 617
Thanks for the reply. Please let me know how to restore that certificate that was created in another instance.
Post #1524380
Posted Wednesday, December 18, 2013 4:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:13 PM
Points: 31,040, Visits: 15,472
You use the CREATE CERTIFICATE command with the FROM FILE option.

http://voiceofthedba.wordpress.com/2012/03/05/restoring-a-certificate/







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1524395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse