Data Connection issues between GoDaddy and Network Solutions.
Recently while working on a project for a client, I had the requirement to access SQL Server database that was hosted with Network Solutions as part of a Lead Management website. The clients of this website are other websites that may be hosted across many hosting providers. Currently the client has many site hosted with GoDaddy. I created user controls for the site designer to use them within specific car models pages.
Things would work as expected in my development environment, but as soon as I the site was published on GoDaddy getting data from SQL Server would give "SQL Server does not remote connections" error.
After a little discussion with folks at GoDaddy, it was evident that their hosting infrastructure would not support getting data hosted other than within their network.
It sucks....
Well, I quickly came up with a solution. I created a subweb within the website that was hosted at Network Solution at hosted the data access layer web service that would provide data to the client websites.
There were minor changes to the user control I created for the client website.
Finally things fell in place. Thanks to the Microsoft's .NET and webservices technologies.
Godavari Ananth