Permissions problem accessing external DLL through reports

Hi,
I'm having this wee problem when trying to view my report via the report
manager screen - I get the following error "Request for the permission of
type System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed"...This seems to be due to me trying to access a seperate DLL which in
turn accesses the database that I created for the reports for translation
purposes (I added the DLL to the References collection for each of the
reports). Any suggestions would be greatly appreciated.I am also tring to use an assembly to translate y i got the same message.
I already try to configure my rssvpolicy.config like:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="XMLFile_MultiLang_Permission"
Name="MultiLangCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\MultLang.dll"/>
</CodeGroup>
but i habe the same error.
Have you found out how to solve it ?
"Rowan Massey" wrote:
> Hi,
> I'm having this wee problem when trying to view my report via the report
> manager screen - I get the following error "Request for the permission of
> type System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
> failed"...This seems to be due to me trying to access a seperate DLL which in
> turn accesses the database that I created for the reports for translation
> purposes (I added the DLL to the References collection for each of the
> reports). Any suggestions would be greatly appreciated.sql

permission denied in accessing SQl 2000

Good day,

Is there anyone could help me, I'm moving our database from old machine to a new one and Iused DTS to move it the new box. Somehow it was moved but I'm still having probelm with my front-end application when I'm trying to open it the error is something like this.

"3704-Operation is not allowed when the object is closed.
an error occurred in Cal_General.CheckDBVSN.Global Error:
-2147217911 -SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
underlying Errors:
Error #-217217911
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
(Source MIcrosoft OLE Provider for SQL Server)
(SQL State: 42000)
(NativeError:229)
No Help file available."

Hope someone could resolve my query.

Thanks,

The databases may have been moved but not the permissions. If you have a security script with the scripted permissions you should execute it on the new server. The error indicates that the objects exists but the connecting user has no permissions querying them.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi Jens,

I already checked the permission of the table and selected those admin rights to make sure that I could be able to use the tabel but still the same proble I get. It is hard for me to work with the SQL co'z my boss assigned my from Sys admin to DB admin I'm really have a hard time to solve the problem.

Vinci

|||OK, having dbadmin rights should be eough in your case to administer the permissions needed. Did you make sure that the user has permissions accessing the following objects:

SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.

if the object are views, make sure that the underlying tables are also accessible to the user (if the ownership chain is broken)

Jens K. Suessmeyer

http://www.sqlserver2005.de

permission denied in accessing SQl 2000

Good day,

Is there anyone could help me, I'm moving our database from old machine to a new one and Iused DTS to move it the new box. Somehow it was moved but I'm still having probelm with my front-end application when I'm trying to open it the error is something like this.

"3704-Operation is not allowed when the object is closed.
an error occurred in Cal_General.CheckDBVSN.Global Error:
-2147217911 -SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
underlying Errors:
Error #-217217911
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
(Source MIcrosoft OLE Provider for SQL Server)
(SQL State: 42000)
(NativeError:229)
No Help file available."

Hope someone could resolve my query.

Thanks,

The databases may have been moved but not the permissions. If you have a security script with the scripted permissions you should execute it on the new server. The error indicates that the objects exists but the connecting user has no permissions querying them.

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

Hi Jens,

I already checked the permission of the table and selected those admin rights to make sure that I could be able to use the tabel but still the same proble I get. It is hard for me to work with the SQL co'z my boss assigned my from Sys admin to DB admin I'm really have a hard time to solve the problem.

Vinci

|||OK, having dbadmin rights should be eough in your case to administer the permissions needed. Did you make sure that the user has permissions accessing the following objects:

SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.

if the object are views, make sure that the underlying tables are also accessible to the user (if the ownership chain is broken)

Jens K. Suessmeyer

http://www.sqlserver2005.de