Stack Overflow
Stack Overflow

Questions tagged [tde]

TDE, or Transparent Data Encryption, is used by Microsoft and Oracle to encrypt database content.

TDE Wikipedia page

141 questions
0
votes
0 answers

Transparent Data Encryption with SQL Server 2016 causing drive space issue

We are attempting to use TDE with SQL Server 2016 to encrypt a large database. However, when the encryption gets to about 91% we receive a drive space error and the encryption fails. Being that TDE does not cause an increase in the database size,…
R4Z0R53DG3
  • 31
  • 4
0
votes
1 answer

Error while restoring TDE certificate on SQL Server 2008 R2

I am facing an error while restoring the certificate for TDE encryption in SQL server 2008 R2. I am using the same certificate which is configured for SSL. Following are the steps which i have taken : First of all convert the .crt file to…
vMittal
  • 81
  • 4
0
votes
0 answers

trying to encrypt database master key with service master key using powershell

I am trying to encrypt the master key in the master database of SQL Server with the Service master key using powershell. The Master Key details are listed using SMO as below. $instanceName = "sqlinstance" $server = New-Object -TypeName…
Adarsh
  • 52
  • 7
0
votes
1 answer

Strong security via Transparent Data Encryption (TDE) in SQL Server 2012?

I received the task to provide a possibility to import highly sensitive data to a SQL Server 2012. There are pretty high restrictions and requirements concerning the data: Neither the Dev Team (incl. me) nor the DBAs are allowed to see the…
Tyron78
  • 4,117
  • 2
  • 17
  • 32
0
votes
2 answers

What is the default encryption algorithm used by Azure TDE?

Azure SQL Server offers Transparent Data Encryption (TDE) by default, with the flick of a virtual switch: There is no option to select an algorithm and I am not using "Bring Your Own Key". Which encryption algorithm is being used and what is the…
Widor
  • 13,003
  • 7
  • 42
  • 64
0
votes
1 answer

Restoring a TDE Encrypted Database Backup to a Different Server - SQL Server 2008

Two years ago, I used the below code to encrypt (TDE) the database in SQL Server 2008 USE MASTER; CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Strong Password' GO USE MASTER; CREATE CERTIFICATE DB_CER WITH SUBJECT = 'DB Certificate' GO USE DB GO…
Mi_Dhah
  • 519
  • 1
  • 7
  • 18
0
votes
1 answer

How to query sensitive data in Cassandra with TDE enabled?

I'm new to Datastax Cassandra, but we have a use case where we need to be able to lookup customers by their E-mail address. But e-mail address is private data, so it must be encrypted at rest. From what I've read about Cassandra/Datastax, it seems…
Beaker
  • 744
  • 7
  • 18
0
votes
1 answer

Unknown command beginning "administer..."

SQL> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\WALLET' IDENTIFIED BY Welcome@123; SP2-0734: unknown command beginning "ADMINISTER..." - rest of line ignored. I have created a wallet and while…
RaJeSh SiNgH
  • 1
  • 1
0
votes
1 answer

Why is SQL server unable to connect to Azure key vault using SQL Server connector

I am trying to encrypt sql server database in Azure VM using TDE where the EKM will use Azure Key vault. I have been following the steps outlined in below link. setup steps for EKM using Azure Key Vault I have followed all the steps exactly…
user2756234
  • 31
  • 3
  • 7
0
votes
1 answer

Event handler for TDE decryption process in powershell

Below code performs the decryption successfully but if the DB is huge it will take sometime to decrypt the DB $sqlServer = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $sqlName $ExistingDB=$sqlServer.Databases.Item($dbname)…
SQLDoctor
  • 343
  • 7
  • 16
0
votes
0 answers

Implement TDE and log shipping on different domains

I have two instances of SQL Server 2016 Enterprise, each running on a different server. They are standalone servers. There is a shared drive on ServerA which can be accessed from ServerB. I have set up log shipping from a database (TESTDB) on…
alan murphy
  • 11
  • 2
0
votes
1 answer

Publishing with .dbproj turns off transparent data encryption

I noticed in the Azure Dashboard that something was turning off Transparent Data Encryption (TDE) on my database. I had turned it on through the Azure Portal. Realized that something in my dbproj publish process included: SET ENCRYPTION OFF There…
viggity
  • 15,039
  • 7
  • 88
  • 96
0
votes
1 answer

Oracle TDE cannot find new PKCS#11 library

I have previously used an Utimaco HSM with Oracle database, but I want to put pcks#11-spyorpkcs#11-logger` between the hsm. The Utimaco HSM library is working and I used this command: alter system set encryption key identified by…
snorberhuis
  • 3,108
  • 2
  • 22
  • 29
0
votes
2 answers

Confusion about TDE and AlwaysOn Availability Groups

This is my first ever post so I'll be brief. I have two SQL 2014 Enterprise servers; one primary and one secondary replica. This is a multi-tenancy deployment with separate databases per tenant. (No shared databases or shared schema). I currently…
David
  • 3
  • 3
0
votes
1 answer

Back up a oracle DB encrypted by TDE

I want to back up my encrypted DB by TDE. So, I run exp command. but I have an errors. because of encrypted table spaces. is there any way to back up my DB encrypted by TDE?? I don't have a idea. plz help me.
Double J
  • 37
  • 1
  • 2
  • 11
1 2 3
…
9 10