<div>
If you want to get it back for a report, you need encryption, not a hash. &nbsp;Hash is by definition a one-way process.<br />
<br />
In addition, it may be illegal to transmit them in the clear so the question becomes how will you encrypt the reports that are developed over the internet?
</div>


If you want to get it back for a report, you need encryption, not a hash.  Hash is by definition a one-way process.

In addition, it may be illegal to transmit them in the clear so the question becomes how will you encrypt the reports that are developed over the internet?

<div>
I was considering VPN over SSL.<br />
<br />
Do you have any input on how to perform encryption?<br />
Thanks.
</div>


I was considering VPN over SSL.

Do you have any input on how to perform encryption?
Thanks.

<div>
<div class="content wysiwyg-content">
Greetings,<br />
I'm being asked to create a web-faced database storing PII and Privacy Act 1974 (same coverage?) information such as Social Security Numbers (SSN's).<br />
<br />
I firmly believe (as with everyone else) that SSN's should not be stored in the clear. &nbsp;They should be stored using Hash-246 or better. &nbsp;I am more than open to wisdom on this method.<br />
<br />
But my real question is output. &nbsp;If my client wants to derive a report based on said individual, and needs the SSN to show up on the report, how do I get it back out of Hash and send it to the report?<br />
<br />
thanks.
</div>
</div>


Greetings,
I'm being asked to create a web-faced database storing PII and Privacy Act 1974 (same coverage?) information such as Social Security Numbers (SSN's).

I firmly believe (as with everyone else) that SSN's should not be stored in the clear.  They should be stored using Hash-246 or better.  I am more than open to wisdom on this method.

But my real question is output.  If my client wants to derive a report based on said individual, and needs the SSN to show up on the report, how do I get it back out of Hash and send it to the report?

thanks.

Storing Social Security Numbers

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Encryption is the process of encoding messages or information in such a way that only authorized parties can read it. In an encryption scheme, the intended communication information or message, referred to as plaintext, is encrypted using an encryption algorithm, generating ciphertext that can only be read if decrypted. For technical reasons, an encryption scheme usually uses a pseudo-random encryption key generated by an algorithm. An authorized recipient can easily decrypt the message with the key provided by the originator to recipients, but not to unauthorized interceptors.

Encryption

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.