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.

(Visited 63 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 Ваш вопрос, поправка или уточнение

Editor on duty will review your comment. Can't wait? Discuss your topic right now in forums, if you register and login.     Required fields are marked with * Ваше послание пойдет на просмотр в редакцию. Не можете ждать? Обсудите ваш вопрос прямо сейчас в форуме Русский Круг , ecли вы зарегистрируетесь и войдёте под своим именем.     Поля, обязательные для заполнения, помечены *
* *