.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

External content types are not working in SharePoint 2010 Web Front End in DMZ

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :SharePoint

I have discovered that my Web Front End server will try to connect directly to the SQL server I have listed in my external content type.  I am able to render the contenct properly on my SharePoint 2010 App server, but when I try to render the list on the DMZ server I receive Cannot connect to the LobSystem (External System).   Is there a way around this?  I would like my Web Front End to connect only to my SharePoint 2010 App tier which has access to all of the databases in my infrastructure.  The Web Front End only has access to the App tier.



View Complete Post

More Related Resource Links

Video: External Content Types and Business Connectivity Services for SharePoint 2010

This video discusses the concept of external content types for Business Connectivity Services. (Length: 1:34)

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

WCF: Consuming Claims-Enabled WCF Web Services as SharePoint 2010 External Content Types, Part 4

Learn how to use SharePoint Designer 2010 to consume a claims-enabled web service.

Migrating Business Connectivity Services External Content Types in SharePoint 2010

Learn to migrate BCS external content types from a development environment to testing environments and production environments in SharePoint 2010.

Configuring SharePoint Server 2010 Search for External Content Types, Part 2

Learn how defining external content types reduces crawl times for large amounts of data by using incremental crawls.

Configuring SharePoint Server 2010 Search for External Content Types, Part 1

Learn how to use SharePoint Designer 2010 to define external content types and to set up a SharePoint Server search crawl that includes that external data.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Quick Note: Create Custom Content Types in SharePoint 2010

Learn how to create a custom content type. Then you add two fields to the content type: a new text field and a field that already exists in web site.

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.

Video: What are SharePoint 2010 Content Types?

This video provides an overview of working with Content Types programmatically. (Length: 2:59)

Video: Programming with SharePoint 2010 Content Types

This video demonstrates how there are certain types of things you can do with Content Types programmatically that are not achievable with the UI. (Length: 5:33)

sharepoint 2010 content rating not working

Hi, I can't get my content rating to work.  I can give something a rating, and when I go back, there is nothing there.  I know about the timer service, and have wated (over a week) and also ran the timer service using the stsadm command and nothing seems to work.nonam

Sharepoint 2010 Missing Content Types

Has anyone run into an issue where your system's base content types dissappear after deploying a new site definition.  We are doing a proof of concept using several CMS solutions and decided to see how sharepoint would fare in the process.  I worked on the POC for 6 weeks without any issues.  After selecting sharepoint as the solution I started refactoring my code into a more logical structure as many of the components were developed from sample code.  I created a couple of custom site definitions that were pretty simple.  Basically I copied the onenet.xml from the publishing site template that sharepoint uses and made a few simple modifications like associating my custom master page and a custom content type with the default page.  When I initially developed these I had no issues at all but yesterday I suddenly was not able to create sites using these site defs.  I figured there was some kind of conflict with my old templates so I deleted all site collections on the server and then tried to create a new site collection and then I couldn't even create a base publishing site.  I got an error indicating the base content type did not exist.  After spending hours going through logs it was clear that sharepoint was not able to build the content type hiearchy when creating new sites so I took a look at the UI and there were only abo

SharePoint Designer External Content Types with WCF


I've created a basic WCF service using an edmx model and service class that only contains the code below (takes 10mins to set up). I followed this link as instructions http://msdn.microsoft.com/en-us/data/cc745957.aspx

public class GRef_Service : DataService<MasterDataDirectoryEntities>
  // This method is called only once to initialize service-wide policies.
  public static void InitializeService(IDataServiceConfiguration config)
    // TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc.
    // Examples:
    config.SetEntitySetAccessRule("*" , EntitySetRights.AllRead);
    // config.SetServiceOperationAccessRule("MyServiceOperation", ServiceOperationRights.All);
    //config.SetServiceOperationAccessRule("GRef_Building", ServiceOperationRights.AllRead);


When I view it in my site

Error Creating External Content Type using Sharepoint Designer 2010

I am trying to create an external content type using Sharepoint Designer 2010. I ran SD on my local machine and connected to a site on some other machine running Sharepoint Server 2010. The Db on which I want to create my ECT resides on my local machine. When I try to use User Identity to connect to my local Db server, it gives me the error that login failed for user <my domain username>. I have both sql server and windows authentication mode login enabled on my sql server. Any help in this regard is appreciated.

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend