Posted on: 5/4/2015 8:20:40 PM | Views : 854

After registration, the user is created and a role is assigned successfully.  So then I added the attribute
[Authorize] to the appropriate controllers and this works, bouncing anonymous users to the LogIn page as expected.  However, when I add the roles filter, for example
[Authorize(Roles = "Venue")] it again bounces to the login page, but, once you've logged in and it returns to the original, it throws the error
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
I suspect it's the role provider entry in the web.config that's causing the problem, but I couldn't say how.
<roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider"> <providers> <clear/> <add name="AspNetSqlRoleProvider" connectionStringName="DefaultConne ...

Go to the complete details ...