What is a cached web service?

How can a Public ASP Web Form and Web Service be Hosted to Access a Local, Internal, Structured Query Language Database?

• I am creating an ASP web form hosted on a public Microsoft web host. I need it to access a SQL database located locally on our internal network. I have developed a web service that talks to the ASP web form, but I don’t know where the web service should be located and how to get the data from the ASP web form to the local SQL database on our network.

• Answer:

  I see two problems in the way you deployed your application, lets talk about them later. Have you enabled remote access to your database server ? Here is how you do that http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012 You might also need a static Ip for the database server? I am afraid this isn't possible since you are under control of the ISP who uses dynamic IP. Each time you switch your router off/on then your database server is hosted somewhere else. Now you have static ip, remote connections enabled. You might want to test connection to the database from someone else's machine. Once that works use the connection string in your application hosted ( on windows host ). Let's talk about the problems, Your applications will end up prone to security issues ( since you are new to this i believe) You are running on additional server costs, maintenance and infrastructure think about it