SSRS Query Designer times out

Question

Post reply

SSRS Query Designer times out

webrunner

SSC-Dedicated

Points: 31882
More actions
June 30, 2021 at 7:40 pm

#3902210
Hello experts,
I am getting the following error when trying to open the Query Designer for the a report Dataset in Report Builder.
The report runs successfully in the browser and in Report Builder. And the data sources for the report validate successfully.
I also checked for TLS issues, but the report server is correctly using TLS 1.2 as required by our shop. The Current report server listed at the bottom of the Report Builder design window appears to be correct as well.
The only other things I can think of (but don't know how to fix) are:
- The report server uses https, is the Query Designer not properly connecting on https/port 443?
- We have a secondary URL with a different name to accommodate another web site name the clients wanted. It is the name of the old server from which we upgraded. Is Report Builder somehow trying to connect the now decommissioned server that used that URL?
- Does Report Builder need port 80 to allow Query Designer to open?
- Is something on the SQL Server side blocking the connection?
```
The wait operation timed out
----------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. 
The server was not found or was not accessible. Verify that the instance name is correct and that SQL 
Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)
```
Thanks for any help.
-- webrunner
- This topic was modified 3 years, 5 months ago by webrunner.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 4, 2022 at 1:05 pm

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80325 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

webrunner SSC-Dedicated Points: 31882 More actions · Answer 2

Seems like this is a firewall issue, just FYI. Although the Report Server web site connects from the report server, Report Builder needs its own access from whichever computer it is launched on. Makes sense now that I think about it.

Thanks.

This reply was modified 3 years, 5 months ago by webrunner.

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html