Hello -
Bit of a problem with PHP connecting to MSSQL. I've read as many articles as I can and still don't have a fix, so posting in the hope that someone can help.
PHP box (called Hill):
Windows server 2003
MDAC installed
SQL server client tools installed
PHP 5.0.3 in c:\php\503 as ISAPI
php_mssql.dll copied to c:\windows\system32
ntwdblib.dll copied to c:\windows\system32 (from SQL box)
IIS 6.0
SQL box (called Voltaire):
Windows server 2003
SQL server 2000
This is a copy of an installation we already have to provide redundancy. I've used the PHP ini file from this other server (called Babbage).
I've added the ISAPI extensions to IIS and all; PHP works fine (as phpinfo() tells me).
I can connect to the MSSQL server from the other machine using the same page (so Babbage can connect to Voltaire with precisely the same code).
I can telnet from Hill to Voltaire on port 1433 and it's fine.
I can set up a DSN on Hill which will successfully query Voltaire with the same username and password.
So: something wrong with permissions/access within PHP.
Could someone please shed some light on this, which has two of us utterly stumped? I would also say that we managed to install PHP just fine on Babbage within about six minutes, so we're mightily annoyed it's taken us three hours so far...
Many thanks,
Hamish
