Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Configuring fetch data...
Dynamics 365 general forum

Configuring fetch data source to point to the correct crm application server

(0) ShareShare
ReportReport
Posted on by allmhuran 30

I'm not a CRM guy. I'm a SQL server / C# / general problem solver guy.

I'm trying to help one of our IT teams migrate to CRM 365. They are having issues with reports.

When I look at the report server log, I see that the relevant error seems to be:

Could not connect to net.tcp://<crmappserver>/CrmSandboxSdkListener-w3wp

We have four CRM application servers. Two of them have the "CRM sandbox listener", and two do not.  I don't know what the sandbox listener is or does, but that probably doesn't matter. What *does* matter is that the <crmappserver> in the URL is one of the two hosts *without* the sandbox listener installed. So, no surprise that it can't connect!

I relayed this information to the CRM team, but nobody in the team knows how to configure the fetch data source to use a particular host. There's nothing in the data connector setup that allows me to enter that information: all I can enter is the SQL Server. So, I deduce that this information must be in the CRM configuration database somewhere, so I suggested that the team look through the administrative side of the CRM web user interface to see what they could find. But apparently the can find nowhere to configure this value.

How can we configure the CRM SSRS Fetch data source to point to <CRM_IIS_HOST_03> instead of <CRM_IIS_HOST_01> when it goes looking for the CRMSandboxSdkListener worker process?

Categories:
  • Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Configuring fetch data source to point to the correct crm application server

    Hi allmhuran

    I am really sorry that my response was not as you expected.

    We as community members (developers, consultants...) are here to learn, help and share the knowledge.

    Sometime the suggestions or answers may not be close to what that actual solution is at all but we as community members try and see if we could help. I am sorry I was not able to help you in this particular instance.

    If any other members in the community have come across similar issue, they would definitely respond to your question.

    If you do not get any other response at all and if you need a solution for this urgently, I would recommend you raise a ticket with Microsoft.

  • allmhuran Profile Picture
    allmhuran 30 on at
    RE: Configuring fetch data source to point to the correct crm application server

    Just so you know, I am reporting your comments as forum abuse.

  • Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Configuring fetch data source to point to the correct crm application server

    Hi

    Sorry I misunderstood your question as you want to change the FETCH Data Source. I read your question again and I can you see you want to change the Fetch Source IP/host name.

    I have not come across any documentation that explains about changing the host, the Reporting Services DB has connection string encrypted for FETCH source

    ScreenClip-_5B00_115_5D00_.png

    You may have to run the Connector/extension setup again.

  • allmhuran Profile Picture
    allmhuran 30 on at
    RE: Configuring fetch data source to point to the correct crm application server

    This has nothing to do with my question.

  • Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: Configuring fetch data source to point to the correct crm application server

    Hi

    Please refer to the link below to see how you can change the data source for a report.

    edwardsdna.com/.../crm-reports-datasource

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans