Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 27th, 2008, 01:43 AM
Registered User
 
Join Date: Feb 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Khushwinder
Default URL Access to SSRS is asking for authentication


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.

 
Old February 27th, 2008, 05:04 AM
Registered User
 
Join Date: Feb 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Khushwinder
Default

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

 
Old February 28th, 2008, 02:46 AM
Registered User
 
Join Date: Feb 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Khushwinder
Default

Is there no one who can help me?

 
Old February 28th, 2008, 12:27 PM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

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)
 
Old February 29th, 2008, 01:36 AM
Registered User
 
Join Date: Feb 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Khushwinder
Default

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.




 
Old February 29th, 2008, 05:08 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

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)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 1 : Authentication for Manager access AC Evergreen BOOK: Beginning JavaServer Pages 2 February 2nd, 2009 10:20 PM
How to use only 1 url for user to access? calyn_gately ASP.NET 3.5 Basics 4 August 12th, 2008 04:41 PM
how can i access my url outside my server? priyaram SQL Server 2005 12 February 14th, 2007 12:20 PM
Access db connection with forms authentication ChronoSys ASP.NET 1.0 and 1.1 Basics 0 May 12th, 2006 09:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.