Tag Info

Hot answers tagged

6

SQL Server supports SSL 3.0 and TLS 1.0 only, you must have at least one of them enabled or SQL Server will not be able to start. SQL Server does not support TLS 1.1, 1.2 etc, it specifically uses TLS 1.0. Your options here are to enable SSL 3.0 and/or TLS 1.0, no other way around it I'm afraid. Cheers Mat


4

When you restore a database, TRUSTWORTHY is automatically set to OFF. For Service Broker, if you don't use encryption and do use cross-database message transmission, TRUSTWORTHY needs to be set to ON. Try ALTER DATABASE MyDB SET TRUSTWORTHY ON ...for all restored databases involved with Broker.


4

Server1 running SQL Server 2012 with Service Master Key A, db1 with Database Master Key 1, symmetric key and certificate available. I assume that the db1 master key is encrypted with the SMK. This makes everything encrypted by the database master key 'available' to applications, w/o having to explicitly open the database master key. What you need to do ...


3

To create a certificate for SSL encryption for SQL Server you need a certificate for Server authentciation. That is [EnhancedKeyUsageExtension] OID = 1.3.6.1.5.5.7.3.1 If you want to manually create a certificate for this using Windows Certificate services you need to do it like this. ...


3

This is not an ASYMMETRIC KEY, it is a SYMMETRIC KEY. Change GRANT REFERENCES ON ASYMMETRIC KEY to GRANT REFERENCES ON SYMMETRIC KEY


3

Yes. Transparent Data Encryption doesn't change any of the internal processing of queries. Database pages are transparently encrypted/decrypted during I/O (i.e. when they are read from or written to disk). In-memory query processing is therefore unaffected, so indexes continue to function exactly as they did without TDE. TDE is designed to negate the need ...


2

OK, In case anyone wants to know, I got to the bottom of this. The chain is pretty easy to work out: Create Service Master Key (automatically done upon install) Create Database Master Key (user creates their own key) SymetricEncrypt(Service Key,Database Master Key) -> Store Encrypted Master Key into Master DB Create Certificate ...


2

You can join on the certificate thumbprint: use master; go select database_name = d.name, dek.encryptor_type, cert_name = c.name from sys.dm_database_encryption_keys dek left join sys.certificates c on dek.encryptor_thumbprint = c.thumbprint inner join sys.databases d on dek.database_id = d.database_id; My sample output: database_name ...


2

PostgreSQL comes to my mind. You have pgcrypto library for encrpyting data and there are drivers for .Net


2

I primarily use them when I'm moving or copying a database to a new instance of SQL Server. In that case, the DMK in the database will be re-encrypted with the new instance's service master key, but the objects encrypted by the DMK (in your case, the symmetric keys) will not be updated accordingly. You'll need to restore the DMK from a separate backup using ...


2

While it's true the SQL needs one of these enabled, there's a workaround. Open gpedit.msc. In the Local Group Policy Editor, double-click Windows Settings under the Computer Configuration node, and then double-click Security Settings. Under the Security Settings node, double-click Local Policies, and then click Security Options. In the details pane, ...


1

I supported PCI and HIPPA compliant data as a DBA contractor for the Air Force and as a consultant for hospitals. It is part of a DBA's job to have access to data, whether it is encrypted or not. The PCI compliance data was encrypted by the application, but I could still see it decrypted because I had access to the DLL that handled it...quick PowerShell ...


1

My boss ask me for possibilities to do the encryption on content DB level, it backup. or on column level? This is something you and You're boss need to sit and discuss on as what could be pros and cons of using TDE or Cell level encryption: However Few points to note: TDE does not offer the granularity of protection that cell-level encryption ...


1

Service Broker uses encryption by default unless you specify that you don't want to use it when sending the messages. At some point the database master key had to be created unless like I said you were specifying that encryption was off when you send the messages (it might be when you create the conversation, I don't remember). Anyway, when you restored ...


1

Microsoft's MSDN blog has a table describing the possible conditions and their outcomes. See Selectively using secure connection to SQL Server to understand client side setting and connection property options impacting secure connections for just the client involved. The server and other clients are not impacted.


1

I got a SaaS product and the data is kinda sensitive. I want to give my customers 100% security on the fact that I can't read their data. If it's software as a service, and you do more than simply store blobs of data then give those blobs back when the customer asks, this is pretty much impossible. You're dreaming. You can't realistically combine SaaS ...


1

If you are receiving the thumbprint error the certificate was not created properly from the Source Server's Cert/Key backups. I found this question which was already answered with a solution for you: Restore encrypted database to another server



Only top voted, non community-wiki answers of a minimum length are eligible