wood burning stoves*
The moose likes Web Services and the fly likes URL Access to SSRS is asking for authentication Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "URL Access to SSRS is asking for authentication " Watch "URL Access to SSRS is asking for authentication " New topic
Author

URL Access to SSRS is asking for authentication

Khushwinder Chahal
Ranch Hand

Joined: Oct 03, 2007
Posts: 128
Hi All

I am trying to connect to my report server through URL access and then trying to retrieve some values from my SSRS from my local machine like :

<a href="http://IPAddressOfServer/ReportServer/Reports/?%2fDashboardReports%2fHorse_Profile&rs:Command=Render&HorseID=117415"><%=name%> </a>


But when i click on this hyperlink it asks for the username and password for that server.
However , i am using the following code to connect to my server :



It is getting connected without any problem and i am retrieving values also from my SSRS in my servlet.

But the problem comes when i want to click on some hyperlink and it should go to the report server and generate the corressponding report.
But it is asking for the username and password which is not required.
If there will be some security issue it must not be get connected with the server through the code i am using.
I have tried to connect with wrong password but it gives unauthorized exception.
I also tried with domain name in spite of IP but same err.
SO please anybody has any idea, advise me.
I have done a lot search on this but no success.


Regards.


Khushwinder
Khushwinder Chahal
Ranch Hand

Joined: Oct 03, 2007
Posts: 128
Any senior member if can help me i will be thankful to him.
Peer Reynders
Bartender

Joined: Aug 19, 2005
Posts: 2922
    
    5
Originally posted by Khushwinder Chahal:
It is getting connected without any problem and i am retrieving values also from my SSRS in my servlet.
...
If there will be some security issue it must not be get connected with the server through the code i am using.


Your code is specifying a username and password right at the end with stub.setUsername and stub.setPassword.



So the endpoint at ReportServer/ReportService2005.asmx and the reports under ReportServer/Reports/ seem to require a username and password which suggests that all of ReportServer is controlled by the same access control rules.

Theoretically it is possible to specify a username and password in the URL like:

http(s)://username:password@server/resource.ext

However Microsoft Explorer 7 will no longer support that format.

The "proper" approach would be to specify weaker access requirements for ReportServer/Reports/ on the Server.

A firewall proxy could also require a username and password (which then would be a configuration issue with the browser). However that doesn't seem to be the case as there is no equivalent in the Axis code:

[ February 27, 2008: Message edited by: Peer Reynders ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: URL Access to SSRS is asking for authentication