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