Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Error when running SSRS report-No connection could be made because the target machine actively refused it

Posted on by 380

Hi guys,

Currently, I'm trying to install multiple instances of Reporting Services on one computer following to instruction from this link:

technet.microsoft.com/.../hh389760.aspx

The 1st SSRS instance for 1st AOS is running fine.

For the 2nd SSRS instance:

.Reporting Services configuration files are configured

.Reports are deployed successfully

.The settings for report server is validated

.Both Web Service URL and Report Manager URL are accessible

But , when I run a report from AX, the following error message is shown: "No connection could be made because the target machine actively refused it 192.168.xxx.xxx:8201". The error persists even after restarting SSRS / AOS.

After doing some research, it seems that the connection is refused by the computer. So, I went to my computer's firewall settings to check for ports config.

The strange thing is, the port 8201 is being set for the 1st AOS. And the NetTCP port number of 2nd AOS is 8202.

I think there is something wrong here.....

If you guys faced this problem before and know a workaround for it, please show me.

Thanks in advance.

Categories:
  • Suggested answer
    sivakarthk Profile Picture
    sivakarthk 10 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    hi,

    No Need to Restart, Face this issue when AX cannot complete Inc CIL and closed, User instance will log in online users so we cannot regenerate CIL get error "Another instance of CIL generation is already in progress. Please wait for the operation to complete before retrying."

    To resolve this open online users and terminate all sessions for the same user so that can generate Inc CIL.

    No Need to Restart AOS.

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    hi there,

    for those who still struggle with this issue, make sure following settings are correct:

    1. Report Server (Sysadmin \ setup \ BI \ ReportServer)

    2. Business Connector settings at the Ax Client Configuration. Connection tab, make sure pointing to the correct AOS. Refresh the configuration.

    the error message "... actively refused.." because business connector pointing to the wrong AOS (or to the AOS that is stop).

  • Suggested answer
    Ronny Profile Picture
    Ronny 80 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    i assumed you have aos service more than one,

    i faced the same problem, it is because the SSRS pointing to another AOS, that accidentally I disabled it

    I solved it by started the service on the other aos that connected to SSRS

  • Suggested answer
    Living Color Profile Picture
    Living Color 130 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    I got the same problem.Please help me how to fix it.

    Thanks

  • Living Color Profile Picture
    Living Color 130 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    Hi manikumar !

    I have same problem and i don't know how to fix it. Did you resovled? Could you show me how to fix this problem

    Thank you so much.

  • skaue Profile Picture
    skaue on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    If you have more than one (1) AOS for the same environment, you need to define SSRS settings for both, even if they both point to the same SSRS.

    Just give each entry a unique name and make sure "default" is checked and the AOS-selection at the bottom points to correct AOS. First points to the first AOS, second points to second AOS, and so on.

  • manikumar Profile Picture
    manikumar 1,623 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    Both are same. running reports in new aos when other aos is running only. if i stop old one, new one is throwing error

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    If you are installed multiple AOS, make sure in client configuration -> Business connector -> TCP IP is same as Current AOS TCP IP

  • skaue Profile Picture
    skaue on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

    Just make sure you have at least one default SSRS configuration defined inside AX for each AOS you've setup in that specific environment. So if PROD has 3 AOSes, you will need to define one SSRS Default configuration for each of the 3 AOSes, making sure each one of them point to each specific AOS.

  • manikumar Profile Picture
    manikumar 1,623 on at
    RE: AX2012 R2-Error when running SSRS report-No connection could be made because the target machine actively refused it

     Im also facing same problem. at present we are having SSRS,DB,AOS in same server. I installed AOS in New server with db in present server. but I stuck at reports. reports are working in new server when old aos service is running, if I stop the service and run reports in new server getting following error.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans