我正在使用SharePoint集成设置SQL Reporting Services。 我创build了新的报表数据库,在报表服务器上安装了SharePoint Web前端angular色,在所有WFE上安装了报表添加function,并通过中央pipe理中的configuration运行。
我正在运行MOSS 2007 SP2和SRS 2005 SP2
我已经在我的reproting服务configuration中进行了所有绿色检查,但是如果我尝试浏览到Report Server虚拟目录,则会出现以下错误。
报告服务错误
- SharePoint 2010 MySites – 需要简单的解释!
- 如何强制服务器离开SharePoint场
- SharePoint MySite – 清除新闻源活动?
- 进一步的性能调整在中型SharePoint场?
- Sharepoint 2010没有列出来自Active Directory的所有用户
报表服务器遇到SharePoint错误。 (rsSharePointError)获取联机帮助访问此网站已被阻止。 请联系pipe理员解决此问题。 访问此网站已被阻止。 请联系pipe理员解决此问题。
SQL Server报告服务
如果我看看日志,我会得到更多的细节。
w3wp!library!1!2/11 / 2010-18:18:23 :: e错误:抛出Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException:报表服务器遇到SharePoint错误。 信息:Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException:报表服务器遇到SharePoint错误。 —> Microsoft.SharePoint.SPException:访问此Web站点已被阻止。
请联系pipe理员解决此问题。 —> System.Runtime.InteropServices.COMException(0x81020071):访问此网站已被阻止。
请联系pipe理员解决此问题。 在Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(stringbstrUrl)在Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(stringbstrUrl)—结束内部exception堆栈跟踪—在Microsoft.SharePoint.Library.SPRequest.GetSiteFlags (String bstrUrl)at Microsoft.SharePoint.SPSite.get_ReadLocked()at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb。<> c__DisplayClass1.b__0()—内部exception堆栈跟踪结束— w3wp!security!1! 2/11/2010 – 18:18:23 ::我的INFO:运行与提升的特权w3wp!安全的exception!1 2/11/18 – 18:23:23 ::我INFO:报表服务器遇到一个SharePoint错误。 w3wp!webserver!1!2/11 / 2010-18:18:23 :: e错误:Reporting Services错误Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException:报表服务器遇到SharePoint错误。 —> Microsoft.SharePoint.SPException:访问此Web站点已被阻止。
请联系pipe理员解决此问题。 —> System.Runtime.InteropServices.COMException(0x81020071):访问此网站已被阻止。
请联系pipe理员解决此问题。 在Microsoft.SharePoint.Library.SPRequestInternalClass.GetSiteFlags(stringbstrUrl)在Microsoft.SharePoint.Library.SPRequest.GetSiteFlags(stringbstrUrl)—结束内部exception堆栈跟踪—在Microsoft.SharePoint.Library.SPRequest.GetSiteFlags (String bstrUrl)at Microsoft.SharePoint.SPSite.get_ReadLocked()at Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb。<> c__DisplayClass1.b__0()—内部exception堆栈跟踪结束—在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。< > Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)上的c__DisplayClass4.b__2()Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode,Object param)at Microsoft.SharePoint.SPS 在Microsoft.ReportingServices.SharePoint.Server.Utility.RunElevated(CodeToRunElevated代码)上的ecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)在Microsoft.ReportingServices.SharePoint.Server.SharePointImpersonatedWeb.ImpersonateSharePointSiteByUserName(String wssUrl,String userName)at Microsoft.ReportingServices.SharePoint.Server .SharePointImpersonatedWeb.GetSharePointImpersonatedWeb(String wssUrl,UserContext userContext)Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl,CatalogItemList&children)
Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl,CatalogItemList&childList,Security secMgr,IPathTranslator pathTranslator,Boolean appendMyReports)在Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow()Microsoft.ReportingServices.Library.RSSoapAction`1 Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()在Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()上的Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderFolder()执行()
它看起来像SharePoint仍在处理ReportServer虚拟目录。 您需要将其设置为SharePoint中的排除项。 为此,请切换到SharePoint 12configuration单元(C:\ Program Files \ Common Files \ Microsoft Shared \ Web Server Extensions \ 12 \ bin)并运行以下命令:
stsadm -o addpath -url http://<sharepointurl>/<ReportServer vdir> -type exclusion stsadm -o addpath -url http://<sharepointurl>/<Reports vdir> -type exclusion