Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Posted on by 350

I am trying to launch a report at the user level and I get this error when it lasts more than 10 minutes, but in Visual Studio the same report is complete and I don't know how to correct it 

pastedimage1657742298807v1.png

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    Hi Luis,

    You can try to find your answer in the Microsoft documentation: Tips to help prevent long-running reports from timing out | Microsoft Docs

  • Luis Pascual Profile Picture
    Luis Pascual 350 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    ?

  • Luis Pascual Profile Picture
    Luis Pascual 350 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    these are all the changes I made:

    pastedimage1659618083154v1.png 

    pastedimage1659618186499v2.png

    pastedimage1659618471100v3.png  

    pastedimage1659618595765v4.png

    I currently have it configured like this

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    "is there another way to resolve this error because it doesn't work for me?" Can you explain this reply? Did you already try to change the time-out settings? If so, please tell us what exact setting got changed.

  • Luis Pascual Profile Picture
    Luis Pascual 350 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    it is not feasible for users of the company where I work because they use reports with a period of one full year

  • Luis Pascual Profile Picture
    Luis Pascual 350 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    is there another way to resolve this error because it doesn't work for me?

  • Komi Siabi Profile Picture
    Komi Siabi 12,692 Most Valuable Professional on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    Just as André said, you can try to update the session time out here

    docs.microsoft.com/.../how-to-addressing-ssrs-session-timeouts

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    Hi Luis,

    There are some timeout settings for SSRS which can be changed. The user can also try to set a filter to limit the number of records on the report, so it will run within the 10 minutes which is the default time-out setting.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans