Power View 无法连接 [英] Power View Fails to Connect
问题描述
当我尝试通过 .bism 连接创建 Pover View 报告时，出现以下错误:
原始 XML
<块引用>rsCannotRetrieveModel400错误加载项目或数据源的模型时发生'http://localhost/rpl/model.bism'.验证连接信息是正确的，并且您有权访问数据源.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20ProdServices&EvtID=rsCannotRetrieveModel&ProdName11.0.2100.60Microsoft SQLServer Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibrary一个错误加载项目或数据源的模型时发生'http://localhost/rpl/Model.bism'.验证连接信息是正确的，并且您有权访问数据source.Microsoft.ReportingServices.ProcessingCoreCannot模拟数据源的用户'TemporaryDataSource'.Microsoft.ReportingServices.ServiceRuntimeCannot将声明标识转换为 Windowstoken.Microsoft.SharePointCould未检索到有效的 Windows身份.mscorlibAccess是拒绝.
可读版本
<前>rsCannotRetrieveModel400加载项目或数据源http://localhost/rpl/model.bism"的模型时出错.验证连接信息是否正确以及您是否有权访问数据源.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.2100.60Microsoft SQL Server Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibrary加载项目或数据源http://localhost/rpl/Model.bism"的模型时出错.验证连接信息是否正确以及您是否有权访问数据源.Microsoft.ReportingServices.ProcessingCore 无法模拟数据源TemporaryDataSource"的用户.Microsoft.ReportingServices.ServiceRuntime无法将声明标识转换为 Windows 令牌.Microsoft.SharePoint 无法检索有效的 Windows 标识.mscorlib访问被拒绝Microsoft SQL Server Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibrary加载项目或数据源http://localhost/rpl/Model.bism"的模型时出错.验证连接信息是否正确以及您是否有权访问数据源.Microsoft.ReportingServices.ProcessingCore 无法模拟数据源TemporaryDataSource"的用户.Microsoft.ReportingServices.ServiceRuntime无法将声明标识转换为 Windows 令牌.Microsoft.SharePoint 无法检索有效的 Windows 标识.mscorlib访问被拒绝我使用的是带有 Service Pack 1 的 SQL Server 2012 RTM、Sharepoint 2010、Windows Server 2008 R2 Enterprise.所有 SQL、Analysis Services 和 Sharepoint Windows 服务都使用相同的域帐户运行，该帐户也是本地计算机的管理员.该域帐户在 SQL 和 Analysis Services 中都是上帝.它还在 sharepoint 中管理管理员，所有 sharepoint 服务都使用该帐户.IIS 应用程序池也使用该帐户运行.我可以通过任何其他客户端(如 SQL Management Studio)进行连接.Power View 连接有什么问题?请帮忙！
在 SharePoint 中央管理中，导航到应用程序管理 -> 管理服务器上的服务.停止Claims to Windows Token Service"服务并重新启动 IIS.应该可以解决您的问题.
When I try to create a Pover View report over my .bism connection I get following error:
Original XML
rsCannotRetrieveModel400An error occurred while loading the model for the item or data source 'http://localhost/rpl/model.bism'. Verify that the connection information is correct and that you have permissions to access the data source.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.2100.60Microsoft SQL Server Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibraryAn error occurred while loading the model for the item or data source 'http://localhost/rpl/Model.bism'. Verify that the connection information is correct and that you have permissions to access the data source.Microsoft.ReportingServices.ProcessingCoreCannot impersonate user for data source 'TemporaryDataSource'.Microsoft.ReportingServices.ServiceRuntimeCannot convert claims identity to windows token.Microsoft.SharePointCould not retrieve a valid Windows identity.mscorlibAccess is denied.
Readable version
rsCannotRetrieveModel400An error occurred while loading the model for the item or data source 'http://localhost/rpl/model.bism'. Verify that the connection information is correct and that you have permissions to access the data source.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=11.0.2100.60 Microsoft SQL Server Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibrary An error occurred while loading the model for the item or data source 'http://localhost/rpl/Model.bism'. Verify that the connection information is correct and that you have permissions to access the data source.Microsoft.ReportingServices. ProcessingCoreCannot impersonate user for data source 'TemporaryDataSource'. Microsoft.ReportingServices. ServiceRuntimeCannot convert claims identity to windows token.Microsoft.SharePointCould not retrieve a valid Windows identity.mscorlib Access is denied Microsoft SQL Server Reporting Services11.0.2100.60127OsIndependent1033ReportingServicesLibrary An error occurred while loading the model for the item or data source 'http://localhost/rpl/Model.bism'. Verify that the connection information is correct and that you have permissions to access the data source.Microsoft.ReportingServices. ProcessingCoreCannot impersonate user for data source 'TemporaryDataSource'. Microsoft.ReportingServices. ServiceRuntimeCannot convert claims identity to windows token.Microsoft.SharePointCould not retrieve a valid Windows identity.mscorlib Access is denied
I am using SQL Server 2012 RTM, Sharepoint 2010, Windows Server 2008 R2 Enterprise with service pack 1. All SQL, Analysis Services and Sharepoint windows services run with the same domain account which is also administrator in local machine. That domain account is god in both SQL and Analysis Services. It also farm admin in sharepoint and all sharepoint services uses that account. IIS aplication pools run with that account too. I can connect by any other client like SQL Management Studio. What is wrong with Power View connection? Please help!
In SharePoint central administration, Navigate to Application Management -> Manage Services on the Server. Stop the service "Claims to Windows Token Service" and restart IIS. Should fix your problem.
这篇关于Power View 无法连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
