mssql_connect() not connecting

[knowram]

I have having trouble connecting to a MSSQL server. I am trying to connect from a test box. I can ping the MSSQL server from my test box but can't connect. How do I figure out why its not connecting? I copied the exact code from my production box so I know the username and password is correct. Is there someway to get some more details?

 

Thanks for the help.

 

 

 

[knowram]

More info on the problem.

 

 

There are 5 different servers involved

Production web server / SQL server (virtual box)

Old production web server (to be decommissioned)

Test web server / Mysql server

1 SQL server

 

 

From the production box I can connect to the MySQL database and both MSSQL databases. From the old production box I can also connect to the MySQL and both MsSQL databases. But from the test box I can only connect to the MySQL server on its self.

 

If I look at the log from my router/firewall that is between the test server and everything else I don't even see an attempt to connect. However when I use SQL Server Management Studio Express I do see the connection being established. Which leads me to believe that I am missing something in the configuration of my test server but I don't know what.

 

Thanks again for the help