WCF Service Hosted In IIS Unable to Connect to SQL Server and display In SharePoint Online External

%3CLINGO-SUB%20id%3D%22lingo-sub-1686826%22%20slang%3D%22en-US%22%3EWCF%20Service%20Hosted%20In%20IIS%20Unable%20to%20Connect%20to%20SQL%20Server%20and%20display%20In%20SharePoint%20Online%20External%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1686826%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%2C%3C%2FP%3E%3CP%3EI%20have%20Hosted%20a%20WCF%20service%20in%20IIS%20and%20I%20am%20using%20SharePoint%20designer%202013%20to%20connect%20to%20BCS%20of%20SharePoint%20online.%3CBR%20%2F%3EI%20am%20able%20to%20create%20the%20external%20content%20type%20and%20external%20content%20list%20but%20when%20I%20access%20the%20external%20list%20I%20am%20getting%20the%20below%20error%3C%2FP%3E%3CP%3EA%20network-related%20or%20instance-specific%20error%20occurred%20while%20establishing%20a%20connection%20to%20SQL%20Server.%20The%20server%20was%20not%20found%20or%20was%20not%20accessible.%20Verify%20that%20the%20instance%20name%20is%20correct%20and%20that%20SQL%20Server%20is%20configured%20to%20allow%20remote%20connections.%20(provider%3A%20SQL%20Network%20Interfaces%2C%20error%3A%2026%20-%20Error%20Locating%20Server%2FInstance%20Specified)%3C%2FP%3E%3CP%3EI%20have%20given%20all%20the%20required%20permission%20in%20SQL%20server%20to%20make%20it%20accessible%20and%20have%20checked%20it%20its%20accessible%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20have%20hosted%20the%20same%20WCF%20service%20which%20is%20hosted%20in%20IIS%20in%20Azure%20App%20Service%20and%20its%20working%20fine%20and%20the%20data%20is%20getting%20pulled%20and%20being%20displayed%20in%20External%20list%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Ebelow%20is%20my%20web%20config%20of%20WCF%20Service%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22syed_shadab_mohammed_0-1600496070722.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219806i2BA85FD86B083CFE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22syed_shadab_mohammed_0-1600496070722.png%22%20alt%3D%22syed_shadab_mohammed_0-1600496070722.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECan%20you%20please%20help%20me%3C%2FP%3E%3CP%3EThank%20you%3CBR%20%2F%3ESyed%20Shadab%20Mohammed%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1686826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexternal%20list%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIIS%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Designer%202013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%20Office%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%202017%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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

syed_shadab_mohammed_0-1600496070722.png

 


Can you please help me

Thank you
Syed Shadab Mohammed

0 Replies