I have read from different forums, PHP website and Microsoft website how to connect PHP to MS SQL Server but the provided solutions didn't worked for me. If you could help me in this would be greatly appreciated.
The first issue on connecting to a MSSQL database probably pertains to whether you are using and express version or not. The other problem will relate to which PHP drivers you have decided to use, there is a native Microsoft driver and the default PHP driver. I have discovered that it isquite a mission to get the PHP configuration correct.
Thanks for replies guys, I was able to figure out the problem. I was using SQL Authentication in my PHP code but db server is using Windows Authentication. To correct the problem, I change server authentication then run the code again and this time it worked.