locked
Error While Configuring Data-Driven Subscription for sharepoint list as a custom data source-Sharepoint 2010 RRS feed

  • Question

  • Hi All,

              In Reproting Services, Does any one have solution for the below error . I am trying to configure Data- Driven Subscriptions for test.rdl report in sharepoint 2010,

    Please find the configuration details

    My WebApplicaiton using-Claims Authentication,
    WebApplication-http://testnet
    SiteCollection and Report(test.rdl) located at-http://testnet/sites/Tools/PIMProject/Reports
    Report Name -test.rdl
    I just clicked the dropdown menu on the report and choosed  'Manage Subscriptions' option->Add-Data driven subscription 
    Below are the configuration details-
     >Data source - custom data source
    >Data Source Type- Microsoft Sharepoint List
    >Connection Type- -http://testnet/sites/Tools/PIMProject/Reports
    >Credentials-Stored Credentials -I provided username and password(Used as Windows credentials option seleted)
    >Query -<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <ListName>Tracker</ListName>
    </RSSharePointList>

    When clicking the Validate button the below error am getting

    • Cannot create a connection to data source ''. (rsErrorOpeningConnection)
      • The data extension cannot use Windows credentials because SharePoint does not use Windows authentication. (rsSPDataProviderError)
    I tried several accounts(Service account,administrator account)but am NOT lucky.
    -------------
    If i supply the user name with claims syntax like - i:0#.w|hh\test  am getting different error message 

    • Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
      • Logon failure: unknown user name or bad password

    Note: In Central Administration, Reporting configuration -Anuthenication Mode is-Trusted Accountis this setting creating

    any problem?, i am not sure!!!!!!!!!!!!!!!!!!!!!!,Please let me know

    Thanks in Advance.
    Thanks & Regards,
    Mohan

    k.Mohan

    Tuesday, November 20, 2012 8:22 PM

All replies