Help needed !



I would appreciate if any one can help me out regarding the following
situation.



I created one database that has sensitive information in it so that I have
implemented Symmetric AES_128 Algorithm implemented and changed all the
stored procedure to first open the Symmetric Key and use the Decrypt
function is select stored procedure and close the Symmetric key at the end
of the stored procedure and same as for Insert and update stored procedure I
used open key at the first line and use encrypt function to encrypt the data
and close the key at the end of stored procedure. Now some how my manager
told me to me to move this database into different Server, I restore the
same database into different server and when I point the application to that
new server database it doesn't work and its not properly encrypted and
decrypted the data, Should I have to do anything after I restore the
database into another server so that I decrypt the data? I would highly
appreciate if any one can help me out, the problem is a sensitive data and
it's not decrypting.



Thanks in advance.


.

Relevant Pages

  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)
  • Re: connecting to two adp projects error-
    ... We have an ADP which is linked to one database but which has to ... make a call on startup to a second database for extended user ... Your point of handling action on the server is taken. ... T-SQL code in your stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Design question
    ... username and password on the App Server and Database server and synchronize ... recommend using the stored procedure for security and performance reasons. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... with the caveat that you don't recommend it because Microsoft ... of a stored procedure versus umpteen of the same stored procedure spread ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ...
    (microsoft.public.sqlserver.odbc)
Loading