Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
ERROR : LogonIdentityExWithUI() in SSRS

Proposed ERROR : LogonIdentityExWithUI() in SSRS

  • Friday, August 17, 2012 4:06 AM
     
     
    Sign In to Vote
    0

    Hi all,

    I need to develop a custom report in online crm 2011 30days trial version for one my client demo purpose.

    But in SSRS I am getting this error while connecting to datasource.

    LogonIdentityExWithUI()
    ----------------------------
    An authentication error occurred while connecting to server "https://xxx.crm5.dynamics.com/XRMServices/2011/Discovery.svc". Make sure that the connection string and credentials are correct, and try again.

    How to resolve this issue.

    Please let me know

    Gangadhar


    • Edited by Gangadhar.G Friday, August 17, 2012 4:14 AM
    •  
     

All Replies

  • Friday, August 17, 2012 4:20 AM
     
     
    Sign In to Vote
    0

    Hi,
    What happened when you click "Test Connection" button?

    Do you have sufficient access rights on the server?

    Cheers

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

     
  • Friday, August 17, 2012 4:25 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi There

    Thanks for your posting. Can you please have a look on this that might help you

    http://community.dynamics.com/product/crm/f/117/p/75341/138335.aspx

    Many thanks

    Syed Qazafi Anjum

     
  • Friday, August 17, 2012 4:33 AM
     
     
    Sign In to Vote
    0

     Hi SoheilBakhshi,

    I have created new  organization of online crm 2011 30day trail  throught Office 365.

    But here I couldn't able to connect from SSRS  to that online crm 2011 using live ID and password which is generated from office 365.

    While creating datasource i need to provide Organization URL and Organization name.

    And in the Credential tab, I have the Live ID and password.

    There is no "Test connection" button while using Embedded Connection type as a "Microsoft Dynamics CRM Fetch"

    Gangadhar

     
  • Friday, August 17, 2012 5:57 AM
     
     
    Sign In to Vote
    0

    As you mentioned you are trying to connect to a datasource is SSRS.

    And then you have to select the type of your datasource:

    Unfortunately, I'm not sure what type of datasource you have to select here.

    Hope this helps.

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

     
  • Friday, August 17, 2012 8:01 AM
     
     
    Sign In to Vote
    0

     See here its showing.

    Gangadhar

     
  • Sunday, August 19, 2012 10:10 AM
     
     
    Sign In to Vote
    0

    OK,

    And what happens when you select Microsoft Dynamics CRM Fetch?

    After selecting type from drop-down list and click Edit button on the right, you have to see Test Connection button in connection properties window.

    By clicking on Test Connection, a connection was successful message will show if you connected to the source without problem.

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

     
  • Monday, August 20, 2012 4:22 AM
     
     
    Sign In to Vote
    0

    hi ,

    If I select Embedded type as : Microsoft Dynamics CRM Fectxml then Edit button will be disable.

    And I need to provide CRM Organization Url and Name in the Connection String as show below.

    In credential tab I need to provide windows Live Id and password as show below.

    Gangadhar

     
  • Monday, August 20, 2012 7:20 AM
     
     Proposed
    Sign In to Vote
    0

    According to the thread below it seems you have to modify your Connection String.

    Please follow the instruction below:

    Create a Custom Fetch-based Report

    Creating a custom Fetch-based report is similar to creating a custom SQL-based report except for the data source name and the report query specified while creating the report definition. To create a custom Fetch-based report:

    1. Perform steps 1 through 3 as mentioned earlier in the Create a Custom SQL-based Report section.
    2. On the Select the Data Source page, click New Data Source, and specify the following details:

      • Name: Type a name for the data source.
      • Type: Select Microsoft Dynamics CRM Fetch.
      • Connection String: Specify the connection string. The connection string must be specified in the following format:

        ServerURL;OrganizationName;HomeRealmURL

        In this connection string, only ServerURL is mandatory. If OrganizationName is not specified, the first organization that the user running this query belongs to is used. If HomeRealmURL is not specified, the value is retrieved from the registry value "HKLM\SOFTWARE\Microsoft\MSCRMBidsExtensions\HomeRealmUrl".

        Click Credentials to specify the credentials to connect to Microsoft Dynamics CRM or Microsoft Dynamics CRM Online, and click Next.
    3. On the Design the Query page, type the FetchXML query to retrieve data for the report. You can do one of the following:

      • Manually type the FetchXML query. For more information, see Build Queries with FetchXML.
      • Obtain the FetchXML queries for records by opening Microsoft Dynamics CRM, clicking Advanced Find, and then clicking Download Fetch XML.
      Click Next.
    4. The rest of the steps are the same as mentioned earlier in steps 6 through 9 in the Create a Custom SQL-based Report section.

    Please share the results with us.

    Cheers

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

    • Proposed As Answer by SoheilBakhshi Monday, September 10, 2012 1:36 AM
    •  
     
  • Monday, August 20, 2012 8:33 AM
     
     
    Sign In to Vote
    0

    Hi,

    I followed your steps but after step 2( that means providing Credentials and click NEXT) I am getting this error:

    Unable to connect to data source 'DataSource1'.
    System.ArgumentNullException: Value cannot be null.
    Parameter name: serviceConfiguration.CurrentServiceEndpoint

    Gangadhar

     
  • Monday, August 20, 2012 11:26 AM
     
     
    Sign In to Vote
    0

    Click Credentials to specify the credentials to connect to Microsoft Dynamics CRM or Microsoft Dynamics CRM Online, and click Next.

    Did you fill the credentials completely and correctly before you click next?

    If everything is OK, please create a new simple report and try to connect to CRM in the new report.

    Please share the results.

    Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP


     
  • Tuesday, August 28, 2012 12:03 AM
     
     Proposed
    Sign In to Vote
    1
    I had a call with CRM support this afternoon to solve the same issue. We ended up reinstalling the Report Authoring Extension and Rollup 8. Reinstallation of the Report Authoring Extension also installed or reinstalled the Microsoft Online Services Sign-in Assistant and then I was able to connect to my CRM Online organization using the Office 365 credentials.
    • Proposed As Answer by R TebarMVP 3 hours 37 minutes ago
    •