[Resolved] PHP/IIS/MSSQL connection problems

has27

OK... several fruitless hours result in this post.

PHP5 (ISAPI not CGI), MSSQL v8, IIS 5.0 on Win2k.

We have two machines set up, a dev server and a live server. I've installed php in the same way on each server (using the auto installer, then changing via manual install to ISAPI (yes, I know it's convoluted, but that's how I did it on the dev and I wanted to replicate it on the live)).

Dev server can happily run php, connect to a MSSQL database on it, and do stuff.

Live server gives me 'unable to connect to server: localhost: 1433' errors.

I've tried changing my php script to connect as $server="live,1433" - interestingly, dev can connect to this and pull out info from live's sql database, but live can't connect to dev or itself.

I've put ntwdblib, php5ts and php_mssql dlls in winnt, winnt/system and winnt/system32, got the extensions in place, and am using the same php.ini file on each server.

If someone can throw some light on this, it'd be great. I'm beginning to tear my hair out. Cheers.

has27

A note to people who find themselves in the situation I was in earlier.

RTFM.

Ensure that MS SQL Client Tools is installed on your machine. (I was informed that it was already, which is why I didn't go down this route sooner.)

<ahem> Good day, ladies and gentlemen.