Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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 15th, 2006, 10:00 PM
wyx wyx is offline
Registered User
 
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wyx
Default Installation and configuration of Wrox United

Hi All,

As many other on this forum, I have the problem with getting the WROX United website up and running... . One of these newbies who needs to be pointed in the right direction :D

I am running:
IIS 5.1
Visual Studio 2005
SQL Server 2005
on Win XP Professtional SP2

I have copied the Wrox united directory in the wwwroot.
and also set the virtual directory for SQLXML 3.0 according
to the book in Appendix B. Actually I have followed the instructions exactly as defined in Appendix B.

I get following error when I compile the website:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

I have done some research and many seems to have the same problem on this error 26.

This is what I have tried that people suggested:

- use local and remote connections in the SQL Server 2005 Surface area to get around this error.

- Enable all protocols in SQL Server Configuration Manager. And also activate under the IP Addresses tab in the TCP/IP Properties under MSSQLSERVER.

- Started the SQL Server Browser service.

- Given the windows firewall exeptions on sqlbrowser.exe, sqlservr.exe, SQL Surface Area Connection



But I still keep getting the same error.. .
And I am running out of options on what to do :(
It feels I am missing out something fundamental in this configuration.
I Appreciate all the help I can get

// Wyx







I can't wait until I know how to code ASP.NET
 
Old August 15th, 2006, 11:28 PM
wyx wyx is offline
Registered User
 
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wyx
Default

.. .I forgot to add that I can't get the service SQL Server (MSSQLSERVER) to run on my computer either anymore.
This is the message I get:

"SQL Server (MSSQLSERVER) service on Local Computer Started and then Stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service."



I can't wait until I know how to code ASP.NET
 
Old August 16th, 2006, 12:36 PM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello wyx!

My config is the same: IIS v5.1 on XP with SP2, SQL Server 2005.

I had gotten the same message (with error code 26), but after launching the service SQL Server Browser, I started to get error code 40 when requesting the URL http://localhost/WroxUnited.

Besides, I am still unable to start SQL Server service. :-(
(Do I need it, anyway?)

Is there anyone here who knows what we should know to solve this problem?



 
Old August 17th, 2006, 02:43 AM
wyx wyx is offline
Registered User
 
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wyx
Default

Hi, yeah its fun isn't it? :D
Anyway I spoke to a tutor at my uni and he recommended to uninstall SQL server and to install express instead.
I will let you know what the outcome of that will be.. .



I can't wait until I know how to code ASP.NET
 
Old August 19th, 2006, 09:05 PM
wyx wyx is offline
Registered User
 
Join Date: Aug 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to wyx
Default

I changed the installation from SQL server 2005 to SQL server express and now it works fine!

I can't wait until I know how to code ASP.NET





Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrox United issues shanebbb BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 December 2nd, 2008 10:44 AM
Wrox United not working chris31martin BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 2 July 16th, 2008 09:00 AM
Help!! Page 664 - Wrox United Installation AndiTaylor BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 2 March 7th, 2006 09:15 AM
Wrox United Installation Problem bobbaird BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 6 January 19th, 2006 06:56 AM
Wrox United chapter 4 diango BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 4 December 29th, 2005 12:47 PM





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