Re: Data encryption for results of query using ADO

From: Simo Sentissi (simo_at_sentissiweb.com)
Date: 11/08/04


Date: Mon, 08 Nov 2004 15:30:59 -0700

i read somewhere that there is a way to encrypt and xml output from sql
server. so maybe spit the output in xml and apply an ecryption to it ?
maybe use a DTS to call outside lybrary?

Alwyn Pereira wrote:
> Hi,
>
> I'm using ADO to connect to a SQL Server.
> I want to execute a query which reads sensistive information and ensure that
> the results of the query cannot be sniffed on the network
> Can I enable encryption for a specific connection to the SQL Server without
> forcing either the client machine or sql server to enable
> full fledged encryption. I have only one query which returns sensitive
> information, hence I do not wish to enable encryption for the all sql server
> connections/
> using certificates via 'Force Protocol Encryption'
>
> Thanks,
> Alwyn
>
>



Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... might not have Encryption support, but it shouldn't be trying to use SQL ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: SSL Sicherheitsfehler
    ... SQL Server 2005 german evaluation enterprise installiert ... Die Encryption war die ganze Zeit aus.Dann kam der SSL Fehler. ... SQL Server herstellen. ... TURN ON SSL encryption on the SQL ...
    (microsoft.public.de.sqlserver)
  • Re: Utility
    ... I think you are referring to the ability to encrypt source code. ... the encryption method isn't very ... There are third party tools that claim to help secure your SQL Server ...
    (microsoft.public.sqlserver.server)
  • Force Protocol Encryption - Please help!
    ... I just recently set up a SQL 2000 server and have a question about ... so I enabled the Force Protocol Encryption ... After installing the cert, I was once again able to start my SQL ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)