Of course it's not consistent
I guess everyone else just makes different mistakes than me, huh?
My contribution today to the Google Q&A machine is.. what to do about this exception..
Could not load type 'System.Web.Security.SqlProfileProvider'
The answer is to stop being so lazy and copy+pasting code all over the shop. Yes, you just proved you did it, no need to argue. You copied the <membership> or <roleManager> section in your web.config and renamed it <profile>.
Well d*ckhead, you assumed too much! SqlProfileProvider is in a different namespace than SqlMembershipProvider and SqlRoleProvider. Hah! Fancy falling for THAT one.
You need type="System.Web.Profile.SqlProfileProvider"
ASP.NET 3.5 Web Hosting: 3 Months FREE + FREE Setup - CLICK HERE!