I have configured BDC in SharePoint. I am able to get data in my external list. I need this data in search too. So I created another content source for BDC. Now when I crawl this content source, it gives below error:
Error while crawling LOB contents. ( Error caused by exception: Microsoft.BusinessData.Infrastructure.AccessDeniedException Access denied by Business Data Connectivity.)
So I googled this error and find out that I need to assign farm admin permission for BDC service. When I provide it, I got following error:
Error while crawling LOB contents. ( Error caused by exception: Microsoft.BusinessData.Runtime.SsoAuthenticationException Message from External System : 'The username returned by the Secure Store Provider is not of the form 'Domain\User'.'. )
I am using
SharePoint Farm account. I have given permission in secure store,search,BDC, and in database. But I am not able to resolve it. Can any one tell what causes this issue and how can I resolve it?
Thanks in advance.