Console Data Connection Problem: Sql Server Doesn't Allow Remote Connections

Hello

 I have VS 05 professional connected to SQL server express. I am trying to make a simple console  connection  to northwind database  to show the results of a simple procedure.

The code is as follows:

 

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 executecmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "sp_select_employees_details";

// execute command

SqlDataReader rdr = cmd.ExecuteReader();

// process the result setwhile (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 build indicates no errors but the dos output gives the following error:

 

 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.
Press any key to continue . . .


BOTH THE CLENT AND DATABASE IS ON SAME MACHINE.

THE DATABSE IS centrinosqlexpress as shown in the code.

I