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=Re nder&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 :

String url = "http://IpAddressOfServer/ReportServer/ReportService2005.asmx";
ReportingService2005Soap port = null;
          ReportingService2005Locator loc = new ReportingService2005Locator();
        // Retrieve a port from the service locator
        try {
            port = loc.getReportingService2005Soap(new java.net.URL(url));
        } catch (MalformedURLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (ServiceException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        org.apache.axis.client.Stub stub = (org.apache.axis.client.Stub) port;
        stub.setUsername("IpAddressOfServer\\USERNAME");
        stub.setPassword("PASSWORD");

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.

SO please anybody has any idea, advise me.
I have done a lot search on this but no success.
This forum is like my last hope.

Regards.

Any senior member if can help me i will be thankful to him.

Is there no one who can help me?

It's very hard to debug permissions and security issues from afar. If you type in the username and password does it work? If so you need either to relax permissions on the server or tell your browser to pass the current users credentials to the server (not a very secure method). You can do this in IE in the security section of the relevant zone, it's the last setting in the list. If you can never access the reports, even after supplying username then you need to modify permissions in Reporting Services.

--

Joe (Microsoft MVP - XML)

Thanks a lot joefawcett,

After all i get something.
Yes i can access the report when i enter the correct user name and password in that prompt. It works in this case.
So you want to say in this case i should change the server security configuration so that it should not ask the username and password.
Its mean i can not do it through coding?

Regards.

Well you can either alter browser's settings, as I wrote previously, so that the username/password are passed automatically or you can lower security settings on the server so that anonymous users are allowed, then everyone would be able to run all reports. You can't have Windows security with no way of passing the user's credentials.

--

Joe (Microsoft MVP - XML)