Data Encryption

HI There,
I was wondering how I encrypt the data I have in my SQL sevrer database? is
there some built in tool that will do this? if there is can someone provide
me with a code snippet to get me started?
SeanSean,
Generally you will be required to write extended stored procedures that
calls on CryptoAPIs for this, as SQL Server encrypts at the packet level
when you setup your network libraries with encryption turn on either using
SSL or multiprotocol. I don't know of samples that I can supply you with
but I believe companies such as Protegrity has some sort of solution, you
might like visiting their web site and search on the internet for some
others. I'm not sure if the next release of SQL Server, Yukon, will have
this built in, but because it can call into the Cryptography namespace in
the CLR, it may make your life a little easier. Another solution is to use
Windows encrypted file system (EFS) and encrypt your entire database that
way although this might not be as granular as you want it to be.
I hope this helps.
Regards
James|||Have a look at:
Whamware.Crypt - www.whamware.com
dbEncrypt - www.appsecinc.com
Encryptionizer for SQL Server - www.netlib.com
Tom
"sean" wrote:
> HI There,
> I was wondering how I encrypt the data I have in my SQL sevrer database? i
s
> there some built in tool that will do this? if there is can someone provid
e
> me with a code snippet to get me started?
> ...|||I can also recommend XP_Crypt from www.activecrypt.com cheap, fast and very
easy to use, they also sell a great activeX component so you can easily encr
ypt in your front end app and decrypt in the database etc..
nntp://news.microsoft.com/microsoft.public.sqlserver.security/ >
Have a look at:
Whamware.Crypt - www.whamware.com
dbEncrypt - www.appsecinc.com
Encryptionizer for SQL Server - www.netlib.com
Tom
"sean" wrote:
> HI There,
> I was wondering how I encrypt the data I have in my SQL sevrer database? i
s
> there some built in tool that will do this? if there is can someone provid
e
> me with a code snippet to get me started?
> ...
[microsoft.public.sqlserver.security > ]