I have a legacy PHP 4 box that runs a lot of PHP applications developed over the years. Most of these apps were designed to connect to a MSSQL 2000 database and it worked flawlessly. We recently upgraded our database server to MSSQL 2005. While I was able to configure the web server (BSD) to connect to the new database with no problems, I cannot get PHPED to connect at all. I have tried using PHP 4.x, 5, and 5.3 but nothing works.

I did notice that there is a driver from MS out, but I do not want (or have time) to reconfigure all these applications to a new driver and since the web server is a BSD machine, this is a not a valid proposition.

What is interesting is that I can connect to, and see all the databases and tables, using the DB Client. But, I believe that this is using the dbu_factory() object, something that was not available during the initial development in PHP4. Converting to this format is unrealistic at this time, maybe when I have time down the road some.

There is some discussion about the ntwdblid.dll in the system32 folder, but I am not sure what to make of this. Can anyone please help??? I really need to get the PHPED to connect to the database and soon.

to get it working, you have to install mssql client tools, and TCP handler for server and client, set port to 1433 in the server protocol handler properties, and enable all in the firewall.