SharePoint Forms Based Authentication on IIS7, Server 2008

Most tutorials available on the internet for setting up DBA on MOSS are specific to IIS6. I just found a quirk with IIS7 that may slow you down. If you are getting

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.