none
[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

    Question

  • Hello,

           I am able to login Web Service URL and report manager using computer name and report builder is also working fine. 

    http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible)

    http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too)

    It means I am able to access everything locally right?

    http://rs.test.abc.com/reportserver  (web service url working fine. all accessible) 

    http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)    

    when I click on reportbuilder button in report manager it shows me error dialog box with following error log!!

    I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue?

    Please help me to solve this problem. I am finding solution from last 4 days.

    Reporting Service configuratin tool settings

    Web Serivice URL -  all set to default

    Report Manager URL - all set to default

    Environment - Distributed deployment

    Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service, configuration tools

    Server2 (report_db_srv) --windows server 2003, sql server 2005 for report server database

     

    Error log details

    PLATFORM VERSION INFO
    	Windows 			: 5.2.3790.131072 (Win32NT)
    	Common Language Runtime 	: 2.0.50727.3053
    	System.Deployment.dll 		: 2.0.50727.3053 (netfxsp.050727-3000)
    	mscorwks.dll 			: 2.0.50727.3053 (netfxsp.050727-3000)
    	dfdll.dll 			: 2.0.50727.3053 (netfxsp.050727-3000)
    	dfshim.dll 			: 2.0.50727.3053 (netfxsp.050727-3000)
    
    SOURCES
    	Deployment url			: http://rs.test.abc.com/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application
    
    ERROR SUMMARY
    	Below is a summary of the errors, details of these errors are listed later in the log.
    	* Activation of http://rs.test.abc.com/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application resulted in exception. Following failure messages were detected:
    		+ Downloading http://rs.test.abc.com/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.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
    	* [6/29/2010 6:12:10 PM] : Activation of http://rs.test.abc.com/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application has started.
    
    ERROR DETAILS
    	Following errors were detected during this operation.
    	* [6/29/2010 6:12:10 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
    		- Downloading http://rs.test.abc.com/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.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.
    
    
    Report server log file
    <Header>
     <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1540 )</Product>
      <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__06_29_2010_17_32_45.log</Path>
     <SystemName>abc</SystemName>
     <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
     <OSVersion>5.2.3790</OSVersion>
     <ProcessID>3284</ProcessID>
     <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!cec!06/29/2010-17:32:45:: i INFO: CLR runtime is initialized.
    rshost!rshost!cec!06/29/2010-17:32:45:: i INFO: Derived memory configuration based on physical memory as 1547752 KB
    appdomainmanager!DefaultDomain!d30!06/29/2010-17:32:45:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing AuthenticationTypes to '4' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing UrlRoot to 'http://rs.test.abc.com/ReportServer' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing MaxConnections to '2' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing AppID to '(Default)' as specified in Configuration file.
    library!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Initializing CacheLevel to 'Default' as specified in Configuration file.
    resourceutilities!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Evaluation copy: 176 days left
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using report server external url http://RPTSRV:80/ReportServer.
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using url root http://rs.test.abc.com/ReportServer.
    rshost!rshost!d3c!06/29/2010-17:32:46:: i INFO: Configuring maxPhysicalCpu=0, minLogicalCpu=0
    rshost!rshost!d3c!06/29/2010-17:32:46:: i INFO: Logical processor per physical processor 1
    rshost!rshost!d3c!06/29/2010-17:32:46:: i INFO: Logical processor unlimited
    rshost!rshost!d3c!06/29/2010-17:32:46:: i INFO: Maximum logical CPU is 1
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using report server external url http://RPTSRV:80/ReportServer.
    configmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Using url root http://rs.test.abc.com/ReportServer.
    appdomainmanager!DefaultDomain!d3c!06/29/2010-17:32:46:: i INFO: Appdomain:2 WindowsService_0 started.
    resourceutilities!WindowsService_0!d3c!06/29/2010-17:32:46:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!WindowsService_0!d3c!06/29/2010-17:32:46:: i INFO: Evaluation copy: 176 days left
    library!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Initializing crypto as user: RPTSRV\SrvAccUser
    crypto!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Exporting public key
    crypto!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Performing sku validation
    crypto!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Importing existing encryption key
    dbpolling!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_0!d50!06/29/2010-17:32:46:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
    dbpolling!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_0!d64!06/29/2010-17:32:46:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
    dbpolling!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_0!d6c!06/29/2010-17:32:46:: i INFO: PollingMaintenance: Polling started
    rpcserver!DefaultDomain!d4c!06/29/2010-17:32:46:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!d4c!06/29/2010-17:32:46:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
    appdomainmanager!WindowsService_0!d4c!06/29/2010-17:32:46:: i INFO: Appdomain:2 WindowsService_0 initialized.
    rshost!rshost!d4c!06/29/2010-17:32:47:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!d4c!06/29/2010-17:32:47:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    rshost!rshost!d4c!06/29/2010-17:32:48:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!d4c!06/29/2010-17:32:48:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!d4c!06/29/2010-17:32:48:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!d3c!06/29/2010-17:32:48:: i INFO: Derived memory configuration based on physical memory as 1547752 KB
    servicecontroller!DefaultDomain!d4c!06/29/2010-17:32:48:: i INFO: Total Physical memory: 1584898048
    rpcserver!DefaultDomain!d74!06/29/2010-17:32:48:: i INFO: Process monitoring started.
    library!DefaultDomain!d30!06/29/2010-17:32:48:: i INFO: Catalog SQL Server Edition = Evaluation
    appdomainmanager!DefaultDomain!d3c!06/29/2010-17:33:20:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129223244001126768 started.
    appdomainmanager!ReportManager_0-1!d3c!06/29/2010-17:33:22:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/Reports.
    appdomainmanager!DefaultDomain!d3c!06/29/2010-17:33:22:: i INFO: Appdomain:3 ReportManager_MSSQLSERVER_0-1-129223244001126768 initialized (#1).
    appdomainmanager!DefaultDomain!d30!06/29/2010-17:33:31:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129223244109883152 started.
    appdomainmanager!ReportServer_0-2!d30!06/29/2010-17:33:32:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!d30!06/29/2010-17:33:32:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129223244109883152 initialized (#1).
    webserver!ReportServer_0-2!d30!06/29/2010-17:33:57:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-2!d30!06/29/2010-17:33:57:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!ReportServer_0-2!d30!06/29/2010-17:33:57:: i INFO: Evaluation copy: 176 days left
    library!ReportServer_0-2!d30!06/29/2010-17:33:59:: Call to GetPermissionsAction(/).
    library!ReportServer_0-2!d30!06/29/2010-17:33:59:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!ReportServer_0-2!d30!06/29/2010-17:33:59:: i INFO: Initializing crypto as user: RPTSRV\SrvAccUser
    crypto!ReportServer_0-2!d30!06/29/2010-17:33:59:: i INFO: Exporting public key
    crypto!ReportServer_0-2!d30!06/29/2010-17:33:59:: i INFO: Performing sku validation
    crypto!ReportServer_0-2!d30!06/29/2010-17:33:59:: i INFO: Importing existing encryption key
    library!ReportServer_0-2!e34!06/29/2010-17:34:00:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-2!d30!06/29/2010-17:34:00:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-2!d30!06/29/2010-17:34:00:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-2!e34!06/29/2010-17:34:00:: Call to ListChildrenAction(/, False).
    library!ReportServer_0-2!e34!06/29/2010-17:34:00:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!d30!06/29/2010-17:34:00:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-2!d30!06/29/2010-17:34:00:: Call to GetSystemPropertiesAction().
    webserver!ReportServer_0-2!d3c!06/29/2010-17:37:04:: i INFO: Reporting Web Server stopped
    appdomainmanager!DefaultDomain!d18!06/29/2010-17:37:09:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-2-129223244109883152 unregistered.
    rshost!rshost!d18!06/29/2010-17:37:09:: i INFO: Application domain type ReportServer statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.
    library!WindowsService_0!d38!06/29/2010-17:42:46:: i INFO: Call to CleanBatch()
    library!WindowsService_0!d38!06/29/2010-17:42:47:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_0!d38!06/29/2010-17:42:47:: i INFO: Call to CleanBatch() ends
    appdomainmanager!DefaultDomain!d30!06/29/2010-17:51:53:: i INFO: Appdomain:5 ReportServer_MSSQLSERVER_0-3-129223255129228192 started.
    appdomainmanager!ReportServer_0-3!d30!06/29/2010-17:51:53:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!d30!06/29/2010-17:51:53:: i INFO: Appdomain:5 ReportServer_MSSQLSERVER_0-3-129223255129228192 initialized (#2).
    webserver!ReportServer_0-3!d30!06/29/2010-17:51:57:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-3!d30!06/29/2010-17:51:57:: i INFO: Reporting Services starting SKU: Evaluation
    resourceutilities!ReportServer_0-3!d30!06/29/2010-17:51:57:: i INFO: Evaluation copy: 176 days left
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: i INFO: Catalog SQL Server Edition = Evaluation
    crypto!ReportServer_0-3!d30!06/29/2010-17:51:58:: i INFO: Initializing crypto as user: RPTSRV\SrvAccUser
    crypto!ReportServer_0-3!d30!06/29/2010-17:51:58:: i INFO: Exporting public key
    crypto!ReportServer_0-3!d30!06/29/2010-17:51:58:: i INFO: Performing sku validation
    crypto!ReportServer_0-3!d30!06/29/2010-17:51:58:: i INFO: Importing existing encryption key
    library!ReportServer_0-3!324!06/29/2010-17:51:58:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:51:58:: Call to ListChildrenAction(/, False).
    library!ReportServer_0-3!324!06/29/2010-17:51:58:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!d30!06/29/2010-17:51:58:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:09:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:09:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:09:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:12:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:12:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:12:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:15:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:15:: Call to ListRolesAction(System).
    library!ReportServer_0-3!da0!06/29/2010-17:52:15:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:15:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:18:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:18:: Call to ListRolesAction(System).
    library!ReportServer_0-3!da0!06/29/2010-17:52:18:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:18:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:18:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:18:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:18:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:19:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:19:: Call to ListRolesAction(System).
    library!ReportServer_0-3!da0!06/29/2010-17:52:19:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:19:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:24:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:24:: Call to ListRolesAction(System).
    library!ReportServer_0-3!324!06/29/2010-17:52:24:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:24:: Call to SetSystemPoliciesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:25:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:25:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:25:: Call to GetSystemPoliciesAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:25:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:33:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:33:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!da0!06/29/2010-17:52:33:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!da0!06/29/2010-17:52:33:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:33:: Call to ListChildrenAction(/, False).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:33:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:33:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:33:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:34:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!324!06/29/2010-17:52:34:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:34:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:34:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:34:: Call to GetPoliciesAction(/).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:34:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:36:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:36:: Call to ListRolesAction(Catalog).
    library!ReportServer_0-3!da0!06/29/2010-17:52:36:: Call to GetPoliciesAction(/).
    library!ReportServer_0-3!da0!06/29/2010-17:52:36:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:45:: Call to ListRolesAction(Catalog).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetPoliciesAction(/).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to SetPoliciesAction(/).
    library!ReportServer_0-3!324!06/29/2010-17:52:45:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!da0!06/29/2010-17:52:45:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:45:: Call to GetPoliciesAction(/).
    library!ReportServer_0-3!8f8!06/29/2010-17:52:45:: Call to GetSystemPropertiesAction().
    library!WindowsService_0!d3c!06/29/2010-17:52:46:: i INFO: Call to CleanBatch()
    library!WindowsService_0!d3c!06/29/2010-17:52:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_0!d3c!06/29/2010-17:52:46:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-3!da0!06/29/2010-17:52:51:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!324!06/29/2010-17:52:51:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!da0!06/29/2010-17:52:51:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!da0!06/29/2010-17:52:51:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!324!06/29/2010-17:52:51:: Call to ListChildrenAction(/, False).
    library!ReportServer_0-3!324!06/29/2010-17:52:51:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:51:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!da0!06/29/2010-17:52:51:: Call to GetSystemPropertiesAction().
    library!WindowsService_0!d3c!06/29/2010-18:02:46:: i INFO: Call to CleanBatch()
    library!WindowsService_0!d3c!06/29/2010-18:02:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_0!d3c!06/29/2010-18:02:46:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-3!604!06/29/2010-18:07:46:: Call to GetPermissionsAction(/).
    library!ReportServer_0-3!d30!06/29/2010-18:07:46:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!604!06/29/2010-18:07:46:: Call to GetPropertiesAction(/, PathBased).
    library!ReportServer_0-3!604!06/29/2010-18:07:46:: Call to GetSystemPermissionsAction().
    library!ReportServer_0-3!d30!06/29/2010-18:07:46:: Call to ListChildrenAction(/, False).
    library!ReportServer_0-3!d30!06/29/2010-18:07:46:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!604!06/29/2010-18:07:46:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-3!604!06/29/2010-18:07:46:: Call to GetSystemPropertiesAction().
    
    Wednesday, June 30, 2010 12:04 AM

Answers

  • Hi KPatel12,

    Generally, the issue "The remote server returned an error: (401) Unauthorized" happens when the client is not in the same domain the Report Server.

    However, in this case, you mentioned the issue also happened locally. So, there should have other causes. The first cause I got should be the HTTP issue. The user may be redirected to incorrect location. The other one should be the user doesn't have permissions to access the Report Builder folder to download files.

    Now, could you please enable HTTP.SYS logging, and then check if there is any error in the logs?
    In addition, please assign the user proper permissions to access the Report Builder folder(read permission at least):
    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder

    Also, the configuration files will help us to troubleshoot the issue, could you please post them?

    For more information about how to enable HTTP.SYS logging, please see in this article:
    http://msdn.microsoft.com/en-us/library/ms159778.aspx

    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, July 01, 2010 8:48 AM

All replies

  • Hi KPatel12,

    Generally, the issue "The remote server returned an error: (401) Unauthorized" happens when the client is not in the same domain the Report Server.

    However, in this case, you mentioned the issue also happened locally. So, there should have other causes. The first cause I got should be the HTTP issue. The user may be redirected to incorrect location. The other one should be the user doesn't have permissions to access the Report Builder folder to download files.

    Now, could you please enable HTTP.SYS logging, and then check if there is any error in the logs?
    In addition, please assign the user proper permissions to access the Report Builder folder(read permission at least):
    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder

    Also, the configuration files will help us to troubleshoot the issue, could you please post them?

    For more information about how to enable HTTP.SYS logging, please see in this article:
    http://msdn.microsoft.com/en-us/library/ms159778.aspx

    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, July 01, 2010 8:48 AM
  • Hi Jin,

    Thanks for the reply

    Wednesday, July 14, 2010 5:54 AM
  • Jin, you mention "when the client is not in the same domain the Report Server".

    I am in the same scenario; locally everything works OK, but remotely I am getting the error. How this can be sorted out.

    Thanks in advance

    Friday, August 27, 2010 6:02 PM
  • What is the solution when the user machine is not part of the local domain?  That is my scenario.  The user has been given an active directory account within the domain but their laptop is not a member of the domain.

    I am accessing SSRS through SharePoint 2010 using the integration with SSRS.

    Thanks for your help.

    Monday, October 18, 2010 10:02 PM
  • Hi tim_coalson,

    In your scenario, I would suggest you implementing custom security extension(e.g. Forms Authentication) for the SSRS. Then create a form user for each user in your company. After that, they are able to user a form user to logon the server.

    Or, please ask your domain admin to enable VPN for the users outside the domain.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Tuesday, October 19, 2010 1:51 AM