Michael,

I appreciate the DBA Toolkit, and it has been very helpful. I continue to have trouble with the encryption and desperately need help.

I need to be able to to set up another server for failover. I have compiled the code for CertMgr (posted earlier) (that uses the machine key). I used this to Export the scrypto params. Then on the failover server I do an import of the same scrypto.params file. I also have a SQL script with the data from the Local_key and Master_Key tables. so the data in these tables on both servers are the same.

My test is to use the decrypt_AES function to see the value in the encrypted column. On the failover server I am getting NULL back.

I also have problems getting data back from ASP.NET using a ADO.NET SQLClient call to a stored procedure. The values in the column is null. Calling the same stored procedure through ASP - ODBC works.

Is the source code for the sprocs available?

Thank-you