Schema problem - sqlmembershipprovider created on MSSQL2005 then moved to 2000

[daz_oldham]

Hi All

Bit of an odd one - very basically I created an app using the
SqlMembershipProvider in VS.NET 2005, and I did it on a MS SQL 2005
server.

However, I then find out that for other reasons, I cannot use MS SQL
2005 on the live database, so I transferred my database to my SQL 2000
box.

Now, when I attempt a logon, I get the following message:

The 'System.Web.Security.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.

Is there anything I can do, or am I stuck.

Or, if I create a local database in the project (the desktop version)
will I be able to use this okay with around ten to fifteen users?

Many thanks

Darren

 

[Nicholas Paldino [.NET/C# MVP]]

Darren,

The problem here is that the SqlMembershipProvider is used specifically
for SQL Server. You can't use it with my sql. You will have to create a
class that derives from MembershipProvider (I believe) and uses mySql to
handle all the membership queries (also, how did you get the appropriate
tables set up on mySql correctly)?

 

[Ben Voigt]

Darren,

The problem here is that the SqlMembershipProvider is used specifically
for SQL Server. You can't use it with my sql. You will have to create a
class that derives from MembershipProvider (I believe) and uses mySql to
handle all the membership queries (also, how did you get the appropriate
tables set up on mySql correctly)?

Looking at original post, I think "SQL 2000 box" is referring to MS SQL
Server 2000... not open source mysql database engine.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hi All

Bit of an odd one - very basically I created an app using the
SqlMembershipProvider in VS.NET 2005, and I did it on a MS SQL 2005
server.

However, I then find out that for other reasons, I cannot use MS SQL
2005 on the live database, so I transferred my database to my SQL 2000
box.

Now, when I attempt a logon, I get the following message:

The 'System.Web.Security.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.

Is there anything I can do, or am I stuck.

Or, if I create a local database in the project (the desktop version)
will I be able to use this okay with around ten to fifteen users?

Many thanks

Darren