Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics 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
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 11th, 2006, 04:05 AM
Authorized User
 
Join Date: May 2006
Location: , , United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bcr212
Default Cant open WroxUnited Virtual Dir

Hi,
Having bought "Beginning ASP.NET 2" I am eager to get on with the lessons, however, I cannot get to the end of Appendix 2 as I cant open the C:/websites/WroxUnited. I have done as described in the book and even reformated my drive to ensure a clean install, but no go ! I get:
ERROR: 500 Internal Server Error
HResult: 0x80070005
Source: Microsoft SQL isapi extension
Description:
when connecting to http://localhost:8080/WroxUnited. I've spent 5 days on this so far, can anyone help me please ?
Thanks.

Reply With Quote
  #2 (permalink)  
Old May 11th, 2006, 04:24 AM
Authorized User
 
Join Date: May 2006
Location: , , United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bcr212
Default

Having run aspnet_regiis -i and recreating the Virtual dir in IIS I'm now getting:
------------------------
Server Error in '/WroxUnited' Application.
--------------------------------------------------------------------------------

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:


Line 112: Public Overridable Property Theme() As String
Line 113: Get
Line 114: Return CType(Me.GetPropertyValue("Theme"),String)
Line 115: End Get
Line 116: Set


Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.yymbuq f6.6.vb Line: 114

Stack Trace:


[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +734979
   System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParserStateObject.ReadSni Error(TdsParserStateObject stateObj, UInt32 error) +556
   System.Data.SqlClient.TdsParserStateObject.ReadSni (DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164
   System.Data.SqlClient.TdsParserStateObject.ReadPac ket(Int32 bytesExpected) +34
   System.Data.SqlClient.TdsParserStateObject.ReadBuf fer() +30
   System.Data.SqlClient.TdsParserStateObject.ReadByt e() +17
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +59
   System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK) +33
   System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
   System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
   System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
   System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424
   System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +496
   System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context, Boolean revertImpersonate) +84
   System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String connectionString, Boolean revertImpersonation) +197
   System.Web.Profile.SqlProfileProvider.GetPropertyV aluesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766
   System.Web.Profile.SqlProfileProvider.GetPropertyV alues(SettingsContext sc, SettingsPropertyCollection properties) +428
   System.Configuration.SettingsBase.GetPropertiesFro mProvider(SettingsProvider provider) +410
   System.Configuration.SettingsBase.GetPropertyValue ByName(String propertyName) +117
   System.Configuration.SettingsBase.get_Item(String propertyName) +89
   System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36
   System.Web.Profile.ProfileBase.get_Item(String propertyName) +68
   System.Web.Profile.ProfileBase.GetPropertyValue(St ring propertyName) +4
   ProfileCommon.get_Theme() in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.yymbuq f6.6.vb:114
   Wrox.Web.GlobalEvents.ThemeModule.app_PreRequestHa ndlerExecute(Object Sender, EventArgs E) in C:\Websites\WroxUnited\App_Code\ThemeModule.vb:30
   System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +64




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
-----------------------------------

so this keeps coming back to sql. I have done nothing to sql express appart from install it as the book doesnt say I have to do anything.
Any idea's ?
Thanks.

Reply With Quote
  #3 (permalink)  
Old May 11th, 2006, 04:36 AM
Authorized User
 
Join Date: May 2006
Location: , , United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bcr212
Default

Got It ! Boy am I happy.
Solution: go to http://blogs.msdn.com/sqlexpress/ and do:
1. Open the SQL Server Configuration Manager. (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools)
2. Select the SQL Server 2005 Service node and then select the SQL Express instance that is no longer working.
3. Open the Property dialog for the instance. (Right-click menu or Action | Properties)
4. Change the 'Log on as:' selector to Local System and click Apply.
5. Once the server has restarted, change the 'Log on as:' selector back to Network Service and click Apply.
...and suddenly it works !
I hope this helps others as I've seen lots of postings about this and I was tearing me hair (what little is left) out :)
Good luck.

Reply With Quote
  #4 (permalink)  
Old May 11th, 2006, 05:48 AM
Authorized User
 
Join Date: May 2006
Location: , , United Kingdom.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bcr212
Default

More on this :) after a reboot I was back to it not working again. I had to change the SQL Server logon again - anyone any idea why its not holding the NETWORK SERVICE setting ?
Thanks.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Unable to open WroxUnited using IIS jjjones3860 BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 19 May 24th, 2008 12:52 AM
Is there a Dir() Function with JavaScript rguidry Javascript How-To 2 October 3rd, 2005 11:54 AM
Setting up Virtual Dir in IIS dsuratman ASP.NET 1.0 and 1.1 Basics 4 June 20th, 2005 07:57 AM
get a collection of filenames/paths from a dir? oowllew C# 0 August 13th, 2004 03:52 PM
Dir function and looping through all files naeem VB How-To 2 May 13th, 2004 12:01 PM



All times are GMT -4. The time now is 08:23 AM.


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