error in connection

Hi

i am trying to connect my application with SQL SERVER. but

it gives error as below.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Please reply me soon.

Best regards,
ASIFU have to enable remote connections in SQL 2005 if u want to connect from remote clients.

1) Open SQL 2005 Surface Area configuration-->Surface Area configuration for Services and connections -->Database Engine-->Remote Connections-->Enable Local and remote connections.

2) Enable the protocol from SQl Server Configuration manager which u are using(in ur case 'Named Pipes').
To do that,
SQl Server Configuration manager -->SQL server 2005 Network Configuration-->Protocols for SQl2005-->Enabe Named Pipes.