Provider: SQL Network Interfaces, Error: 26

Hello i am writing a console application . I am using VS 05 professional & Sql server express.

Here is the code with no syntatical errors:


using System;

using System.Data;

using System.Data.SqlClient;



namespace Chapter6

{

class CallSp1

{

static void Main()

{

// create connection

SqlConnection conn = new SqlConnection

(@"server = .centrinosqlexpress; integrated security = true;

database = northwind");

try

{

// open connection

conn.Open();

// create command

SqlCommand cmd = conn.CreateCommand();// specify stored procedure to execute

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "sp_select_employees_details";

// execute command

SqlDataReader rdr = cmd.ExecuteReader();

// process the result set

while (rdr.Read())

{

Console.WriteLine("{0} {1} {2}",rdr[0].ToString().PadRight(5),rdr[1].ToString(),rdr[2].ToString());

}

rdr.Close();

}

catch (SqlException ex)

{

Console.WriteLine(ex.ToString());

}

finally

{

conn.Close();

}

}

}

}



The error i get in the dos window is:


Error: System.Data.SqlClient.SqlException: An error has occurred while establish
ing a connection to the server. When connecting to SQL Server 2005, this failur
e 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 L
ocating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boole
an& failoverDemandDone, String host, String failoverPartner, String protocol, Sq
lInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean
trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean
aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword, Bool
ean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdent
ity identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning
Object)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ownin
gObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Chapter10.ConnectionSql.Main(String[] args) in D:PROG_DEVVb.NET_devCons
oleAppconnectVerifyAppconnectVerifyAppProgram.cs:line 18
Connection closed.

I have enabled everything in SQL server config manager.

I still get the error!

Can anybody help

Gino