Hey Imar,

After running the aspnet_regsql, to migrate the aspnetdb, i'm getting the following error when I add a new user... whats the best way to address that...
thanks Imar, Eddie

Error:
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'PLANETWROX', schema 'dbo'


*** solution ? *****
************ SQL Commands ?? ************************
*** or just grant execute permmision somewhere else *********

GRANT

EXECUTE ON dbo.aspnet_CheckSchemaVersion TO "myUserName"

GRANT

EXECUTE ON dbo.aspnet_Membership_CreateUser TO "myUserName"

GRANT

EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO "myUserName"

Hi there,

Check out page 767, step 7 (Appendix B) that shows how to configure the permissions.

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!

Thanks Imar,
yea, I NOW realize I appended the aspnet db and never gave the new tables permissions.
Ahh, now that i've deployed my site to SQL server and a local IIS setup
on my development box, how do i control the role management functions and then eventually to a webhosted site.

Thanks so much Imar, Eddie

Answered here..... Membership & Roles in localhost & Prod sites

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!