SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

[zhshqzyc]

Hi, I have installed SQL Server 2005 and Visual Studio 2005 in my machine.

I got an error when I tried an example.

"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 followed many advice online and did the following but still wrong.

Enable networking protocols during managment configuation.
add port 1343 on firewall or turn off the firewall.
make changes in web.confige as
<?xml version="1.0"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<configuration>

<appSettings/>

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=localhost\band;Initial Catalog=Players;User ID=test;Password=test"/>

<add name="SqlConnectionString" connectionString="Data Source=localhost\band;Initial Catalog=Players;User ID=test;Password=test"/>

<add name="OdbcConnectionString" connectionString="Driver={MySQL ODBC 3.51 Driver}; server=localhost;database=players;uid=test;pwd=test" />

<add name="OleDbConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\band\players.mdb" />

</connectionStrings>

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

<compilation debug="true"/>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="Windows"/>

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

-->

</system.web>

</configuration>


Thanks for your help.