WCF Service Hosted In IIS Unable to Connect to SQL Server and display In SharePoint Online External
Hello , I have Hosted a WCF service in IIS and I am using SharePoint designer 2013 to connect to BCS of SharePoint online. I am able to create the external content type and external content list but when I access the external list I am getting the below error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I have given all the required permission in SQL server to make it accessible and have checked it its accessible I have hosted the same WCF service which is hosted in IIS in Azure App Service and its working fine and the data is getting pulled and being displayed in External list below is my web config of WCF Service Can you please help me Thank you Syed Shadab MohammedIs this a bug? Look up column to External List error - SP2016
Hello folks - I am trying to find out if this is a bug with the product, or an issue with my farm. So, I wanted to reach out to the community to get help on something tested. (SharePoint 2016) Please consider this scenario. I've this tested on both on-premise farms and results are same. Prerequisites: Make sure to have a BCS External Content Type to a SQL database of your choice Make sure to create an External List using this ECT to the said SQL database Steps: Browse to Site Columns on a site collection (Same site collection that external list is on) Create a new site column, select type Lookup - Give a good name that you can remember Select "Get information from: " drop down to the External List you've already created, and select a column Hit "OK" Questions: Do you get an error? If you browse back to Site Columns do you see the column actually created but type is listed as "External Data" ? Please let me know your findings here. Thanks! Ali
