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

2010/06/28
By
Modified: 2012/04/10

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: , , , , ,


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

  1. RObert
    2013/11/25 at 12:06

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

Add Comment Register



Add Your Comment Ваш Комментарий

Your email address will not be published. Required fields are marked *

* Ваше Имя *
* Ваш Email (не будет показан на сайте)*

*