The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ‘1’.

I figured out the problem though and it was a typical bonehead mistake.  I used a script to recreate all the tables for Membership.  I didn’t copy any data into those tables.  There is a table called aspnet_schemaversions.  It requires some values to be able to validate the versions (duh).  When I added these values into the table, it started working.

common 1 1
health monitoring 1 1
membership 1 1
personalization 1 1
profile 1 1
role manager 1 1

Chalk it up to the learning curve!