Forum Discussion

sandens's avatar
14 years ago

Security issue when trying to call MS SQL Report Service

Running into an security issue try to use SQL Report Service [Microsoft SQL Server Reporting Services Version 9.00.3282.00].

Service WSDL: http://ms.report.server/ReportServer/ReportService.asmx

Initially I am able to download the WSDL into SOAP UI. I'm met be a authentication window and once I put in the correct credentials the WSDL is loaded. I can then run requests using this wsdl for a few minutes. Though once I stop ( a few minutes go by) and try again I get a message from IIS that I'm not authorized to use this service:

HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS) - Technical Information (for support personnel)

So I added the username and password to the request properties and still running into this issue. I've checked out the Microsoft Report Server help pages, various other blogs and posts, but just can't figure out what the deal is.


We actually broker this service though Progress Actional Intermeadiary using the same credentials that I'm using and it works fine ... but hitting it directly fails with the security issue ..


Wonder if anyone might be able to provide some additional insight on how to get SOAP UI working with this type of service?


Thanks
No RepliesBe the first to reply