Microsoft SQL Server, Error: 233

Hi,
 
  I have Production server with ip address XXXX, test server with ip address YYYY which are hosted in same building where i am working. I am able to connect to both Prod and test server using SQL Management studio from my local machine. We have virtual machine hosted in SFO. I logged in to the SFO machine remotely and tried to connect to the same Prod and Test servers using Management studio. I am able to connect to test server. But I am not able to connect to Prod server.
I am able to ping both the server from command prompt from SFO machine.
I am getting the following exception "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
One more thing which I observed for both servers is
1) In SQL server configuration manager t ...