Current Position:Home > Error while connecting to external SQL table using BCS identity in SharePoint 2010

Error while connecting to external SQL table using BCS identity in SharePoint 2010

Update:10-11Source: network consolidation
Advertisement
Hi all,
I am working on SharePoint Foundation 2010. I have a stand alone setup. Now I am trying to connect to a SQL table in another server. I have used SharePoint Designer to connect using BCS. I have selected "BCS Identity" for authenticating with SQL
in the external content type. then I created a list with this external content type.
I get the following error upon opening the external list.
Login failed for user 'INYKGW\sp_farm'.
I am confused. how do I solve this error.
any help is greatly appreciated.
Thanks.

The Best Answer

Advertisement
Hi letShare ,
Whether the  account 'INYKGW\sp_farm' is current user account or a service managed account?
Could you  please  provide detail error message of ULS log  to determine the exact cause of the error.
For SharePoint 2010, by default, ULS log is at      
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS
Also please have a look at  the blog :
http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=82
Best Regards,
Eric
Eric Tao
TechNet Community Support