Adobe Community: Report Builder and RDS

Currently Being Moderated

1. Newsgroup_User,

Sep 9, 2008 8:31 AM in reply to Russ

Report

Russ wrote:
> I just installed CF 8.1 Report Builder and attempted to use it for the first time.
>
> Is it required to have RDS activated on the server in order to use report Builder?

I do not think it is *required* but I believe report builder will
definitely be limited by not having access to RDS to provide graphical
integration with database objects.

|

Mark as:

Currently Being Moderated

2. Russ,

Sep 9, 2008 9:13 AM in reply to Russ

Report

OK, that makes sense except that I know that using RDS in prior releases of CF gave programmersfull access to server drives and folders, a risky situation.

Anyway I activated RDS on a test server with CF8.1, installed Report Builder on my PC and the software wants to configure an RDS server. I enter everything that is required including the RDS password and when I test the connection I get "The following error occurred while trying to connect to the RDS server: http/1.1 404 not found".

any thoughts?

|

Mark as:

Currently Being Moderated

3. Newsgroup_User,

Sep 9, 2008 9:23 AM in reply to Russ

Report

http/1.1 404 not found

Is that an exact copy from the error message?

If so, then something is wrong somewhere in your configuration, since
http:/1.1 is never going to resolve to a http connection. It is not a
complete IP address.

I would expect to see something like:
http://127.0.0.1
OR
http://localhost
OR
Whatever is required to connect to the ColdFusion server to which you
are trying to connect.

|

Mark as:

Currently Being Moderated

4. Newsgroup_User,

Sep 9, 2008 9:27 AM in reply to Russ

Report

Russ wrote:
> OK, that makes sense except that I know that using RDS in prior releases of CF
> gave programmers full access to server drives and folders, a risky situation.

P.S.
Yes RDS does give programmers a great deal of access to a server and it
is a risky situation. That is why all the documentation says to *NOT*
allow RDS on production servers, only development servers. And to take
whatever other precautions you deem necessary to restrict the access to
even the development server to only those who should have access.

|

Mark as:

Currently Being Moderated

5. Russ,

Sep 9, 2008 9:52 AM in reply to Russ

Report

good point on not allowing RDS for production servers.

anyway, on the "http/1.1 404 not found" error, yes that was an exact copy of the error message. Based on your comment I went back and looked that the configuration.

The 'description' of the configuration can be anything (I assume).
for the Host Name, I did have just the name of the server, what was DTSC-HWTSX. Port is set to 80, no Context Root, no SSL, no Username, and the password was set to what I had set with the CF Administrator.
I changed the Host name to
http://DTSC-HWTSX and now I get the error message of "A connection to the RDS Server could not be established because the webserver was unreachable". That host address is good (Intranet only), and I did verify that I could get to it with a browser..

Thanks for your assistance and thoughts. Any other ideas?

|

Mark as:

Currently Being Moderated

6. swangstw,

Sep 24, 2008 8:10 PM in reply to Russ

Report

i got the same situation.

i installed CF 8 and report builder on an intranet-connected machine and the RDS service worked just fine with the host name set to "localhost", then i installed another report builder on my own machine tried to connect to the previous machine ,after i typed in all the information required by the configuration and clicked test connection ,i got the message "A connection to the RDS server could not established because the web server was unreachable." the host name is set to the ip address of that server and it just could not work.

|

Mark as:

Currently Being Moderated

7. fargond,

Oct 9, 2008 4:33 AM in reply to Russ

Report

swangstw, interesting writeup thank you.

|

Mark as:

Currently Being Moderated

8. Disaster Man,

Oct 9, 2008 8:20 AM in reply to Russ

Report

Another thought: this can also happen if RDS is disabled. Check that *both* RDS sections of the web.xml are uncommented.

see
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17276

|

Mark as:

Currently Being Moderated

9. Karzons,

Oct 18, 2008 6:35 AM in reply to Russ

Report

Thanks a lot

|

Mark as:

Currently Being Moderated

10. KenPate,

Oct 27, 2008 1:03 PM in reply to Russ

Report

I have a local install of CF 8 developer edition and have the same problem with report builder and RDS. I've checked the web.xml file and its correct. Any other ideas?

|

Mark as:

Currently Being Moderated

11. Russ,

Oct 27, 2008 1:26 PM in reply to KenPate

Report

in response to my "http/1.1 404 not found" error I initially posted.

I felt like a dummy when I found the solution: I was trying to connect to the wrong server. Specified the correct server (with RDS activated) and everything worked fine.

|

Mark as:

Currently Being Moderated

12. jepoy1,

Nov 10, 2009 12:06 AM in reply to Russ

Report

i have the same problem...how connect the rds directly to my datasource..same error also...anyone who can help?

|

Mark as:

Currently Being Moderated

13. Daverms,

Nov 10, 2009 12:48 AM in reply to jepoy1

Report

It can be solved either through,

Installing ColdFusion using the integrated web server (port 8500).

By turning off IIS Integrated Authentication on the CFIDE directory (use the admin password to secure it instead).

HTH

|

Mark as:

Currently Being Moderated

14. jepoy1,

Nov 10, 2009 12:57 AM in reply to Daverms

Report

I have tried it and it doesn't work for me..I also restart the services of IIS and Coldfusion.

Anyway..thanks for the help. Hope that anyone can help me.

thanks

|

Mark as:

Currently Being Moderated

15. ByronTylor,

Mar 15, 2010 2:06 PM in reply to Russ

Report

Exactly the same problem here

Windows 7 IIS7 Local installation

None of the obvious steps works.

|

Mark as:

Reporting

Report Builder and RDS

Sep 9, 2008 8:22 AM

More Like This

Bookmarked By (0)

Answers + Points = Status