Tag Info

New answers tagged

0

As datagod points there's a legality component towards the practice of storing sensitive information such as a passport number. Where I live an active enforce of UK law Data protection act is the standard practice. But in other places like Chile is totally legal to store passport number which is the same as the ID (RUN), some websites even offer the ...


0

Tom Li- MSFT described a solution to what sounds like your problem, but his solution was for SQL Server 2008. (But just how much has the installer been improved since then?) https://social.msdn.microsoft.com/forums/sqlserver/en-US/f009e660-503a-4569-a92d-9cc2ef790ca3/install-failure-certificate-chain-trust Key points from his post include: This ...


1

You have several options: If you want to encrypt the files containing the database you have dm-crypt included in the kernel to provide that kind of security https://gitlab.com/cryptsetup/cryptsetup/wikis/DMCrypt If your app its outside the database machine also you want to encrypt the communication, you can use the ssl option that its already included in ...


0

I agree with Jithin R and ensuring the SQL Server "service" account (what you have set in the services.msc for the login as, and ensuring it has at least MODIFY or FULL permissions at the NTFS folder level where the MDF and LDF files are created when they code dynamically creates the DB). It sure sounds like an NTFS permission issue with whatever security ...


1

If you have MYSQL installed and running on a Windows Server, you may want to look into BitLocker with TPM encryption plus PIN boot password. Even if the host OS is Windows but the CentOS is a VM, then this would suffice. TrueCrypt VeraCrypt There's data-at-rest encryption so when it's at rest on a server disk partition not being accessed by some query, ...


0

As in the other answer: you need a recent CU for TLS1.2. See https://support.microsoft.com/en-us/kb/3052404: Cumulative Update 8 for SQL Server 2014 Cumulative Update 1 for SQL Server 2014 SP1 Cumulative Update 6 for SQL Server 2012 SP2 Cumulative Update 7 for SQL Server 2014 After enabling only TLS 1.2 you will possibly encounter two errors: SQL ...


1

ALTER DATABASE ENCRYPTION KEY Requires CONTROL permission on the database and VIEW DEFINITION permission on the certificate or asymmetric key that is used to encrypt the database encryption key. You must also add view definition according to MSDN. https://msdn.microsoft.com/en-us/library/bb630389%28v=sql.110%29.aspx



Top 50 recent answers are included