EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

<< Passing CSV string as a SQL In Parameter | Home | ASP.NET Interview Questions >>

EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

To resolve this there are some work workaround

Re-run the aspnet_regsql.exe.
If first one is not working for you then you have to “Add the user to the aspnet_Membership_FullAccess database role.”

-- Add user to database role

USE aspnetdb

GO

sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'

“Network Service” is your user name

Interview Questions | ASP.NET Interview Questions | .NET Interview Questions
ASP.NET 2.0 Interview Questions | .NET 2.0 Interview Questions | SQL Server 2005 Interview Questions

Print | posted on Saturday, October 07, 2006 6:40 AM |

Feedback

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

it works for me!!!... great

10/20/2006 4:47 PM | loss

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

This works if you are having this error. Nice solution.

3/15/2007 12:03 AM | Shane

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

thank u - very useful - post things like this...

4/4/2007 12:23 PM | GOPENATH

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

hi I've got the same problem, i tried to use the aspnet_regSql
its not working...

I wrote the script into sql managemet studio and it shows this massage... PLS HELP !!!!!

Msg 911, Level 16, State 1, Line 3
Could not locate entry in sysdatabases for database 'aspnetdb'. No entry found with that name. Make sure that the name is entered correctly.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role 'Network Service' does not exist in this database.

9/14/2007 12:26 AM | Istvan

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

Sorry this ...

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'C'.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 80
User or role 'Network Service' does not exist in this database.

9/14/2007 12:28 AM | Istvan

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

Its necessary de database user to be owner.
Only it.

10/16/2007 7:40 AM | Vinicius Camara

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

Good solution!
it was very useful for me
Thanks

12/18/2007 3:12 AM | NK

Server Error in Application

My Links

News

Archives

Post Categories

ASP.NET