I have two separate data sources with the same import definition who
will each encrypt their data using PGP. This data will then need to be
imported into a SQL Server 2005 database with particular fields
encrypted. After some data processing some information will need to be
returned encrypted.
Is this possible with SQL 2005?
If it is what functions/code would be useful to review for usage of
encryption in SQL?
RE: local admin account password ... > encrypt the database and create alerts in the event of unsuccessful ... >> no more recovery console and don't think cached logins will work. ... >> The DB file would be encrypted with EFS so only the limited user SQL... >> itself doesn't really need to be secure as the authentication is based ... (Focus-Microsoft)
Re: SQL Server 2000 / 2005 Encryption ... encrypting the connection makes sense to me. ... 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. ... to encrypt your SSL connections will be different. ... Excel does not know how to decrypt data stored in SQL Server 2005 in encrypted form. ... (microsoft.public.sqlserver.security)
Re: SQL Server Encrypt, Failure.. ... This function doesn't encrypt at ... (Not that I had too high of expectations for a undocumented SQL...Declare @Password2 nvarchar ... > Bill Dodd... (microsoft.public.sqlserver.server)
Re: Web.config encryption in shared hosting scenario ... I just begin to search for a solution because the customer does not allow ... like to encrypt the database connection string located in the web.config. ... I am connecting to the SQL... (microsoft.public.dotnet.framework.aspnet.security)
Re: Encrypting data in existin application ... You're dealing with a very tough problem...even if you did encrypt the data, ... Are they going to be in the SQL database somewhere ... This is especiall with regards to int and decimal ... (microsoft.public.sqlserver.security)
