URL Access to SSRS is asking for the username and password.
Hi AllI 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 :
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 withut any problem and i am retrieving values also from my SSRS.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.Regards.
February 26th, 2008 1:29pm
I have searched a lot of netBut still did not get a solution.So anybody has any idea please help me.Regards.
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2008 4:00pm
Is it tough problem or i am missing something in my post.>
February 27th, 2008 7:51am
Any senior member if can help me i will be thankful to him.
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2008 12:03pm
Hi Khushwinder,
This appears to be an issue with a custom code. Please note that the forum for SQL Reporting Services provides break/fix assistance and support for installation, administration and management of SQL reporting services.
For assistance with this issue, please post to the MSDN newsgroups here: http://www.msdn.microsoft.com/newsgroups/
If you have the ISV Competency, Microsoft Global Partner Support Delivery ISV team offers the advisory services to assist with your development projects with best practices, .Net migration guidance, architecture guidance, code samples and technology workshops. Advisory services are offered as part of the partner benefits at no extra charge.
The services can be accessed either by email or phone: isvgold@microsoft.com (for Gold Partners) isvcert@microsoft.com (for Certified Partners) isvreg@microsoft.com (for Empower Partners)
Phone: 1-800-426-9400, option 4, your partner level member services, and follow the instructions for ISV advisory services
February 28th, 2008 4:02pm
hi
in my requirement is ssrs report.that report in using asp.net
in button click event
response.redirect(http://qasql1/Reportserver?/RxReports/Muqualified&rs:Command=Render&mgrid=[DMMGR001MT].[MGR
ID].%26[10]&mgrkey=[DMMFU001MT].[MEASURE KEY].%26[1]&year=[START DATE].[Year].%26[2011]&rs:Format=PDF &rs:DataSource=10.10.109.143&rs:dsu=dwlogin&rs:dsp=!1password);
I am getting this error.
"
The permissions granted to user 'domain\username' are insufficient for performing this operation. (rsAccessDenied) “
please tel me the solution
I am trying since 1 month.
urgent please tel meindu
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2011 3:05am