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:
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
- Started the SQL Server Browser
- 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
I can't wait until I know how to code ASP.NET