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

.. .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

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?

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

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