note 76168 deleted from ref.mssql by cmb

Note Submitter: post at wmm dot no ---- 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!