Page 1 of 1

Help with mssql_connect and Windows Server 2003

Posted: Tue May 02, 2006 7:26 am
by spideybum
Someone please help me out. I am trying to connect from a PHP file on a Windows Server 2000 machine to an SQL database on a Windows Server 2003 machine. I keep getting a

mssql_connect(): Unable to connect to server: <servername> in <phpfilename> on line <linenumber>

error. The SQL has been recently moved to the 2003 server from a 2000 server, and from what I've read elsewhere, that is the issue. I have searched a few sites that had supposed workarounds. I replaced the ntwdblib.dll file on the server that has PHP with a newer one (and restarted the server), but that didn't make a difference. What can I do?

Doug Applegate

Posted: Tue May 02, 2006 8:19 am
by neophyte
Is the firewall open on the right port?

Posted: Tue May 02, 2006 10:54 am
by spideybum
We don't go through a firewall from internal computer to internal computer.

Posted: Tue May 02, 2006 11:15 am
by Burrito
can you connect to the sql server from the web server via a different method (other than php)?

you might try that to ensure that the new sql server isn't blocking access based on IP or some such....