this is what I'm doing with the provider..
it seems to be working, I can create a user successfully with my full version myhosting sql server. the error I'm referring to it coming from the IIS7 manager itself. at the moment I suppose it isn't cause a functional problem but I'm wondering if it will in the future as I develop further.
<add name="LocalSqlServer" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" />