SharePoint 2013中的外部列表 [英] External List in SharePoint 2013

问题描述

我正在尝试创建一个外部列表以从数据库中检索数据.

我已经在SharePoint设计器中创建了外部列表，但是从SharePoint读取外部列表时出现错误.如下:

将连接身份验证模式更改为"BDC"

错误:

来自外部系统的消息:用户'RHW \ SPS_Farm'登录失败."

将连接身份验证模式更改为用户身份"

错误:

来自外部系统的消息:用户'NT AUTHORITY \ ANONYMOUS LOGON'登录失败.".

          

将连接身份验证模式更改为模拟Windows身份"

错误:

无法呈现数据.如果问题仍然存在，请与您的Web服务器管理员联系.

并且在所有SharePoint数据库上将  Auto_Close设置为False.

有人知道我的问题的原因或解决方案吗?

解决方案

请启用还原为自身"通过以下命令:

 Get-SPServiceApplication

#复制BCS服务应用程序的ID 

bcs = Get-SPServiceApplication -ID"BCS ServiceApp ID"

bcs.RevertToSelfAllowed =

Hi,

I am trying to create an external list to retrive data from the Database.

I have created the external list in SharePoint designer but getting errors when reading it from SharePoint. As follows:

Change connections authentication mode to "BDC"

Error:

Message from External System : 'Login failed for user 'RHW\SPS_Farm'.'.

Change connections authentication mode to "User’s Identity"

Error:

Message from External System : 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'.       

            

Change connections authentication mode to "Impersonate Windows Identity"

Error:

Unable to render the data. If the problem persists, contact your web server administrator.

And the  Auto_Close is set to False on all SharePoint DBs.

Does anyone knows the cause or solution for my issue. 

解决方案

Hi,

Please enable "Revert to Self" via the following commands:

Get-SPServiceApplication

#Copy the ID of BCS Service Appliction

bcs = Get-SPServiceApplication -ID "BCS ServiceApp ID"

bcs.RevertToSelfAllowed =

这篇关于SharePoint 2013中的外部列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！