Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2004-11-23 : 05:55:00
|
| Hello,are there any free scripts to encrypt and decrypt values in SQL Server?thanksafrika |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-23 : 08:31:07
|
| You can try here:http://www.activecrypt.com/products.htmlKeep in mind encryption is not a cure for all security problems. Encrypting data unnecessarily can create a huge performance burden on SQL Server. For certain things, like credit card numbers, it makes sense, but it does not for most other data. It also doesn't fix the problem of unwanted access. If you are encrypting data to keep regular users from seeing it, then you need to change your security model and deny permissions to those users. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2004-11-23 : 11:31:06
|
| thanks a lot robvolkmy sql server is web based, so keeping out the administrator's would be difficult, its a thing of trust, i just want to keep usernames and passwords and a few other data encryptedthanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-26 : 02:32:52
|
| Can you tell me what you find that you like the look of please?Kristen |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2004-11-26 : 13:45:56
|
| dont understand what u are saying kristen |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-26 : 13:54:04
|
| Sorry: if you find anything that you like, please post a link here.Kristen |
|
|
|
dotnetallday
Starting Member
16 Posts |
Posted - 2004-11-30 : 00:58:45
|
| I have some encryption schemes in VB.NET if anyone is interested. The code handles both MD5 Hashing and Triple DES encryption. This method means data would be encrypted and decrypted before being sent to the database. But if keys are lost, the data will be unreadable. The Triple DES scheme encrypts data for insertion as a varbinary type. MD5 encrypts data for insertion as a varchar type.Let me know and I'll post. I'll post it in the ASP.NET section, though.Jason A. Kiesel Kiesel Media Group, Inc. http://www.kmg.net http://hosting.kmg.net *ASP.NET Web Hosting Starting @ $9.99 / Month |
|
|
|
|
|
|
|
|
Encryption using strored proceedures or T SQL