Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 26th, 2009, 02:38 AM
Authorized User
 
Join Date: Mar 2009
Posts: 17
Thanks: 1
Thanked 0 Times in 0 Posts
Default Vista Home Premium and SQL Express 2008

My system is Vista Home Premium with SP1. It has VS 2008 Professional with SP1 and SQL Server Express 2008.

IIS under Home Premium does not support Windows Authentication. In addition, Home Premium does not allow for the management of "Local Users and Groups" (different than a user signon), which are used to define separate accounts for SQL Server Services, such as Database Engine, Analysis Service, Browser, etc.

The problems I have encountered are:

1. In chapter 1, adding a New Web Site, required both Windows Authentication and VS to be run as administrator. So, I did it that way.

Each time I start the PaidTimeOffSolution without administrator, even though the user sign-on is marked as an administrator, two error pop-ups are provided on need run as administrator, windows Auth and connection string being used in Settings.designer.cs and PaidTimeOffUI is marked unavailable.

When VS is run as administrator, everything starts nicely. It is not a problem continuing to work through the book this way, but if there was a solution other than Vista Business upgrade, it would be nice.

2. In chapter 2, Adding a Record code, a SQL Server login error was returned with NT Authority/Network Services.

I re-installed SQL Server providing different Account Names for the Services, but nothing worked. I was never able to find the service using Network Service as the Account.

Eventually I installed SQL Server with mixed authentication mode. This allowed me to create a SQL Login and assign the HRPaidTimeOff database. Changing the Settings.Designer.cs to have user and password in the default connection string allowed me to test the add, update and delete code in the chapter; I've not tried the stored procedures as yet.

I was able to access the SQL database in a different ASP.NET application using VS "start without debugging", but the same code in the default.aspx.cs resulted in the same NT Authority/Network Services error.

Are these issues based upon the missing support for Windows Authentication in Vista Home Premium or do I have something configured incorrectly? Without knowing how extensively testing was performed on the various versions of Vista, these may be difficult questions to answer.

Thanks in advance for any thoughts
  #2 (permalink)  
Old March 30th, 2009, 09:46 PM
Wrox Author
 
Join Date: Jan 2009
Posts: 73
Thanks: 0
Thanked 7 Times in 7 Posts
Default

I'm working on getting my hands on your version of Vista and will let you know what I find. You definitely need Windows Authentication to work for the site to work. The user's credentials are used to lookup the user name in the ENTUserAccount table.
  #3 (permalink)  
Old April 2nd, 2009, 10:48 AM
Authorized User
 
Join Date: Mar 2009
Posts: 17
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Vince,

Thanks for looking at the Vista Home issues.

For Chapter 4, I found leaving the Anonymous Authenication enabled caused the Tree Menu not to be displayed and of course the current user was blank. I disabled Anonymous Authenication in IIS for the PaidTimeOffUI, which yields no access to the website.

So, I created a standard user signon with password and enabled Basic Authenication. This forces a login to the web site for the each new startup, but it provides a current user name. The full Tree Menu and current user are now displayed.

I tried the ASP.NET authenication, using the created user signon, but this did not work. This would be the most logical authenication to use, since it forces a single user name to be used and does not require login. I may experiment more here. Otherwise, I'm moving ahead.

Oh, I kept expecting you to provide some explanation of the DBHELPER in Chapter 2, since the code uses it, but nothing has appeared in the chapters 3 or 4 as yet. You made reference to putting the connection string in web.config in chapter 2, but this was never done in the book like adding the Version in appsettings. The reader, of course, needs to change the connection string, if they copy web.config fron the code. Just an observation.
  #4 (permalink)  
Old November 6th, 2009, 11:01 AM
Authorized User
 
Join Date: Nov 2009
Posts: 14
Thanks: 4
Thanked 0 Times in 0 Posts
Default

Hi,

I'm having the same issue with Windows 7 Ultimate and IIS7.

I cannot see the tree but can the tabs.

Can you explain further:
"So, I created a standard user signon with password and enabled Basic Authenication."

Was this done in .net config tool?

Gilbo
  #5 (permalink)  
Old January 6th, 2010, 07:55 AM
Authorized User
Points: 128, Level: 2
Points: 128, Level: 2 Points: 128, Level: 2 Points: 128, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2009
Posts: 31
Thanks: 3
Thanked 0 Times in 0 Posts
Default Tree Menu not being displayed.

Hi everyone,

I'm facing the same issue with Windows Vista Business and Windows 7 Home edition.
I disabled Anonymous Authentication in IIS7. My Tree Menu is not displaying, but tabs are working fine.
Did you solved your problem?
  #6 (permalink)  
Old January 8th, 2010, 06:33 PM
Authorized User
Points: 128, Level: 2
Points: 128, Level: 2 Points: 128, Level: 2 Points: 128, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2009
Posts: 31
Thanks: 3
Thanked 0 Times in 0 Posts
Default Tree With Form based authentication do not works.

Hi,
I solved the problem by turning anonymous access off.
When I enable anonymous access on, my tree disappears.
But I want to use Form based authentication.
I think when using Form based authentication we requires to enable anonymous access until unless we are using impersonation in IIS.
Did you solved the problem?
What are your IIS settings with respect to:
Basic authentication and anonymous access?
Thanks,
  #7 (permalink)  
Old January 9th, 2010, 06:53 PM
Authorized User
 
Join Date: Mar 2009
Posts: 17
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Once I determined an IIS website authenication combination that worked, I did not look for a more elegant solution. For the website, under Authenication, everything is Disabled, except for Basic Authenication. I created a new windows login user, just because I wanted to look at difference in the roles. The disadvantage is the login step to access the web page, the first time.

I tried extracting the username from the Environment class, but this only returned the machine name. In non-website applications, it returns the username.

While trying to find a combination that worked, I found an article on mixed-mode authenication. Started to read it, but decided my real goal was reading the book. The link to the article is http://www.15seconds.com/Issue/050203.htm. Perhaps this article
may point you in the correct direction.

I do not have Windows 7 and have no current plans to upgrade.

Sorry I was not much help.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch11 AdRotator Windows Vista Home Premium AndeDana BOOK: Beginning ASP 3.0 1 November 28th, 2010 07:51 PM
Installing SQL Server 2008 Express Edition with Tools Kevin7777 BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 March 8th, 2009 05:14 AM
Downloading VB 2008 Express Kiddi Visual Basic 2008 Essentials 1 June 11th, 2008 12:29 PM
Install VS2005 on Windows Vista Home PremiumWindow sansircar ASP.NET 2.0 Basics 3 January 10th, 2008 10:08 AM
XP Home Edition tweaks for VWD Express mfoskey BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 December 19th, 2007 11:59 AM



All times are GMT -4. The time now is 04:36 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.