ASP.NET 2.0 membership provider not working with SQL 2005

I faced a peculiar problem while deploying my Web application.
I developed the application using Express editions. This tied me to SQL Express behind the scenes with some magic default connection strings. The machine for deployment had SQL 2005 installed and no SQL Express. I used the security controls to set up the login-to-website flow quick n easy and now they barfed like there's no tomorrow on the target machine.

To cut a long story short, there are some mods required to get the default SQL membership provider to work with SQL 2005. Here's the dope on that...

Thanks both you guys... this was driving me nuts.