sql server reporting services: We have written one custom assembly, which queries database and returns a
flag yes or no. When we run report in designer environment it is behaving
fine, expression of the text box, where we are calling that method gives
yes/no fine. But when we deploy it to staging server we get #Error as output
in the text box expression. We have set all kinds of permissions given under
http://support.microsoft.com/?kbid=842419. Need Help.

You said you have set code access security permissions in the config files.
However, did you also assert the SqlClientPermission in your custom assembly
function before it opens the database connection?
E.g.:
SqlClientPermission permission = new
SqlClientPermission(PermissionState.Unrestricted);
try
{
permission.Assert(); // Assert security permission!
SqlConnection con = new SqlConnection("...");
con.Open();
...
}


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]