note 76168 modified in ref.mssql by danbrown

Having trouble connecting to a MS SQL Server from Windows server with Apache + PHP, or some other server-configuration? Too old MDAC in Windows may be your problem. Here is a summary for those working on Windows-plattform: 1. Update your Microsoft MDAC (search for Microsoft Data Access Components on www.microsoft.com). Some older Microsoft servers (or workstations) contain old and crappy MDAC-installations. This solved our problem after two days of work.. 2. Make sure ntwdblib.dll (version 8.00.194) is in the correct place(s). I only placed it in Apache bin directory and it worked fine, but apparently some Microsoft installations need it in several locations.. this is indeed very confusing! 3. You may have to set mssql.secure_connection = off in your php.ini 4. Make sure needed ports are configured in your firewall. Hope this helps - now, back to coffee! --was-- Having trouble connecting to a MS SQL Server from Windows server with Apache + PHP, or some other server-configuration? As Tom at mazzotta dot com wrote further down on this page; too old MDAC in Windows may be your problem. Here is a summary for those working on Windows-plattform: 1. Update your Microsoft MDAC (search for Microsoft Data Access Components on www.microsoft.com). Some older Microsoft servers (or workstations) contain old and crappy MDAC-installations. This solved our problem after two days of work.. 2. Make sure ntwdblib.dll (version 8.00.194) is in the correct place(s). I only placed it in Apache bin directory and it worked fine, but apparently some Microsoft installations need it in several locations.. this is indeed very confusing! 3. You may have to set mssql.secure_connection = off in your php.ini 4. Make sure needed ports are configured in your firewall. Hope this helps - now, back to coffee! http://php.net/manual/en/ref.mssql.php