Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 9th, 2012, 08:29 PM
Authorized User
 
Join Date: Jun 2012
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile aspnetdb migration - execute permission

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"
 
Old August 10th, 2012, 03:06 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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!
The Following User Says Thank You to Imar For This Useful Post:
EDGY (August 16th, 2012)
 
Old August 16th, 2012, 11:37 AM
Authorized User
 
Join Date: Jun 2012
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile IIS role Manager deployment

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
 
Old August 17th, 2012, 01:56 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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!





Similar Threads
Thread Thread Starter Forum Replies Last Post
ASPNETDB sanindia BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 October 27th, 2006 05:56 PM
(0x800A0046) Permission denied,not IIS permission! David Hay Classic ASP Basics 3 April 30th, 2006 10:47 PM
connection.execute and command.execute difference vinod_yadav1919 Classic ASP Databases 0 September 28th, 2005 06:34 AM
conn.execute,command.execute or rs.open vinod_yadav1919 Crystal Reports 0 January 3rd, 2005 10:26 AM
EXECUTE permission denied on object 'sp_person_isp lennart ADO.NET 1 June 29th, 2003 04:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.