provider: SQL Network Interfaces, error: 26
and you know that your connection string and connectivity between servers is good, then you may need to force IIS7 to see your new membership and role providers by default. From onenote:For IIS 7 and forms based authentication, you have to go to your site and specify the default provider for membership and roles in IIS after you have made the additions to the web.config that all the tutorials tell you. The first time you click each, you have to let it try the default and then time out, this takes a minute. Once it has timed out, you click "Set Default Provider" in the right hand column and select your provider. You have to do this for both Roles and Users. Prior to doing this make sure both of your providers appear in the Providers feature of IIS.
