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.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 35
User or role ‘ASPNET’ does not exist in this database.