Hi,

Recently I have faced the Encryption & Decryption issue in SSRS , even I have not set any kind of properties , the easy solution I found on the net...

Are u getting the decrypted output printed in normal print statment , i.e. not passing any o/p param

DECLARE @EncryptedVal varbinary (256),@DecryptedVal varbinary(256)

SET @EncryptedVal = CAST('0x0000ADCED7A3754290C6305321AD49D801000000C30B447DDF84FAA5C05F832EC0DA82EC9C7704F85B86961DE18477118B6198A5179ED1424E1FC4E32B204EFC35884018' as varbinary(256))

SET @DecryptedVal =...

Are there any sql jobs scheduled at 6:00 p.m. which are hindering your access to the database.

Check the following link if it helps

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/c40f68c1-184a-4bc7-94aa-c43be128ff47

Hi Mohit,

Regarding the latest Job status query you have posted, i have tried that but it doesn't gave me the expected result.

Here is what i have done , i...