View Single Post
  #6 (permalink)  
Old August 27th, 2011, 03:36 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

The account used to access the database also needs permissions to execute the stored procedures used by Membership and Roles (as well as reead/write access to the Tables and Views). The aspnet_regsql creates a number of roles that start with aspnet_ that your account needs to be in. Page 766 in Appendix B shows the configuration screen for the roles (it doesn't list the aspnet_ roles, but on your database you should see them).

If you can't seem to access these settings, your host needs to do that for you.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote