I am trying to programtically execute an MS SQL Server Reports Server Service
in a web application. "http://<Server>/ReportServer/ReportService.asmx"
I am receiving an "The request failed with HTTP status 401: Access Denied."
I have tried using "DefaultCredentials" and Network Credentials that have
local administrator rights on the Report Server computer.
Below is the code I am executing.
This same code works fine in a console application.
Any ideas of what I can try to resolve the error?
Thanks in advance, Ken
Private Sub Page_Load()
Try
'Rem OurSQLReportsServer.Url =
"http://OurSQLReportsServer/ReportServer/ReportService.asmx"
Dim svc As New OurSQLReportsServer.ReportingService
svc.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim CatalogItems() As OurSQLReportsServer.CatalogItem
CatalogItems = svc.ListChildren("/", True) '<- Errors Here
Catch ex As Exception
Response.Write(ex.Message)
End Try
End Sub