Internet Explorer cannot display the webpage...

Grr just spent an hour fixing this one. Wanted to make a blog post to help anyone else who has this problem. In my case we enabled SSL (https://) on our production DotNetNuke website (works great by the way!).

As part of our deployment we create a module package, (attach it to a Change Request in Team Foundation Server and forward it to the testers) and it is tested. To test it, an exact copy of production is made on another server and the module is installed. This worked fine until we enabled SSL.

The problem is the test server does not have SSL. When you try to go to any page on the DotNetNuke site you just get "Internet Explorer cannot display the webpage". No error in any log that I could find. The hour was spent scratching my head. When I realized it could be the SSL I was stumped as to where the setting was. Yes I know I could go digging through the DNN source and was about to do that when I happened to open the Tabs table and took a look around.

To fix the problem, simply go into SQL server and run this query: