在SharePoint 2013中，如何使用FBA（基于表单的身份验证）通过Excel服务将EffectiveUserName传递给SSAS [英] How Can I pass EffectiveUserName to SSAS through Excel Service using FBA(Forms based authentication) in SharePoint 2013

问题描述

我们有一个OLAP项目，它使用Sharepoint 2013 Excel Services来显示包含SQL Server Analysis Services（SSAS）多维数据集的外部数据的Excel文件。
我们用于登录用户的身份验证方法是FBA（基于表单的身份验证）

We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube. Our Authentication method to login users is FBA (Forms Based Authentication)

我们的目标是仅显示每个用户的SSAS多维数据集的数据，在SSAS方面已经定义了角色。

Our Goal is to show only subset of data from SSAS cube for each user based on their role which has already been defined in SSAS side.

FBA根据AD进行身份验证，所有授权用户都已根据其清除级别成为SSAS中各自角色的成员。
我们需要Excel Services将EffectiveUserName传递给SSAS，因此我们在SharePoint中央管理员的Excel Services的全局设置中启用了EffectiveUserName。

FBA authenticates users against AD and all authorized user are already member of respective role in SSAS based on their clearance level. We need Excel Services passes EffectiveUserName to SSAS and for that we enabled the EffectiveUserName in global settings of Excel Services on SharePoint central admin.

在Excel中，我们在我们在某些博客文章上阅读时，已启用连接属性的Excel服务验证设置中的Windows身份验证。
但是通过SharePoint访问它后，出现以下错误。

Than in Excel, we have enabled the Windows Authentication in the Excel Service Authentication Settings of Connection Properties as we read on some blog posts. But after accessing it via the SharePoint, the following error occurred.

数据连接使用Windows身份验证，用户凭据无法委派。
如我所说，我不想将用户凭据委派给SSAS。 Excel Services已配置为使用单个帐户连接到Analysis Services。我只想通过EffectiveUserName。

"The data connection uses Windows Authentication and user credentials could not be delegated." As I already stated, I don't want to delegate user credentials to SSAS. It's already been configure for Excel Services to use single account to connect to Analysis Services. I only want to pass EffectiveUserName.

使用Windows身份验证不是一个选项，因为用户从外部网和互联网访问该网站。

Using windows authentication is not an option because users access the site from extranet and internet.

推荐答案

最后我们改变了我们的登录方式。我们使用使用Windows声明身份验证登录到Sharepoint站点的自定义登录页面。
有关详细信息，请参阅此链接：
自定义Windows身份验证登录

Finally we change our login method. we use a customized login page that use windows claim authentication to login to Sharepoint site. For more information see this link : Customize windows authentication login

这篇关于在SharePoint 2013中，如何使用FBA（基于表单的身份验证）通过Excel服务将EffectiveUserName传递给SSAS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！