SharePoint 2016 vs SQL 2016 vs SSRS 2016-日志中的奇怪问题
你好
方案:我已经成功配置了完整SharePoint 2016 BI所需的整个元素.此外，所有工作在Kerberos上.我只有一个问题\问题(ULS日志):
Scenario: I have successfully configure whole elements which is needed for full SharePoint 2016 BI. In addition all working on Kerberos. I have only one problem\issue (ULS log):
06/16/2017 10:49:35.02 w3wp.exe(0x3838) 0x3F54
请求处理 99 高 例外:System.ServiceModel.FaultException`1 [System.ServiceModel.ExceptionDetail]:
SetAuthContext需要以sysadmin身份运行. (故障详细信息等于ExceptionDetail，可能由IncludeExceptionDetailInFaults = true创建，其值为:Microsoft.AnalysisServices.Xmla.XmlaException:需要运行SetAuthContext
作为系统管理员.在Microsoft.AnalysisServices.Xmla.XmlaClient.SendExecuteAndReadResponse(布尔skipResults，布尔throwIfError，布尔useBinaryXml)中.在Microsoft.AnalysisServices.Xmla.XmlaClient.SetAuthContext(String
令牌，字符串数据库ID，IDictionary命令属性)在Microsoft.AnalysisServices.Xmla.XmlaClient.OpenLocalFarmConnection(ConnectionInfo connectionInfo)在Microsoft.AnalysisServices.Xmla.XmlaClient.OpenConnection(ConnectionInfo
conne ... d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02 * w3wp.exe(0x3838) 0x3F54
请求处理 99 高 ... ctionInfo，布尔值& isSessionTokenNeeded)
在Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo，布尔值beginSession)中获得.在Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.CreateClient()
在Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.GetConnection()在Micro ...). d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02 w3wp.exe(0x3838) 0x3F54
请求处理 13 中 不会重试，因为在运行RedirectRequest时会遇到FaultException:System.ServiceModel.FaultException`1 [System.ServiceModel.ExceptionDetail]:
SetAuthContext需要以sysadmin身份运行. (故障详细信息等于ExceptionDetail，可能由IncludeExceptionDetailInFaults = true创建，其值是:Microsoft.AnalysisServices.Xmla.XmlaException:SetAuthContext需要以sysadmin身份运行.
在Microsoft.AnalysisServices.Xmla.XmlaClient.SendExecuteAndReadResponse(布尔skipResults，布尔throwIfError，布尔useBinaryXml)中.在Microsoft.AnalysisServices.Xmla.XmlaClient.SetAuthContext(String token，String databaseID，
IDictionary commandProperties) 在Microsoft.AnalysisServices.Xmla.XmlaClient.OpenLocalFarmConnection(ConnectionInfo connectionInfo)在Microsoft.Analysi... d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02 * w3wp.exe(0x3838) 0x3F54
请求处理 13 中 ... sServices.Xmla.XmlaClient.OpenConnection(ConnectionInfo connectionInfo，
布尔值和isSessionTokenNeeded) 在Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo，布尔值beginSession)中获得.在Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.CreateClient()
在Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.GetConnection()在Micro ...). d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02 w3wp.exe (0x3838) 0x3F54 PowerPivot Service
Request Processing 99 High EXCEPTION: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
SetAuthContext need to be run as sysadmin. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: Microsoft.AnalysisServices.Xmla.XmlaException: SetAuthContext need to be run
as sysadmin. at Microsoft.AnalysisServices.Xmla.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError, Boolean useBinaryXml) at Microsoft.AnalysisServices.Xmla.XmlaClient.SetAuthContext(String
token, String databaseID, IDictionary commandProperties) at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenLocalFarmConnection(ConnectionInfo connectionInfo) at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenConnection(ConnectionInfo
conne... d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02* w3wp.exe (0x3838) 0x3F54 PowerPivot Service
Request Processing 99 High ...ctionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.CreateClient()
at Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.GetConnection() at Micro...). d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02 w3wp.exe (0x3838) 0x3F54 PowerPivot Service
Request Processing 13 Medium Won't retry because FaultException is hit when running RedirectRequest: System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
SetAuthContext need to be run as sysadmin. (Fault Detail is equal to An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: Microsoft.AnalysisServices.Xmla.XmlaException: SetAuthContext need to be run as sysadmin.
at Microsoft.AnalysisServices.Xmla.XmlaClient.SendExecuteAndReadResponse(Boolean skipResults, Boolean throwIfError, Boolean useBinaryXml) at Microsoft.AnalysisServices.Xmla.XmlaClient.SetAuthContext(String token, String databaseID,
IDictionary commandProperties) at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenLocalFarmConnection(ConnectionInfo connectionInfo) at Microsoft.Analysi... d820fc9d-6f21-2091-de8f-e928399e78d2
06/16/2017 10:49:35.02* w3wp.exe (0x3838) 0x3F54 PowerPivot Service
Request Processing 13 Medium ...sServices.Xmla.XmlaClient.OpenConnection(ConnectionInfo connectionInfo,
Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.CreateClient()
at Microsoft.AnalysisServices.SPAddin16.WBDS.ServerConnectionPool.ConnectionCollection.GetConnection() at Micro...). d820fc9d-6f21-2091-de8f-e928399e78d2
当我尝试打开PowerPivot Excel文件时出现问题，该文件的连接数据指向不同的源(Excel文件作为OLAP查询).下面是一个连接:
Issue occurs when I try to open PowerPivot excel file which connection data point to different source (excel file as OLAP query). Below is a connection:
提供程序= MSOLAP.7;集成安全性= SSPI;持久安全性信息=正确;初始目录= PowerPivot20Management20Data_2e1479c87d81415da2ea085a1b6804a8_bc736a66141a48218f649fd4b3a4a0a5_SSPM;数据源=％20.％tx/20％. MDX 兼容性= 1；安全选项= 2； MDX缺少成员模式=错误；数据源版本= 1；更新隔离级别= 2
Provider=MSOLAP.7;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=PowerPivot20Management20Data_2e1479c87d81415da2ea085a1b6804a8_bc736a66141a48218f649fd4b3a4a0a5_SSPM;Data Source=http://teams.test.local/PowerPivot%20Gallery/PowerPivot%20Management%20Data.xlsx;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Data Source Version=1;Update Isolation Level=2
我阅读了很多帮助主题，但没有任何帮助.当我在AS实例的顶部运行SQL Profiles时，看不到此特定连接的任何流量.我也不认为这与缺少AS级别的管理员权限有关(我尝试添加所有 帐户..但问题仍然存在).
I read a lot of help topic but nothing work. When I run SQL Profiles on top of AS instance I not see any traffic for this particular connection. I also don't think so that is related to some missing administrator permission on AS level ( I try to add all accounts there .. but issue still remain).
有什么想法吗?它是测试环境，因此我们可以尝试一切". :)
Any ideas ? It's test environment so we can try "everything" :)
感谢任何提示
Michal
跨度>
您是否以管理员身份在SharePoint中运行PowerPivot服务应用程序的PowerPivot系统服务帐户?如果没有，请连接到SQL Management中的PowerPivot Analysis Services实例. Studio为此:
Did you the PowerPivot System Service account running the PowerPivot service application in SharePoint as an Administrator? If not, please connect to the PowerPivot Analysis Services instance in SQL Management Studio to do this:
如果问题仍然存在，请尝试将其他服务帐户添加到托管PowerPivot实例的数据库服务器上的服务帐户"组中，包括所有SharePoint服务应用程序池帐户 需要访问Analysis Services服务器实例的权限需要具有Analysis Services管理权限，并为Excel Services，SQL Server Reporting Services(SSRS)，Performance Point Services和SharePoint添加了应用程序池帐户 农场帐户.
If the issue still occurs, please try to add additional service accounts to the Service Accounts group on the DB server hosting the PowerPivot instance , including all SharePoint service application pool accounts that require access to the Analysis Services server instance need to have Analysis Services Administrative permissions, added the application pool account(s) for Excel Services, SQL Server Reporting Services (SSRS), Performance Point Services and the SharePoint farm account.
如有任何更新，请随时回复.
谢谢
王恩(Dean Wang)