[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Tools to enhance Sql server Security

Posted on 2014-08-12
Medium Priority
Last Modified: 2014-11-12

Can anyone Suggest Third party Tools which are available to enhance sql server security in terms of access and data integrity(i.e. encryption).

For Addition Info,

We are using sql server 2012  on AWS (amazon cloud) EC2.

Question by:ccfcfc
  • 2
LVL 36

Expert Comment

ID: 40255342
hmm, I would use SQL Server.. but on the other hand: of what levels of security are we talking about?

As it's a cloud hosted, you cannot control access. Cause physical access control is not in your hand.
Encryption of cloud system means in a strict sense, that you need to encrypt data on cell level and handle the encryption/decryption on a third system which is totally under your control (not hosted).

On the other using the default encryption provided by SQL Server itself allows you to loose backup files without further consequences.

Basically: Security in a cloud system heavily depends on the basic security provided by the cloud hoster.
LVL 38

Expert Comment

by:Rich Rumble
ID: 40293696
HSM's are a best practice when encrypting a database: http://en.wikipedia.org/wiki/Hardware_security_module but being cloud-hosted, I don't know. Perhaps there are HSM's available to AWS... it looks like there are:http://aws.amazon.com/cloudhsm/

Author Comment

ID: 40341247

Here i am talking about encryption for sql server database files (.mdf and .ldf and backup files). as we are in cloud we would like to secure our database files with third party software tools as sql server standard edition does not support TDE.

Can anyone suggest some tools that support encryption on cloud .

LVL 38

Accepted Solution

Rich Rumble earned 1000 total points
ID: 40342704
Maybe your cloud provider can give you your own HSM: http://aws.amazon.com/cloudhsm/

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses
Course of the Month19 days, 14 hours left to enroll

873 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