Re: Encryption of Data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ch (ch_at_dontemailme.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 07:31:24 -0600

anybody tried this yet?
if you do a select from query analyzer, will you get back encrypted data
or can you install the certificate in query analyzer so you get back
decrypted data?

Mike Epprecht (SQL MVP) wrote:
>
> Hi
>
> SQL Server 2005 will support this at column level using Certificates.
>
> Regards
> Mike
>
> "Jane" wrote:
>
> > Dear All
> >
> > We have a requirement to encrypt data within SQL Server,
> > eg, Bank Account / credit card numbers.
> >
> > I don't believe there is anything in-built within SQL
> > Server 2000, but is there something in-built in 2005 ?
> >
> > Please note I do know about security and SSL but in this
> > case we are trying to encrypt the data in the server
> > itself.
> >
> >
> >

Relevant Pages

  • Re: recovery agent keys/certs
    ... encrypted data otherwise you may be in trouble-- just ... >- After the new recovery agent is in place in group ... >> certificate for a recovery agent. ... >> Choose the 'Automatically Select The Certificate Store ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Cryptography - key signing
    ... This posting is provided "AS IS" with no warranties, ... > I've got two certificates A and B. Both have the public/private key pairs ... > encrypted data. ... >> when you generate a new certificate, ...
    (microsoft.public.security)
  • Re: Cryptography - key signing
    ... I've got two certificates A and B. Both have the public/private key pairs ... encrypted data. ... > sign your public key with their private CA key (or a cross-certified CA ... > when you generate a new certificate, ...
    (microsoft.public.security)