Geeks With Blogs
Server Error in Application An unhandled exception occurred during the execution of the current web request

To resolve this there are some work workaround

  1. Re-run the aspnet_regsql.exe.
  2. 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

Related Post:

Association, Aggregation, Composition object relationship

Talent vs Attitude – Harsha Bhogle

What we can learn from Babies

 

Posted on Saturday, October 7, 2006 6:40 AM ASP.NET , C# , Web Services , Design Pattern , unhandled exception | Back to top


Comments on this post: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
it works for me!!!... great
Left by loss on Oct 20, 2006 4:47 PM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
This works if you are having this error. Nice solution.
Left by Shane on Mar 15, 2007 12:03 AM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
thank u - very useful - post things like this...
Left by GOPENATH on Apr 04, 2007 12:23 PM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
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.
Left by Istvan on Sep 14, 2007 12:26 AM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
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.
Left by Istvan on Sep 14, 2007 12:28 AM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
Its necessary de database user to be owner.
Only it.
Left by Vinicius Camara on Oct 16, 2007 7:40 AM

# re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Requesting Gravatar...
Good solution!
it was very useful for me
Thanks
Left by NK on Dec 18, 2007 3:12 AM

Your comment:
 (will show your gravatar)


Copyright © Mahesh Singh | Powered by: GeeksWithBlogs.net