Report Builder 3.0: Unable to connect to the server that is specified in the URL

Question

Report Builder 3.0: Unable to connect to the server that is specified in the URL

bob-596435

SSC-Addicted

Points: 427
More actions
March 15, 2018 at 11:22 am

#336566

I'm getting the following error when attempting to connect to Report Builder 3.0 on a SQL 2014 Report Builder install. This is installed on my local development workstation.
I can get to the Report Manager through the URL identified in SSRS Configuration manager. I was able to create folders, setup new DB connections, etc. I have also given my local login DEVOX\bob a System Administrator role on the report server.
I have tried starting Report Builder 3.0 both as an Administrator and using my own login (i.e. normal launch) and in both cases I get the error shown above.
This is a fresh install on a computer that crashed and had to be rebuilt. I remember having similar issues a few years ago when this workstation was originally setup, but I can't remember the resolution at that time. However, each time I do a new install of SSRS I find it frustrating and difficult to navigate. I need to be able to access this local server to test and debug reports that are currently in production.
Any help would be greatly appreciated.
Thanks!
Bob

Viewing 8 posts - 1 through 7 (of 7 total)

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

bob-596435 - Thursday, March 15, 2018 11:22 AM
I'm getting the following error when attempting to connect to Report Builder 3.0 on a SQL 2014 Report Builder install. This is installed on my local development workstation.
I can get to the Report Manager through the URL identified in SSRS Configuration manager. I was able to create folders, setup new DB connections, etc. I have also given my local login DEVOX\bob a System Administrator role on the report server.
I have tried starting Report Builder 3.0 both as an Administrator and using my own login (i.e. normal launch) and in both cases I get the error shown above.
This is a fresh install on a computer that crashed and had to be rebuilt. I remember having similar issues a few years ago when this workstation was originally setup, but I can't remember the resolution at that time. However, each time I do a new install of SSRS I find it frustrating and difficult to navigate. I need to be able to access this local server to test and debug reports that are currently in production.
Any help would be greatly appreciated.
Thanks!
Bob

Use the Web Service URL instead of the Report Manager URL - point to ReportServer not Reports
http://<servername>/reportserver

Sue

bob-596435 SSC-Addicted Points: 427 More actions · Answer 2

I get the same error even with the URL that you suggested.

Sue_H SSC Guru Points: 90860 More actions · Answer 3

bob-596435 - Thursday, March 15, 2018 2:06 PM
I get the same error even with the URL that you suggested.

Did you check the URL for the web service in Report Services Configuration Manager? I provided an example - the point was reportserver instead of reports.

Sue

bob-596435 SSC-Addicted Points: 427 More actions · Answer 4

That was it!!

I didn't notice that the URL had _DEVBOX appended to the end. I'll have to remember that.

Thanks for the help!!

Sue_H SSC Guru Points: 90860 More actions · Answer 5

bob-596435 - Thursday, March 15, 2018 3:31 PM
That was it!!
I didn't notice that the URL had _DEVBOX appended to the end. I'll have to remember that.
Thanks for the help!!

Your quite welcome - glad you got it working! And thanks for posting back an update.

Sue

Matt_b Newbie Points: 5 More actions · Answer 6

Hi everybody,

Thank you for your posts. Sue's suggestions seem to solve everyone's problem here but unfortunately didn't help me much. I'm trying to use Report Builder 3.0 web services on SQL Server 2008 R2. Builder cannot connect and I receive the same error message as above. I used both web service URL and report manager URL (just in case) but neither worked. I also tried both URLs with and without adding port number (:80) and the ending forward slash (/). None has worked so far. I really appreciate any help. One last point to add: Initially I downloaded an older version of Report Builder which connects to the web services with no problem. Should I uninstall that in order to make Report Builder 3.0 work?

Thanks
Matt

Sue_H SSC Guru Points: 90860 More actions · Answer 7

Matt_b - Sunday, February 24, 2019 10:56 PM
Hi everybody,
Thank you for your posts. Sue's suggestions seem to solve everyone's problem here but unfortunately didn't help me much. I'm trying to use Report Builder 3.0 web services on SQL Server 2008 R2. Builder cannot connect and I receive the same error message as above. I used both web service URL and report manager URL (just in case) but neither worked. I also tried both URLs with and without adding port number (:80) and the ending forward slash (/). None has worked so far. I really appreciate any help. One last point to add: Initially I downloaded an older version of Report Builder which connects to the web services with no problem. Should I uninstall that in order to make Report Builder 3.0 work?
Thanks
Matt

As bad as it sounds, there are different versions of Report Builder 3.0. Use the version that works with the version of SQL Server you are on. They won't all work across different versions due to the changes in the different versions. This is the Report Builder 3.0 to use with SQL Server 2008 R2:
Microsoft SQL Server 2008 R2 Report Builder 3.0

Sue