SQL Server Performance

Data processing extension: Custom dataset

Discussion in 'SQL Server Reporting Services' started by ssp320, Feb 25, 2004.

  1. ssp320 New Member

    I have created a data processing extension to use a custom, external dataset. In my dataReader class, I use SqlConnection, SqlCommand and SqlDataAdapter to create the dataset.(that is I connect to a sql server, then retrive data from many tables then manipulate data into dataset).

    Then I use Report designer to test this extension. It works fine, I can see preview data
    etc.

    However, When I deploy the report to web server, I encounter the following error:
    ---
    An error has occurred during report processing. (rsProcessingAborted) Get Online Help
    Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help
    Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
    ----

    I tried to sign the assembly with strong name, put assembly into global assembly cache, and set up a full trust within internet zone. All these did not work...

    Thank you for your help



  2. satya Moderator

    Ensure the underlying application/user has necessary privilge to access the SQL database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. ssp320 New Member

    How to ensure application/user privilege to access sql server?

    Thanks a lot
  4. satya Moderator

    Check the permission for that user in database by running SP_HELPLOGINS or SP_HELPROTECT which will give you the information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. ssp320 New Member

    At last we solve the problem by enclosing <codegroup> tag in config file.

    Thanks everyone
  6. golum1900 New Member

    quote:Originally posted by ssp320

    At last we solve the problem by enclosing <codegroup> tag in config file.

    Thanks everyone


    I wondered what you entered in your rspreviewpolicy.config and rspolicy.config files were. I have a DPE with the same problem when access a SQL server that is not on the same machine.

    trying to run the following code inside the application

    SqlClientPermission permission = new SqlClientPermission(PermissionState.Unrestricted);
    permission.Assert(); // Assert security permission!

    just throws another execption

    Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
  7. ssp320 New Member

    use code group like before, give full trust
    Thanks
    <CodeGroup
    class="UnionCodeGroup"
    version="1"
    PermissionSetName="FullTrust"
    Name="Dundas_Strong_Name"
    Description="This code group grants Dundas assemblies. ">
    <IMembershipCondition
    class="StrongNameMembershipCondition"
    version="1"
    PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF4447348D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C3AF35FF3DD87578630ED13FE12CBDBC"
    />
    </CodeGroup>
  8. tz478 New Member

    Can somebody tell me how to get the long string for "PublicKeyBlob"?

    My report (uses data precess extension) worked in designer and failed on server (a seperate box). Here is the error message. Similar to the one in this thread:
    An error has occurred during report processing. (rsProcessingAborted) Get Online Help
    Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help
    Exception has been thrown by the target of an invocation.
    Request failed.

    Here is my CodeGroup:
    <CodeGroup class="UnionCodeGroup"
    version="1" PermissionSetName="FullTrust"
    Name="AHC Data Access BO"
    Description="AHC data access business object data processing extension">
    <IMembershipCondition class="UrlMembershipCondition"
    version="1"
    Url="C:program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerinCodeArchitects.BusinessObjectDataSource.dll" />
    </CodeGroup>

    I'd like to try "StrongNameMembershipCondition" for "IMembershipCondition". However, I don't know how to get that long long string for "PublicKeyBlob".

    Thanks for help.

  9. kali_mist New Member

    Folks,
    Did you get this sorted out?
    Im still getting the 'Query execution failed for data set 'DataSet1'' error and I have done everything by the book
    Thanks
    Mick
  10. johnvarenda New Member


    hi...
    Your link worked good..
    Can you explain about TWAIN and OCR.
    THANKS IN ADVANCE.
    ..................
    data entry india
  11. satya Moderator

    Welcome to the forums.
    What is the service pack level on SQL Server?
    Are you trying to execute the queries from other tool such as CRM tools?

Share This Page