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

2015/04/18
By
Modified: 2015/03/22

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 Your Comment Ваш Комментарий

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

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

*