MS SQL Connection to PHP

[Jerome_3]

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.

[urtrivedi]

Where is your code, and what error you get while running your script?

What is prob you are having..?? Atleast describe the prob so that we can help better

[andrevanzuydam]

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.

Below a code snippet for native drivers.

$connectionInfo["UID"] = $username;
$connectionInfo["PWD"] = $password;
$connectionInfo["Database"] = "TESTDB";

$this->dbh = @sqlsrv_connect(  "127.0.0.1\SQLEXPRESS", $connectionInfo );

And you can download the drivers here

Click Here

[Jerome_3]

I use MS SQL Server 2005 Enterprise edition and PHP 5.4.

[pritaeas]

Where is your code, and what error you get while running your script?

In addition to this (you still haven't answered), what exactly is your setup?

[Jerome_3]

I run a WAMP in my PC(host-Win 7) and run the SQL Server in a virtual machine(Win Server 2003).

[pritaeas]

Did you set SQL Server to accept remote connections? Since the VM is a different machine PHP can't connect to localhost.

[Jerome_3]

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.