Report Builder and RDS

[Guest]

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?

[Newsgroup_User]

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.

[Guest]

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?

[Newsgroup_User]

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.

[Newsgroup_User]

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.

[Guest]

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?

[Guest]

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.

[fargond]

swangstw, interesting writeup thank you.

[Guest]

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

[Karzons]

Thanks a lot

[KenPate]

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?

[Guest]

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.

[jepoy1]

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

[Daverms]

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

[jepoy1]

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

[ByronTylor]

Exactly the same problem here

Windows 7 IIS7  Local installation

None of the obvious steps works.