How to connect to Microsoft Sql Server 2005 with PHP

[eluser]timpisti[/eluser]
Hello.

You may try to this

1: Check the connection with another software in windows (like mssql management studio)
2: In most cases, the windows autentication does'nt work thru PHP.
a: Check the PHP.ini MSSQL values. You may find a point similar to: 'enable windows autentication...', or something like that. Enable it.
b: Try this
mssql_connect('SQL5.ZNETINDIA.NET') or die(mssql_get_last_message());
If you connect with windows autentication does'nt need the user and pass.

3: Create a normal SQL user - this is worked for me, and a lot of windows IT wizard can't find ANY solution to demonstrate a working MSSQL setup in this environment:

ISA server auth - Windows 2008 server - MSSQL 2008 - IIS 7.0 - PHP 5.2
Its only worked with SQL user. Not the windows authenticated.