大网数据广告活动
数据库与应用安全

Error when you use PowerPivot for Excel workbook

· 52CE 我爱测

This article provides a resolution for the problem that occurs when you try to use a PowerPivot for Excel workbook as a data source in SQL Server Analysis Services.

This article helps you resolve the problem that occurs when you try to use a PowerPivot for Excel workbook as a data source in SQL Server Analysis Services.

Original product version:   SQL Server
Original KB number:   2607106

Symptoms

Consider the following scenario:

  • You configure Microsoft PowerPivot for Excel on a middle-tier server.
  • You configure the server to use Kerberos authentication and then connect to the server.
  • You try to use a PowerPivot for Excel workbook as a data source in Microsoft SQL Server Analysis Services.

In this scenario, you may receive an error message that resembles the following:

HTTP Error 401.

Cause

This issue occurs because the custom bindings for the Redirector service are configured to use Microsoft NTLM authentication. Additionally, the custom bindings are configured not to negotiate.

Resolution

To resolve this issue, enable Kerberos authentication for the Redirector service. To do this, follow these steps:

  1. Back up the Web.config file for the Redirector service.

    [!NOTE] By default, the Web.config file is located in the folder: %SystemDrive%\program files\common files\web service extensions\14\ISAPI\powerpivot.

  2. Open the Web.config file for the Redirector service in Notepad.

  3. Locate the <binding name="RedirectorBinding"> tag, and then change the authenticationScheme value as follows:

    • Original

      <binding name="RedirectorBinding">
      <webMessageEncoding webContentTypeMapperType="Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RawContentTypeMapper, Microsoft.AnalysisServices.SharePoint.Integration" />
      <httpTransport manualAddressing="true" authenticationScheme="Ntlm" transferMode="Streamed" maxReceivedMessageSize="9223372036854775807"/>
      </binding>
      
    • Updated

      <binding name="RedirectorBinding">
      <webMessageEncoding webContentTypeMapperType="Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RawContentTypeMapper, Microsoft.AnalysisServices.SharePoint.Integration" />
      <httpTransport manualAddressing="true" authenticationScheme="Negotiate" transferMode="Streamed" maxReceivedMessageSize="9223372036854775807"/>
      </binding>
      
  4. Locate the <binding name="RedirectorSecureBinding"> tag, and then change the authenticationScheme value as follows:

    • Original

      <binding name="RedirectorSecureBinding">
      <webMessageEncoding webContentTypeMapperType="Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RawContentTypeMapper, Microsoft.AnalysisServices.SharePoint.Integration" />
      <httpsTransport manualAddressing="true" authenticationScheme="Ntlm" transferMode="Streamed" maxReceivedMessageSize="9223372036854775807"/>
      </binding>
      
    • Updated

      <binding name="RedirectorSecureBinding">
      <webMessageEncoding webContentTypeMapperType="Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RawContentTypeMapper, Microsoft.AnalysisServices.SharePoint.Integration" />
      <httpsTransport manualAddressing="true" authenticationScheme="Negotiate" transferMode="Streamed" maxReceivedMessageSize="9223372036854775807"/>
      </binding>
      
  5. On the File menu, click Save.

  6. Exit Notepad.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 11/10/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。