Solved

MS SQL Restore TDE database error

Posted on 2016-11-03
3
38 Views
Last Modified: 2016-11-24
I'm trying to restore a TDE encrypted database using MS SQL Server Management Studio (Express) on my local PC.  Do I need some type of super user or admin login?  I'm a very novice SQL guy, but I have restored databases to this PC with this installation before, just not TDE encrypted ones.  I am getting this error:  The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it.

I followed these steps:

use master
GO

select * from sys.symmetric_keys
GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Infantry'
GO

select * from sys.symmetric_keys
GO

CREATE CERTIFICATE CRMLTOP_wimmersales_c28e1a6b616743cd8a5d33bb400b0d1f
FROM FILE = 'C:\Users\steve.t\Desktop\CRM\CRMLTOP_dimmersales_c28e1a6b616743cd8a5d33bb400b0d1f.pfx_1.cer'
WITH PRIVATE KEY (FILE = 'C:\Users\steve.t\Desktop\CRM\CRMLTOP_dimmersales_c28e1a6b616743cd8a5d33bb400b0d1f.pfx_1.pvk',
DECRYPTION BY PASSWORD = 'CRMLTOP_dimmersales_c28e1a6b616743cd8a5d33bb400b0d1f')
0
Comment
Question by:AxeTracks
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 500 total points (awarded by participants)
ID: 41873813
My first thought is that TDE is an Enterprise Feature.  I wouldn't expect you to be able to restore the database to a local (Express) instance.  I suspect would be that you'd need an Enterprise (or Developer or Evaluation) instance, ideally at an identical SQL version, but absolutely not at a lower version.
0
 

Author Comment

by:AxeTracks
ID: 41875112
I have found out that TDE is Enterprise only, and I am using Express.  It's not possible to restore a TDE on Express.
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 41900308
TDE is an Enterprise only solution
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 42
Creating SQL script using SQL data and SQL script 8 33
VBScript Write Column Headers 3 31
create an aggregate function 9 31
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now