Estou configurando os serviços do SQL Reporting com a integração do SharePoint. Criei meu novo banco de dados de relatórios, instalei a função de front-end da Web do SharePoint no servidor de relatórios, instalei os relatórios em todos os meus WFEs e executei a configuração na administração central.
Estou executando o MOSS 2007 SP2 e o SRS 2005 SP2
Eu tenho todas as verificações verdes em minha configuração de serviços de reprotação, mas se eu tentar navegar para o diretório virtual do Report Server, recebo o seguinte erro.
Reporting Services Error
Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help Access to this Web site has been blocked. Please contact the administrator to resolve this problem. Access to this Web site has been blocked. Please contact the administrator to resolve this problem.
SQL Server Reporting Services
Se eu der uma olhada nos logs, receberei mais detalhes.
w3wp!library!1!2/11/2010-18:18:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: Access to this Web site has been blocked.
Please contact the administrator to resolve this problem. ---> System.Runtime.InteropServices.COMException (0x81020071): Access to this Web site has been blocked.
Please contact the administrator to resolve this problem. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) --- End of inner exception stack trace --- at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.SPSite.get_ReadLocked() at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() --- End of inner exception stack trace --- w3wp!security!1!2/11/2010-18:18:23:: i INFO: Exception while running with elevated privileges w3wp!security!1!2/11/2010-18:18:23:: i INFO: Report Server has encountered a SharePoint error. w3wp!webserver!1!2/11/2010-18:18:23:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: Access to this Web site has been blocked.
Please contact the administrator to resolve this problem. ---> System.Runtime.InteropServices.COMException (0x81020071): Access to this Web site has been blocked.
Please contact the administrator to resolve this problem. at Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) --- End of inner exception stack trace --- at Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(String bstrUrl) at Microsoft.SharePoint.SPSite.get_ReadLocked() at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() --- End of inner exception stack trace --- at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.<>c__DisplayClass1.b__0() at Microsoft.ReportingServices.SharePoint.Server.Utility.<>c__DisplayClass5.b__3() at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state) at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.b__2() at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param) at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode) at Microsoft.ReportingServices.SharePoint.Server.Utility.RunElevated(CodeToRunElevated code) at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.ImpersonateSharePointSiteByUserName(String wssUrl, String userName) at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.GetSharePointImpersonatedWeb(String wssUrl, UserContext userContext) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children)
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports) at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction'1.Execute() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderFolder() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Parece que o diretório virtual ReportServer está sendo processado pelo SharePoint ainda. Você precisa configurá-lo como uma exclusão no SharePoint. Para fazer isso, alterne para a seção do SharePoint 12 (C: \ Arquivos de Programas \ Arquivos Comuns \ Microsoft Shared \ Extensões de Servidor da Web \ 12 \ bin) e execute o comando:
stsadm -o addpath -url http://<sharepointurl>/<ReportServer vdir> -type exclusion
stsadm -o addpath -url http://<sharepointurl>/<Reports vdir> -type exclusion
Tags sql-server sharepoint