Tools to enhance Sql server Security

Posted on 2014-08-12
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
    LVL 32

    Expert Comment

    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
    HSM's are a best practice when encrypting a database: but being cloud-hosted, I don't know. Perhaps there are HSM's available to AWS... it looks like there are:

    Author Comment


    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

    Maybe your cloud provider can give you your own HSM:

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    When the confidentiality and security of your data is a must, trust the highly encrypted cloud fax portfolio used by 12 million businesses worldwide, including nearly half of the Fortune 500.
    Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now