MSSQL: logs/httpd.pid overwritten — Unclean shutdown of previous Apache run

1. Stop all WAMP services and the SQL Server (Express) service

2. Get ntwdblib.dll version 2000.80.194.0 (http://webzila.com/dll/1/ntwdblib.zip OR get a free copy of ntwdblib.dll by downloading MS SQL Server 2000 SP4 from Microsoft Website. It contains a copy of ntwdblib.dll version 2000.80.194.0 in the system directory). Copy and replace any other versions of this file to the following locations:

  • Your PHP binaries folder (ie C:\wamp\bin\php\php5.2.6)
  • Your Apache binaries folder (ie C:\wamp\bin\apache\apache2.2.8\bin)
  • Windows\System32\

3. Configure SQL Server to accept TCP connections and Named Pipes through the SQL server configuration manager (yes you will need the client tools installed).

4. Configure SQL Server for Mixed mode authentication and remember the password you set for sa

5. Start the SQL Server Service

6. Edit your php.ini and set the

mssql.secure_connection = On

7. Make sure your wamp folder has proper access rights (full control for ‘everyone’).

8. Start all services from the WAMP menu.

MSSQL: logs/httpd.pid overwritten — Unclean shutdown of previous Apache run

Leave a comment