Is there a way to use only forms authentication with multiple membership providers? For example, a user would enter their username and password this would attempt to authenticate with, say, the SQL membership provider, if that fails then a different membership provider would be used.
I have tried something like this to switch the provider being used but this does not work, I know I can authenticate with the windows provider but in this case strictly using forms is preferred.
iisSettings.FormsClaimsAuthenticationProvider.MembershipProvider = "admembers";
bool status = SPClaimsUtility.AuthenticateFormsUser(Context.Request.UrlReferrer,
signInControl1.UserName,
signInControl1.Password);