EXECUTE permission denied on object 'aspnet_CheckSchemaVersion

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

asp.net 3.5

I've created a database in Sql Server 2005 for my asp.net project. I used
aspnet_regsql to add membership tables and stored procedures.

Then I added a login/user to this database. Default schema for this user is
dbo.

When I try to execute my asp.net webpage I get this error:
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database
'Test', schema 'dbo'.

I see that there are several owned schema and role members starting with
aspnet_ should I enable these settings for this user or is there a better
approach... like maybe setting this user to be db_owner?

any suggestions?


.

Relevant Pages

  • Re: Replacing VS .NETs SQL Server Express Edition Integration
    ... As you said you already have an existing database that contains the ... membership structure, ... Replacing VS .NET's SQL Server Express Edition Integration ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Seen the Survey?
    ... paper appointment records and census returns for leaders ... I'm looking at it in many ways from someone that knows such a database ... Membership Database that I perceive no real use for nor need for. ... The task is to work with kids and get them active, ...
    (uk.rec.scouting)
  • Re: Need to load 200 users into Form security DB
    ... membership provider" if you want to see what that entails. ... My situation is that I had a development database with some users/roles ... security database in SQL2008 with 11 tables, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: EXECUTE permission denied on object aspnet_CheckSchemaVersion
    ... I've created a database in Sql Server 2005 for my asp.net project. ... 'Test', schema 'dbo'. ... I see that there are several owned schema and role members starting with ... aspnet_ should I enable these settings for this user or is there a better ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: What do you think about......?
    ... just posting a message on one of the Yahoo groups I moderate and I ... One thing I thought of was putting the Directory in a database. ... it could be accessed by anyone with membership to the group. ... I'm not sure if you can limit access to a feature of a group while all ...
    (rec.crafts.textiles.quilting)