Skip to main content

Posts

Showing posts with the label Business Data Connectivity
Dear All Following are the steps for the After this setup if you got the error for the "Access denied by Business Data Connectivity error for anonymous users when accesing external list"  You need to follow the following steps    This is because the user  doesn't  have the permission to the external content type. How to resolve: Open  Central Administration . Click on  Manage service applications  which is available in the  Service Applications  section. Click on Business Conectivity service application. Select the external content type, click on  Set Permissions  in the ECB menu. Add the user and then click on Add. Give the permissions for the user and click on Ok. Now navigate to the external list you will be able to see the data in the list. After that if you face a problem with the “Login failed for user "NT AUTHORITY\ANONYMOUS LOGON" while browsing to external list.” To...

Business Data Connectivity Service In SharePoint , Connect SharePoint with SQL, Excel or any third party system

Dear All, Today i connect the 3rd Party database through SharePoint via Business Data Connectivity Services. What are the problem i am facing?  First i face a problem to get the "Access denied by business data Connectivity" which i mentioned the whole tread and solution here  http://social.msdn.microsoft.com/Forums/office/en-US/11f090bc-7645-4b76-8464-9addc4386fc6/access-denied-by-business-data-connectivity?forum=sharepointdevelopment Solution for the this problem is simple Login with your SharePoint Central Administration > Application Management > Configure alternate access mappings (under Web Applications) Make sure your alternative path is set for your "Central Administration Site Collection" the problem will be resolve out Other thing Make sure running: 1) Service under the Start > Services > Claims to Windows Token Service 2) Make sure your SharePoint Web Services Root is enable under IIS>Application Pool Once every thing is do...