So I have been banging my head and scouring the internet for help with this and am coming up short.
I write internal php data management applications that run off a small local web server and interact with several different SQL databases.
In this instance I am running two php applications off of one machine. One of them connects fine to it's database using mssql_connect and PDO. A separate application running on the same web server attempts to connect to a different SQL database using the same means and fails. The second database is pingable and in house and i can remote to the machine and access the database via Microsoft SQL Server Management Studio. mssql_connect and PDO both fail and I can't figure out why. A different application can connect to a different SQL database just fine. This tells me that is must be something on the SQL server but the administrator ensures me they are identical configurations.
Any thoughts? Help please. I'm desperate. :'(
PHP Version 5.2.8
SQL Server 8.0.2039