Database Schema not compatible : The Official Microsoft ASP.NET Forums

Reply

HexElffilter

Member

177 Points

140 Posts

Database Schema not compatible

Jun 21, 2006 03:32 PM|LINK

Hi,

I get the following message when trying to run the Time Tracker pages.

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlRoleProvider' 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.

Source Error:

Line 11:         if (Roles.Enabled)

Line 12:         {
Line 13:             if (!Roles.RoleExists("ProjectAdministrator"))
Line 14:             {
Line 15:                 Roles.CreateRole("ProjectAdministrator");

Source File: e:\MISintranet\TimeTracker\Global.asax Line: 13

Stack Trace:

[ProviderException: The 'System.Web.Security.SqlRoleProvider' 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.]
   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +589
   System.Web.Security.SqlRoleProvider.CheckSchemaVersion(SqlConnection connection) +65
   System.Web.Security.SqlRoleProvider.RoleExists(String roleName) +482
   System.Web.Security.Roles.RoleExists(String roleName) +242
   ASP.global_asax.Application_Start(Object sender, EventArgs e) in e:\MISintranet\TimeTracker\Global.asax:13

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I have check the aspnet_SchemaVersions table, which is currently populated with '1'.

And when I run aspnet_regsql.exe I get the following message:

Sql error 446: Cannot resolve collation conflict for equal to operation.

Is there a solution to this?

Thanks

Reply

zhuhua1006

Contributor

4070 Points

808 Posts

Re: Database Schema not compatible

Jun 22, 2006 07:49 AM|LINK

It seems not an asp.net issue but a sql server issue. The collation of the which is created by aspnet_regsql doesn't match that of the sql server.

Do you use Sql Server 2000 or 2005?

If you use sql express, can it work fine?

You can also try to change the collation of the SQL server to solve the problem. You can serach for how to do it.

Marked as answer by HexElffilter on Jul 29, 2008 02:51 PM

Reply

HexElffilter

Member

177 Points

140 Posts

Re: Database Schema not compatible

Jun 22, 2006 10:31 AM|LINK

Thanks. I am trying to get this running on SQL Server 2000.

I have looked at the collation on the server, and tried to use the ALTER DATABASE syntax to change the collation on the database, but this still hasn't worked and when I run aspnet_regsql it still has the same issue.

Reply

HexElffilter

Member

177 Points

140 Posts

Re: Database Schema not compatible

Jun 22, 2006 11:15 AM|LINK

Got it sorted now, had to do it on each table as well.

Reply

Polly Anna

Member

342 Points

104 Posts

Re: Database Schema not compatible

Oct 12, 2006 01:41 PM|LINK

Hi,

I would appreciate a bit of help as I am having the same problems when using the ASP.Net Sql Server Registration Tool. Do I have to change the collation for each of the new tables created in my application db, after the tool has run?

Many thanks for your help.

Polly Anna

Reply

st_

Member

31 Points

14 Posts

Re: Database Schema not compatible

May 17, 2008 10:25 AM|LINK

I had this issue but found an easy solution:

You just need to take the web application offline and then online using Web Site Administration Tool. That makes some changes in web.config in the pages tag and globalization if needed. Then you can go [:)]

Edited by st_ on May 17, 2008 10:26 AM

Reply

pacman74

Member

4 Points

2 Posts

Re: Database Schema not compatible

Jun 17, 2009 02:35 PM|LINK

I had this problem spent an entire day on it re-scripting the database my original feeling was the problem was missing data in table aspnet_SchemaVersions so I imported this data but it made no difference.

Kept modifying the db all day sometimes it would work and other times not but never really made any sense when it started working.

Finally realised you can change the data in aspnet_SchemaVersions but it wont make any difference until you restart world wide web publishing service. Not sure whether this is related to the fact my DB is also a session upgraded personalisation DB.