Re: SQL-Server and Content encryption

From: Andrew J. Kelly (ajkellynospam@attbi.com)
Date: 04/23/03 

From: "Andrew J. Kelly" <ajkellynospam@attbi.com>
Date: Wed, 23 Apr 2003 09:52:25 -0400

SQL Server does not have any encryption features built in like that. If you
really don't want anyone (even sa) to be able to decrypt it then you must do
the encryption and decryption in the application. Then sql server is just a
data store as it is intended and unless someone else has this decryption
scheme they won't be able to interpret the data even if they can read it. 

-- 
Andrew J. Kelly
SQL Server MVP
"Reiner" <Reiner.proels@laposte.net> wrote in message
news:02b301c3099b$f4f9ac50$2f01280a@phx.gbl...
> Hello,
>
> is there any possibility to hide the datas stored in the
> database even for an administrator (encryption). So only a
> special application with a build in password / key can
> read the data stored in the SQL-Server database?
>
> Thanks
>
> Reiner

Relevant Pages

  • Re: CREATE SYMMETRIC KEY
    ... AES is only supported by SQL Server on Windows 2003. ... To test it out using encryption, I created a database, TestEncrypt, ... CREATE SYMMETRIC KEY SSN_Key_01 ... DECRYPTION BY CERTIFICATE HumanResources037; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL-Server and Content encryption
    ... SQL Server 2000 didn't directly tackle the content encryption problem. ... "Andrew J. Kelly" wrote in message ... >>> the encryption and decryption in the application. ...
    (microsoft.public.sqlserver.security)
  • Re: Example code Help!
    ... Dan has planted a bomb in my heart, ... >between SQL Server versions/service packs and break your ... >> I am searching for example codes for encryption and ... >> decryption of a value for a column in SQL Server 2000. ...
    (microsoft.public.sqlserver.server)
  • Re: Searching on Encrypted Fields
    ... The encryption is handled by the software ... every single social security number and comparing it with what the user ... decryption is easier to perform. ... SQL Server 2000 that is fixed in 2005? ...
    (microsoft.public.dotnet.security)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)