Monday, March 26, 2012

Membership Data Provider

I created a membership database on my local computer. DB is SQL Server 2005. I created create sripts for that database and created this database in a SQL Server 2000 instance on another box.

As soon as I changed my web.config fileto point to the new database, I got this error below. What is causingit?

The 'System.Web.Security.SqlMembershipProvider' requires adatabase schema compatible with schema version '1'. However, thecurrent database schema is not compatible with this version. You mayneed to either install a compatible schema with aspnet_regsql.exe(available in the framework installation directory), or upgrade theprovider to a newer version.

Do I have to create a local Membership database in a SQL 2000 instance, script it out and then create in the other box?

Thanks
Runaspnet_regsql.exe to create the database on your SQL 2000.

No comments:

Post a Comment