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...