C drive is on the server and no I have not set-up any proxy... Thanks for looking into this guys.

I am getting the error below:

Msg 916, Level 14, State 1, Procedure MyProc, Line 0

The server principal "SuperUser" is not able to access the database "MyDB" under the current security...

I did this too:

EXECUTE SP_CONFIGURE 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXECUTE SP_CONFIGURE 'xp_cmdshell', '1'

RECONFIGURE WITH OVERRIDE

GO

this did not work for me... I creted SuperUser using the query above and granted Execute on xp_cmdshell... still no luck. I recreated the database using "sa" account and added...

Thanks Lowell... somehow I am not included in the users list in the database. I tried to add it but was not able to... I tried using With Execute as...

this is the error I get when I try to refresh the catalog:

Microsoft Distributed Transaction Coordinator (MS DTC) has stopped this transaction.

Do you know what is the minimum privilege required to encrypt data so that I can make sure CF user role has that... Thanks!

I need to grant control on certificate...

Thanks sturner and mkruger I will try that. Thanks!

This is the error we got when using the trigger to encrypt data...

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot find the symmetric key 'TEST_SYMKEY', because it does not exist or...

No it is not using the same logins... so you think it is the permission issue? Thanks!

Calvo I just solved this and yes exactly like you said. Thanks a lot calvo.

Thanks Lowell so much I would like to log error into the table... either I can add that in each Procs or this wrapper proc... I would rather do it...

Thanks KnowItAll I thought about creating in other location, but no one tend to respond in other locations.. I guess less traffic... sorry!

Thanks Kevin... I will try this approach.. looks interesting.

Yes that is what I was trying to do and I think I am trying to do... Probably I should use a table to hold the input parameters and use...