Hi all I'm trying to set up BCS in SPS2010 to crawl an SQL table, so that users are able to view the table items within SharePoint. I've followed the steps in this article<http://blogs.msdn.com/b/ericwhite/archive/2010/04/28/searching-external-data-in-sharepoint-2010-using-business-connectivity-services.aspx>, but I'm still having no luck.
Rows from the table do show up in the search results, however clicking on them gives an error "Access denied. You do not have permission to access this content. Correlation ID:6c79b622-0af4-442e-96d2-3727301d5a37". Currently the "Authentication Mode" is set to BDC Identity" within SPD. I did read somewhere else that you need to specifically change a setting around 'RevertAll' in powershell, which I did, but that hasn't had any effect. If I change the auth mode to "impersonate" then it doesn't crawl the source. Does anyone have any tips? Nigel Nigel Hertz SharePoint Administrator / Developer, Information Systems Stockland, Level 22, 133 Castlereagh Street, Sydney NSW 2000 T +61 2 9035 2617 M +61 401 034 605 F +61 2 8988 2617 E nigel.he...@stockland.com.au<mailto:nigel.he...@stockland.com.au> http://www.stockland.com.au/ BEFORE PRINTING THIS EMAIL PLEASE CONSIDER THE ENVIRONMENT ________________________________ Stockland Notice: If this communication has been sent to you by mistake, please delete and notify us. If it has been sent to you by mistake, legal privilege is not waived or lost and you are not entitled to use it in any way. Stockland and its subsidiaries reserve the right to monitor e-mail communication through its networks.
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
