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 runing 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.

Tags: Deny, Error, Execute, Object, Permission, Schema