Solved

What version of SQL Server do I need to encrypt the database?

Posted on 2015-02-17
8
55 Views
Last Modified: 2015-02-20
Do I need the Enterprise level of SQL 2012 or 2014 to encrypt the database?
0
Comment
Question by:NytroZ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
8 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40614730
If you are looking to encrypt the database files and backups, both can do this
0
 
LVL 24

Accepted Solution

by:
DMTechGrooup earned 500 total points
ID: 40614733
Enterprise.

1. Transparent Data Encryption

Transparent Data Encryption (TDE) is the primary SQL Server encryption option. It was first available in SQL Server 2008, and as with the SQL Server 2012 release, it's available only in the SQL Server Enterprise edition, not in the Business Intelligence, Standard, or Express editions.
0
 

Author Comment

by:NytroZ
ID: 40614753
So my next concern is licensing it.  I have a dual quad core processor server.  If I assign only one processor to the vm that will have SQL Enterprise installed, how many licenses do I need to purchase?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 24

Expert Comment

by:DMTechGrooup
ID: 40614757
I would contact your reseller and have their MS licensing expert give you the best solution.  MS licensing takes 4 MBA's and a PHD to barely understand it.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40614779
If it is 2008R2, you can licence it on a server basis. For the 2012 onwards, if you don't have  Sofrware Assurance, you need to licence each core. In your case, even though you are using only one core, you need to buy 4 core licences (that's the minimum for the fist 1 to 4 cores) ..
0
 

Author Comment

by:NytroZ
ID: 40614783
Ouuuch!  Are there any 3rd party tools that will allow encryption on Standard Edition?
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40614837
There are couple of options
1. Use Bitlocker drive encryption or similar products
2. Use database encryption keys at database/instance level  
An example of how this can be done is shown here  
http://msdn.microsoft.com/en-us/library/ms179331.aspx
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Throw Error 7 34
Many to one in one row 2 39
SQL Select Query help 1 37
T-SQL: Need Group By to use "fuzzy logic"?? 3 19
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

749 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