Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 27th, 2008, 01:43 AM
Registered User
 
Join Date: Feb 2008
Location: , , .
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.

  #2 (permalink)  
Old February 27th, 2008, 05:04 AM
Registered User
 
Join Date: Feb 2008
Location: , , .
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.

  #3 (permalink)  
Old February 28th, 2008, 02:46 AM
Registered User
 
Join Date: Feb 2008
Location: , , .
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?

  #4 (permalink)  
Old February 28th, 2008, 12:27 PM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
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)
  #5 (permalink)  
Old February 29th, 2008, 01:36 AM
Registered User
 
Join Date: Feb 2008
Location: , , .
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.




  #6 (permalink)  
Old February 29th, 2008, 05:08 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
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)
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:17 PM.


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