Unable to access external SQL Server from my Web
Posted on 2011-09-08
we installed an ASP.NET WebApplication in our hosting , our application suppose to access an external Sql Server ( with public ip ), we already do this issue with another hosting and it was working fine, but when we try this with our current hosting in Godaddy , we received the following error:
Server Error in '/' Application.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
the connectionstring that i use was
Data Source=126.96.36.199;Database=OnlineApp;User ID=****;Password=*******;
Note: i used the same Connection string from IIS installed on my Laptop and connect to the SQL Server which is based on another Network and it work Fine.
i tried to create the same data base on our hosting Sql Server , everything work fine.
but, the problem that i need the Sql Server on external Server
Your Urgent Advice is highly appreciated