Posted by Michael Sims on 01/13/05 17:32

Craig Donnelly wrote:
> On the page where I connect to the MSSQL server I get the following
> error:
>
> Warning: mssql_connect() [function.mssql-connect]: Unable to connect
> to server: 172.16.xx.xxx in
> /var/ftpusers/tarot/tarot/admin/sqltest.php on line 4

A couple of things to try:

(1) Try defining a TDSDUMP file before the connection attempt and see if it provides
any hints as to why it failed. I normally do this via:

putenv("TDSDUMP=/tmp/tdsdump");

before the connection attempt. Make sure to remove this after you're done testing,
this file can get very big very quickly.

(2) Install Sqsh (http://www.sqsh.org/) and see if you can connect with it. If not,
it may give you more information on the connection failure than PHP does (just
guessing here)...

HTH

[Back to original message]