Setting up External Content Type for SQL Server database using SQL Server authentication - SharePoint 2010 Foundation
This post is a follow up on the issues that I have got setting up External Content Type (ECT) on SharePoint 2010 Foundation that was going to connect to remote SQL Server database for information. I cannot use my SharePoint user accounts to access SQL Server. According to the information I have discovered ECT and Business Connectivity Services are available in the SharePoint 2010 Foundation, but there are some issues if you want to use authentication methods in your external connections that are different from Windows Identity or Current User Identity. This is because there is no Secure Store Service in SharePoint 2010 Foundation which serves as an impersonation hub and is only available in SharePoint 2010 Server edition. The issues are coming from the fact that you can actually create ECT in SharePoint Designer 2010 providing just Secure Store ID and system would ask you for credentials and here you go, but when you try to use your ECT in External Lists or as a lookup columns you w
I just wanna thank you for sharing your information and your site or blog this is simple but nice article I’ve ever seen i like it i learn something todayGoogle Search Training
ReplyDeleteThanks for sharing this is such a very nice post i really like it your blog.
ReplyDeletemedia buying
I am a big fan of your blog.i am so excited by read of your blog's content.really great post.Thanks for sharing superb informations.
ReplyDeleteSEO East London