The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

ASP.NET page returns this erorr:

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’.

(1) First try running this command/wizard:

%WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe

(2) If this doesn’t work, try this query:

 -- Add user ASPNET to DB role
 USE YourDB
 GO
 sp_addrolemember 'aspnet_Membership_FullAccess', 'ASPNET'

These steps should resolve your issue.

(Visited 1,795 times, 1 visits today)

1 Comment

  1. Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 35
    User or role ‘ASPNET’ does not exist in this database.

Your question, correction or clarification Ваш вопрос, поправка или уточнение