SQL Reporting Services Spamming Loopback port 80 IPv6 to sqlserver.exe

JamesEdmondsUKPN 5 Reputation points
2023-10-29T23:52:00.8733333+00:00

Hi,

One of our report servers has just started falling over repeatedly with the sqlserver service failing and restarting multiple times.

This looks to be because of ephemeral port exhaustion, that seems to be caused by floods of TCPIP connections on port 80 from the server to itself on the loopback address (reporting services and SQL DB are on the same box).

We have proven if we stop reporting services, the connections stop, and if we start reporting services, they start again.

Can anyone advise why reporting services is suddenly spamming the loopback adapter with these HTTP requests?

Thanks

James

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,635 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,642 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 8,605 Reputation points
    2023-10-30T02:34:52.89+00:00

    Enable detailed logging for SSRS. Check the SSRS log files to identify which reports or actions are generating these requests.