Re: SQL Server 2000 / 2005 Encryption


"Rubens" <rubensrose@xxxxxxxxxxx> wrote in message
news:CA7939A8-A98C-4202-9CC2-8D7052735B8E@xxxxxxxxxxxxxxxx
Excellent, thank-you Mike! This definitely points me in the right
direction. Let me take a step back and explain what I am trying to
accomplish and see if this makes sense. We will initially be doing this
on a SQL 2000 machine.

We have data in a table that needs to be encrypted. Ultimately, this
information needs to end up on a Tablet PC in Excel for users that have
permission. So here is how I think we can accomplish this.

After I go through the steps you listed below, we need to distribute the
certificate to the Tablet PC's and install it.
Once it is on the Tablet, does Excel just know to use this certificate
because the information in the data dump / pivot table needs to be
decrypted?
Is the same certificate used to secure the connection as well as
decrypting the data in the table?

Does this make sense?


We need to separate these two issues you're talking about here:

1) You're talking about encrypting the connection to SQL Server, which is
possible on SQL 2000 and SQL 2005 through SSL.

2) You're also talking about encrypting the data stored "at rest" in the
database. This is possible on SQL 2005 via built-in T-SQL statements and
functions, but requires 3rd-party tools, usually some sort of extended
procedures (XPs).

The certificates used to encrypt your data stored on SQL Server 2005 and to
encrypt your SSL connections will be different. SQL Server can generate its
own self-signed certificates though, and that should make the SSL
encryption/connectivity easier for you. Excel does not know how to decrypt
data stored in SQL Server 2005 in encrypted form.


.

Relevant Pages

  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver.clustering)
  • HOWTO: SQL Server SSL On A Cluster
    ... This post describes issues concerning the implementation of SSL ... certificates on SQL Server 2000 clusters. ... cluster and failover is working, ... DC is running a certificate authority, and that the CA is configured ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... SQL Server Database Services 2005 ENU SP2 ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... Clearing the certificate had no success. ... I suspect there's a problem with the permissions of the SQL Server service ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 SP2 fails in upgrading Database service
    ... When I clear the Certificate in the registry, I get the error that he is ... What you need to do to allow SQL Server to start successfully is to check ... This is an informational message only; no user action is ...
    (microsoft.public.sqlserver.setup)