Hi I can open the master key...
USE tempdb
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'
but when i tried following qquery it give me an error,
use tempdb
go
BACKUP CERTIFICATE SQLServerTDECertificate
TO FILE = 'C:\Users\RawalPr1\Desktop\T1\MySQLCert.bak'
WITH PRIVATE KEY (file='C:\Users\RawalPr1\Desktop\T1\MySQLCertKey.pvk',
ENCRYPTION BY PASSWORD='password')
error:
Cannot write into file 'C:\Users\RawalPr1\Desktop\T1\MySQLCertKey.pvk'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.
what to do next?
I also tried on several other location except this..but still the same replay.
thanks.