So it’s been a month since my last post.
I’m in Hong Kong servicing yet another non-standard implementation for an A & E firm.
I just finished troubleshooting a very annoying issue with converting them from Vision 5.1 to Vision 6.1 (SP3).
The first issue was that the setup couldn’t load the reports properly, neither could the service pack. So… I reloaded the reports from Report Administration… took a few tries to get this right, adjusting roles in the ReportServer management interface as well as making sure the DeltekVision logon had proper access rights to the servers etc.
Then… I was able to load reports, but kept getting the 401 Unauthorized error when trying to preview them… I have worked literally 2 days on this issue.
Here is the error that kept coming up:
The request failed with HTTP status 401: Unauthorized.
Deltek.Framework.Report.Client.BaseReportViewerControl.RefreshAfterBuild(returnObj As ReturnObject)
Microsoft.Reporting.WinForms.ReportViewer.set_Messages(value As IReportViewerMessages)
Microsoft.Reporting.WinForms.RSParams.EnsureParamsLoaded(forceCredentialsShown As Boolean, parameterInfos As ReportParameterInfoCollection)
Microsoft.Reporting.WinForms.RSParams.GetDataSources(allSatisfied As Boolean&) As ReportDataSourceInfoCollection
Microsoft.Reporting.WinForms.ServerReport.GetDataSources(allCredentialsSet As Boolean&) As ReportDataSourceInfoCollection
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(Report As String, HistoryID As String) As ExecutionInfo
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(methodname As String) As Boolean
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() As String