February 2, 2011 at 5:36 pm
I have configured the SSRS 2008 for Basic Authentication exactly following instructions in this article letter-by-letter:
http://msdn.microsoft.com/en-us/library/cc281309(v=SQL.100).aspx
Everything works: (saving, opening, browsing report models, etc.) except Preview in the Report Builder 2.0 - I receive "The request failed with HTTP status 401: Unauthorized." when I try to preview the report.
Is this a bug in Report Builder 2.0 with Basic Authentication or am I misconfiguring something?
March 1, 2011 at 9:18 am
I am experiencing something similar
When I type in the following url in IE - http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application
A dialog box appears requesting login details. On filling out the Username and passowrd, a dialog box pops up with the words
'Cannot retrieve application. Authentication error.' It has 'OK' and 'Details buttons. When I click on the details button, the following gets displayed in notepad
PLATFORM VERSION INFO
Windows : 5.1.2600.196608 (Win32NT)
Common Language Runtime : 2.0.50727.3615
System.Deployment.dll : 2.0.50727.3053 (netfxsp.050727-3000)
mscorwks.dll : 2.0.50727.3615 (GDR.050727-3600)
dfdll.dll : 2.0.50727.3053 (netfxsp.050727-3000)
dfshim.dll : 4.0.31106.0 (Main.031106-0000)
SOURCES
Deployment url : http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [01/03/2011 15:34:22] : Activation of http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [01/03/2011 15:34:22] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://reportbuilder2.projectminder.com/ReportServer_sql2k8/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.
I will be grateful for some help.
Many thanks
Jude
March 1, 2011 at 11:48 am
Are you using Report Builder 1 or 2?
your URL seems to look like URL for Report Builder 1
whereas for Report Builder 2.0 it should be something like
https://server/ReportServer/ReportBuilder/ReportBuilder_2_0_0_0.application
March 1, 2011 at 3:27 pm
Thanks for your reply
I am using ReportBuilder 2.0.
It doesn't seem to matter what URL I use.
March 2, 2011 at 9:15 am
I have figured this out.
See the article http://msdn.microsoft.com/en-us/library/cc281309.aspx
I enabled anonymous access only.
I skipped the bit about Impersonation as this produced other errors.
March 2, 2011 at 10:54 am
this is the same article that I referred to in the original post.
does your preview work?
March 2, 2011 at 3:38 pm
Thanks for your response.
Yes my preview works.
It appears that if you follow all that the article specifies i.e. amending the Impersonation section in Web.Config and then the addition on the line to allow Anonymous access in the ReportServer.Config file, you get Error 401.
I didn't amend my Web.Config file as specified by the article.
Though, I also have to point out that I did this in SQL Server Reporting Services 2008R2 using ReportBuilder 3.0
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply