Reading Encrypted Data from Another Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Reading Encrypted Data from Another Database...

Reading Encrypted Data from Another Database

Rate Topic

Display Mode

Topic Options

Author

Message

daveFromIll

Posted Tuesday, March 16, 2010 12:01 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 8:31 AM
Points: 16, Visits: 113

I am a greenhorn in the ways of encryption. I have need to encrypt a column in a table on database1 and have it be able to be decrypted and read on database2. I have managed to set up the MASTER KEY, CERTIFICATE and SYMMETRIC KEY on database1 and the encryption seems to query just fine ON the database. Unfortunately, I need to be able to read this encrypted column from another database on the same server. Would someone be so kind as to tell me how I go about achieving this decryption. All help would be greatly appreciated.

Thanks!
Dave

Post #884060

« Prev Topic | Next Topic »

Permissions