When you setup the providers for the IIS web site, don’t change the default providers for Membership and Roles to your SQL Membership providers. It might appear as working, but problems will arrive sooner or later.
I chose to emphasize this because some tutorials for SharePoint 2007 instructed to change the default provider. But in 2010, there’s the new Claims Based Model that has providers of it’s own, so we shouldn’t change this setting anymore.
If you use the IIS 7 console to make these changes, it should look like this:
When you go to the website, and click “.NET Users” (which is the equivalent of Membership in web.config), you should see this error message:
“The feature cannot be used because the default provider is not a trusted provider.”
This message is OK because the default claims providers are trusted, and that is alright.
Click OK, and then “Set Default Provider…” link in the top right menu.
The selected option should be “i” for .NET Users, and “c” for .NET Roles. Keep it that way.