Getting a 404 Not Found in the root of Orchard CMS when deployed to your hosting?

Over the weekend I’ve been using Orchard CMS to put together a quick website for myself and I ran into a little bump when deploying the application to my server. After deploying the database including creating a new user and updating the settings for the site in the Orchard App_Data directory I was getting a 404 in the root of the application. I was even getting a 404 when I tried to hit a static resource. 

The problem was that the database user was set to change their password at the next login. This was a quick fix but it did take me 10 minutes to figure out while I made sure I’d got the ASP.NET wildcard mapping and other things set up. Moral of the story is, make sure you've had a coffee or two before you deploy your website.