Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 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 December 30th, 2009, 01:07 PM
Registered User
 
Join Date: Dec 2009
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 11: SQL Server connection (General question)

Hello,

I had a problem in the Try It Out exercise on chapter 11. After adding the PlanetWrox.mdf and PlanetWrox_log.ldf files to App_Date folder, when I double clicked the database it took several seconds and then I saw the following message:

http://i45.tinypic.com/2j4wkqw.jpg

I've been through all the Try It Out exercised and the problem was solved. However, I solved the problem only after adding the "Network Service" account, while ASPNET account wasn't even there (After doing the whole aspnet_regiis -i procedure (I'm using XP)). Moreover, I couldn't see the "IUSR" / "IUSR_MachineName" accounts in the "Select Users or Groups" window. My question is - Why is it like this, and if there's any chance for future problems manipulating the DB (later in the book) because of that?

Last edited by StamPita; December 30th, 2009 at 01:10 PM..
 
Old January 2nd, 2010, 02:02 PM
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,

Do you have SQL Server Express installed on your local machine? If so, does it have SqlExpress as the instance name? What accounts did you configure for the App_Data folder? The Network Service account is used by SQL server as well, so if you've attached databases to this SQL server, you need to grant access for NS as well. Check out Appendix B for more info.

If this doesn't help / explain things, please provide more info about your setup of VWD, IIS, SQL Server, OS and so on, and when you run into problems exactly.

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!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 11 Sample database Connection Closed sanmarie BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 15 May 30th, 2009 04:50 AM
Chapter 11 Connection Issue justin000 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 August 4th, 2008 06:14 AM
Connection Chapter 11?! workidoo BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 July 15th, 2008 04:01 AM
Quick Question for Author of Chapter 11 Wullie BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 July 16th, 2006 06:54 PM





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