Can't get user authentication working. Errors.

I'm starting to reevaluate COT, having decided to wait for the promised features. I'm using 8.7.7.0 since it does not show a nag screen for the eval version. In any event, most works except when I try to add the user authentication, in which case, on run, I get this msg:

[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) +993
System.Web.Security.SqlRoleProvider.CheckSchemaVersion(SqlConnection connection) +59
System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +777
System.Web.Security.RolePrincipal.IsInRole(String role) +183
FreeTrial.Data.ControllerUtilitiesBase.UserIsInRole(String[] roles) +386
FreeTrial.Services.ApplicationServicesBase.get_IsContentEditor() +115
FreeTrial.Services.ApplicationServicesBase.UserSettings(Page p) +720
FreeTrial.Web.AquariumExtenderBase.RegisterFrameworkSettings(Page p) +308
FreeTrial.Web.MenuExtender.OnLoad(EventArgs e) +31
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +168
System.Web.UI.Control.LoadRecursive() +168
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2645

Sorry I don't know enough about the processes involved to figure it out. That's why I am trying COT--so it can do it. What am I not getting right?
1 person has
this question
+1
Reply
  • Select your project on the start page.

    Choose Settings and proceed to Database Connection.

    Click "..." button next to the connection string. Scroll to membership section.

    Press Remove and wait for confirmation.

    Press Add and wait for conformation.

    Press OK to save connection string, press Finish.

    Press Refresh and refresh your project.

    Press Generate .
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • Thank you very much for your help. I tried the procedure but after the wheels had stopped turning I got a dialog "Information." I'm sending a screenshot because there were so many items on the list.

    Thanks. Hope you have some ideas. I did make sure all the latest .net libraries have been installed--I think.

    JS
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • So there you have it.

    The lack of response on tech support questions is the main reason I'm considering opting out of COT. I have been an enthusiastic supporter and have been genuinely impressed by the work done by COT on their product.

    It seems to me that COT is aimed at least partly at those who understand programming basics but want a utility to do some of the heavy lifting and detail work when getting a project started. When it works, everything's wonderful, but when there is something I can't figure out, I seldom get an answer to put me on the right path. When I asked my question the first time, COT sent the procedure that is already documented on their site. That's fine--it is possible that I would have missed it.

    But when I wrote back to say that the method the offered did not fix things and included the error messages (see above), all there I get is silence. If this were an active project for a real client I would be in a fix. As it happens, this is just another evaluation app I'm putting together to continue to evaluate COT as a professional design tool.

    I do think it's a great product, but with outdated documentation and slow tech support (if ANY), I can't pull the trigger on using COT for a commercial project. In good faith (and self interest), I'll keep evaluating the new versions, but it matters little what the new versions hold if documentation and tech suuport are not improved.

    I'm frustrated, but not angry or upset. I've put LOTS of time in on learning and evaluating COT, and still have high hopes. But I've seen others voice the same reservations about the documentation and support, and have seen little change in the quality of those services.

    Still hoping....

    JS
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated