Re: Error with Custom SQL Membership Provider

We received this question via e-mail from one of our customers and wanted to share it with the rest of you:

Hi,

The archive is uploaded successfully, and the promotion to test is also successful. But I am getting this error when I try to access one of the services:

"The 'Contoso.Providers.CustomSqlMembershipProvider.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. "

There is no change in this particular service, or the database script for the providers.

I tried to upload the previous archive that was running successfully, but even that is giving this error now.

Hi,

I don’t think that this error is related to SaaSGrid but just a small configuration mistake. Please take a look at this thread for the fix.

http://forums.asp.net/p/985097/1267872.aspx

Cheers,
SaaSGrid Support Team

Thanks for the replies.  These articles are very helpful.  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!