none
Report Execution error in Form Based Authentication

    Question

  • Hi Friends,

              In Form Based Authentication site when i run my report got this error

    • An error has occurred during report processing. (rsProcessingAborted)
      • Cannot impersonate user for data source 'Progress_Report'. (rsErrorImpersonatingUser)
        • This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)

    1. My report server is configured with SharePonit integrated mode and using with Builder 3.0 i prepared reports and executed successesfully.

    2. and I created new webapplication with FBA, Here in site i added my reports that i have created previously. when i am going run the report got this error

    • An error has occurred during report processing. (rsProcessingAborted)
      • Cannot impersonate user for data source 'Progress_Report'. (rsErrorImpersonatingUser)
        • This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)

    Please anybody solve my issue

    Thanks & Regards

    Ali.


    MD.Liakath ali
    Saturday, February 05, 2011 4:25 AM

All replies

  • Hi Liakath ali,

    Since you are not using windows authentication, datasources configured to use windows authentication will fail. To configure it, please try opening the datasource, click on the credentials tab, then click on 'use this username and password' option and provide the username and password to connect to the datasource.

    Hope this helps. Please feel free to discuss if any.

     

     


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    Saturday, February 05, 2011 4:50 AM
  • Hi,

     

    Check the similar forum below.

     

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/85ce4b0b-0e23-483b-8e1d-388c778f46f8

     

    Answered By Jin Chen

    In SQL Server Reporting Services(SSRS) SharePoint Integration mode, while running a report and the report uses Windows Integrated credential to access the data source, the SharePoint Integrated mode must be configured to use Windows Integrated mode. Otherwise, we will encounter the error as you posted.

    There are two ways to resolve the issue:
            1. Keep the Reporting Services Integration to use Trusted Account mode, and configure the report data source to use Stored Credential.
            2.Configure Reporting Services Integration to use Windows Integrated instead of Trusted Account. Follow these steps to change this setting:
                    a. Open Central Administraton, and then click Application Management.
                    b. Click Manage Integration Settings.
                    c. Set Authentication mode to Windows Integrated. And then configure Kerberos authentication, configure SharePoint to correctly use Kerberos authentication.
                    a. After Kerberos is configured, change the authentication providers on the SharePoint sites in order to be able to successfully use Kerberos.
                    b. Open Central Administration, and then click Application Management.
                    c. Under Application Security, click Authentication Providers.
                    d. Click the zone you want to modify.
                    e. Under IIS Authentication Settings. click Negotiate instead of NTLM.
                    f. Click Save.
                    g. Repeat steps iv-vi for each zone/site you want to change by selecting a different Web application from the drop-down list in the upper right hand corner.

    For more information, please see:
    Reporting Services SharePoint Integration Troubleshooting: http://msdn.microsoft.com/en-us/library/ee384252(SQL.100).aspx
    Enabling SSRS in SharePoint Integrated mode using Kerberos: http://blogs.msdn.com/b/sameersurve/archive/2008/09/12/enabling-ssrs-in-sharepoint-integrated-mode-using-kerberos.aspx

     

     

    Hope it works.

     

    Regards,

    PS

     

     

    Saturday, February 05, 2011 5:03 AM
  • Hi Hani,

    1. Using with FBA added user (ex:Principal) with Full controls. as per your suggestion after opening data source window in report builder  i gave the username and password (tried with system username and pwd and trusted a/c -principal) but it didt work. and also checked as 'User as windows credentials'.

    Can u please explain me

    Thanks &Regards

    Ali


    MD.Liakath ali
    Saturday, February 05, 2011 7:00 AM
  • Hi Pritam,

     Already i dont the above steps what u have said and also the link u provided that query posted by myself only.

    I want to Use “Store credentials” as credentials for connecting to datasource
    To work around this issue need to modify the data source to use stored credentials. but how can do this in report builder 3.0--> credentials--> user name pwd ? or have to run the report under an impersonation account instead of user account.

    So confused ple explain me

    Thanks & Regards

    Ali


    MD.Liakath ali
    Saturday, February 05, 2011 7:39 AM
  • Hi, My suggestion was to use database username and password in datasource credentials so that it does not attempt to use the windows credentials by any means. I am not sure if you tried this. Try connecting to your database with a db user (in case of sql server, a sql database user) and provide that username and password in datasource credentials.

    Regards

     


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    Saturday, February 05, 2011 8:07 AM
  • Hi Liakath,

    Check The Link http://technet.microsoft.com/en-us/library/bb283152.aspx

     

    How to: Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode)

    When you run a report from a SharePoint library, connection information can be defined inside the report or in an external file that is linked to the report. If the connection information is embedded within the report, it is called a custom data source. If the connection information is defined in an external file, it is called a shared data source. The external file can be a report server data source (.rsds) file or an Office Data Connection (.odc) file.

    An .rsds file is similar to an .rds file, but it has a different schema. To create an .rsds file, you can publish an .rds from Report Designer or Model Designer to a SharePoint library (a new .rsds file is created from the original .rds file). Or, you can create a new file in a library on a SharePoint Site.

    After you create or publish a shared data source, you can edit connection properties or delete the file if it is no longer used. Before you delete a shared data source, you should determine whether it is used by reports and report models. You can do this by viewing dependent items that reference the shared data source.

    Although the list of dependent items tells you whether the shared data source is referenced, it does not tell you whether the item is actively used. To determine whether the shared data source or model is actively used, you can review the log files on the report server computer. If you do not have access to the log files or if the files do not contain the information you want, consider moving the report to an inaccessible folder while you determine its actual status.

    To create a shared data source (.rsds) file (SharePoint 2010)

    1.       Click the Documents tab on the library ribbon.

    2.       On the New Document menu, click Report Data Source

    NoteNote

    If you do not see the Report Data Source item on the menu, the report data source content type has not been enabled. For more information, see How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

    3.       In Name, enter a descriptive name for the .rsds file.

    4.       In Data Source Type, select the type of data source from the list. For more information, see Data Sources Supported by Reporting Services (SSRS).

    5.       In Connection String, specify a pointer to the data source and any other settings that are necessary for establishing a connection to the external data source. The type of data source you are using determines the syntax of the connection string. For more information and examples, see Data Connections, Data Sources, and Connection Strings (SSRS).

    6.       In Credentials, specify how the report server obtains credentials to access the external data source. Credentials can be stored, prompted, integrated, or configured for unattended report processing.

    ·         Select Windows authentication (integrated) if you want to access the data using the credentials of the user who opened the report. Do not select this option if the SharePoint site or farm uses forms authentication or connects to the report server through a trusted account. Do not select this option if you want to schedule subscription or data processing for this report. This option works best when Kerberos authentication is enabled for your domain, or when the data source is on the same computer as the report server. If Kerberos authentication is not enabled, Windows credentials can only be passed to one other computer. This means that if the external data source is on another computer, requiring an additional connection, you will get an error instead of the data you expect.

    ·         Select Prompt for credentials if you want the user to enter his or her credentials each time he or she runs the report. Do not select this option if you want to schedule subscription or data processing for this report.

    ·         Select Stored credentials if you want to access the data using a single set of credentials. The credentials are encrypted before they are stored. You can select options that determine how the stored credentials are authenticated. Select Use as Windows credentials if the stored credentials belong to a Windows user account. Select Set execution context to this account if you want to set the execution context on the database server. For SQL Server databases, this option sets the SETUSER function. For more information, see Understanding Execution Context.

    ·         Select Credentials are not required if you want to specify credentials in the connection string, or if you want to run the report using a least-privilege account that is configured on the report server. If this account is not configured on the report server, users will be prompted for credentials and any scheduled operations that you define for the report will not run.

    7.       Select Enable this data source if you want the data source to be active. If the data source is configured but not active, users will see an error message when they attempt to use a report based on the data source.

    8.       Click the Test Connection button to validate the data source configuration.

    NoteNote

    The Test Connection button is not supported for the XML data source type.

    9.       Click OK to save create the shared data source.

    To view dependent items

    1.       Open the library that contains the .rsds file.

    2.       Point to the shared data source.

    3.       Click to display a down arrow, and select View Dependent Items.

    For report models, the list of dependent items shows the reports that were created in Report Builder. For shared data sources, the dependent items list can include both reports and report models.

    To delete a shared data source (.rsds) file

    1.       Open the library that contains the .rsds file.

    2.       Point to the shared data source.

    3.       Click to display a down arrow, and click Delete.

    If you mistakenly delete a shared data source that you meant to keep, you can create a new one that contains the same connection information. After you recreate the shared data source, you must open each report and model that used that data source and select the shared data source. The new shared data source item can have a different name, credentials, or connection string syntax from the one you delete. As long as the connection resolves to the same data source, data source properties can vary from the original values.

    Use caution when deleting a report model. If you delete a model, you can no longer open and modify any reports that are based on that model in Report Builder. If you inadvertently delete a model that is used by existing reports, you must regenerate the model, re-create and save any reports that use the model, and re-specify any model item security that you want to use. You cannot simply regenerate the model and then attach it to an existing report.

    Hope It Helps ..:)

    Regards,

    PS

    Saturday, February 05, 2011 8:12 AM