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