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 Mohammed
Access Request Sharepoint Site
Hi Experts, I am looking for a SharePoint functionality to implement in our reporting project. I have a SQL server database table which has City Hierarchy data. Now I want to build a Reports Access Site which should have the City arranged in hierarchical order (Country->Region->State->City).In order to view the data for respective cities, the user need to go to this site and create an access request by selecting the cities/state/region/country he needs access to and then submit for approval. This request should then go through various approval levels and then store this request along with approval details/status in another database table in SQL SERVER so that it can be used by system to provide access. Is this doable and if yes then is there any links/videos which can guide me on how to do it. Thanks Nivi
