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

If you get the above error in ASP.NET application, the user under which IIS is running does not have the permission to either select,execute,insert or update a table. The funny thing is, it does not provide the user name which is denied the permission (probably for security reason?) but it does say the dbo name.

Usually the user in this case is [NT Authority/Network Service]. You may want to grant DML permissions to [NT Authority/Network Service] so that it can select, update, insert and execute stored procedure.

The following command might fix your problem


GRANT SELECT, EXECUTE, UPDATE, INSERT ON SCHEMA :: dbo TO
[NT AUTHORITYNETWORK SERVICE] 
In another case I got the following error where I learned that the user is “Network Service”.

The server principal “NT AUTHORITYNETWORK SERVICE” is not able to access the database “x” under the current security context.

This entry was posted in Software Development and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s