SharePoint 2013 Excel Services - Kerberos - 连接到Analysis Services多维模式 [英] SharePoint 2013 Excel Services - Kerberos - Connect to Analysis Services Multidimensional mode

问题描述

场景：

SharePoint 2013 - Excel Services

来自Excel Services - 连接到在第二个跃点服务器上以多维模式运行的SQL Analysis服务

我根据很多提示配置了必要的SPN和AD委派。

SharePoint 2013 - Excel Services
From Excel Services - connecting to a SQL Analysis services running in Multidimensional mode on second hop server
I have configured the necceary SPN and AD delegation according to a lot of tips.

当我从Excel Services中引用所有连接时，我收到错误消息：

When I refersh All Connection from Excel Services I get the error message:

外部数据刷新失败

我们无法在此工作簿中引用一个或多个数据连接

以下连接无法刷新

External Data Refresh Failed
We were unable to refersh one or more data connection in this workbook
The following connections failed to refresh

在同一个库中，我有一个Excel工作簿，通过​​Kerberos直接连接到SQL数据库，工作正常。

In the same library I have a Excel workbook connecting direct to SQL database via Kerberos and working OK.

我的问题是：

是否可以在多维模式下使用Excel服务连接Kerberos到SQL Analysis服务？

或者只有在PowerPivot模式下使用SQL Analysis Services进行安装时才支持此功能吗？

My question is:
Is it possible to use Excel Services connecting with Kerberos to SQL Analysis service in Multidimensional mode?
Or is this only supported in an installation with SQL Analysis Services in PowerPivot mode?

谢谢，

Arnstein Fuglemsmo

Thanks,
Arnstein Fuglemsmo

推荐答案

嗨Arnstein，

Hi Arnstein,

是的，可以使用Excel服务连接Kerberos到SQL Analysis服务。 

Yes, it is possible to use Excel Services connecting with Kerberos to SQL Analysis service. 

参考文献：

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/11/06/excel-services-2010-2013-kerberos-configuration/

https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-analysis-services-for-kerberos-constrained-delegation?view=sql-server -2017 <跨度>&NBSP;

祝你好运，

Allen Bai

Allen Bai

这篇关于SharePoint 2013 Excel Services - Kerberos - 连接到Analysis Services多维模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！