Sql error 40 on client machine

[rajanji]

I created a vb.net app with sql server as Backend and when trying to install the app alongwith the sql server on client machine, the sql server is giving the error : something like this : Named Pipes Provider, error: 40 - Could not open a connection to SQL Server .........

I am using RED GATE SQL PACKAGER

[Delerna]

Are you connecting to SQL server via an ODBC data source created on the client machine?

If so
Check the ODBC data source on the client PC.
It sounds like the "network library" option under "client configuration"
is set to "named pipes" instead of "TCP/IP".

When done "next" through to the last panel then "Finish" and make sure the ODBC "test data source" tests OK.

Hope that helps