SQL Server 2000 Encryption
-
Does SQL Server 2000 offer any type of encrytion within it, or is this something I must purchase as a third party tool? I have noticed all the articles for this topic talk about third party applications and nothing within. It's just that I can't find a straight answer that says I must purchase it!! Overall, I need to encrypt columns that contain sensitive data like social security numbers. I am new to encryption methods and would appreciate it if anyone can demonstrate how I can enable encryption on SQL server 2000.
1. Methods used
2. What others are doing
Also, I have noticed that 2005 does offer encrytion within. Can you describe what these methods and features are\do?
And the benefits of encryption 2005 compared to 2000. Like I mentioned before, I can't find straight forward information and thought it would be best to ask those of you who have had direct experience using encryption with SQL Server.
Thanks
-
As far as I know, there is no column level encryption ot data encryption in sql server 2000. In sql server 2005 you can do column level encryption. You can buy a third party tool for sql server 2000. Try this one
-
There are numerous products out there for Sql Server Encryption that do column encryption. Google "Sql Server Encryption" and you'll find numerous products many that offer evaluation software.
If you're not afraid to get your hands dirty Visual C++ offers a Sql Server dll template that can be used to create an encryption dll that you register as an Extended Stored Procedure that can be used to encrypt column information all you need then is pick an encryption method and code it, (I know because I've done this).Hope this helps.
Good hunting!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply