SQL NATIVE CLIENT SHARED MEMORY PROVIDER: NO PROCESS IS ON THE OTHER END OF THE PIPE

Hello,

I have an application that requires an database to be installed on the same machine as a backend database.  I downloaded SQL Server 2005 as well as the SQL SERVER TOOLS 5.  

Since the application as well as the sql are on the same machine I am receiving error message as follows:

[SQL Native Client]Shared Memory Provider: No process is on the other end of the Pipe. [SQL Native Client] Communication Link Failure.

At the bottom right side I don't the icon that the SQL Server is running however within the services it is running.

No client will be connected to this server as it is purely a lab environment.

Could you also tell me how to test the ODBC as well as how to test SQL Server?

Thank you.