Apache HTTP Server error: ‘An attempt was made to access a socket in a way forbidden by it’s access permissions. AH00072: make_sock: could not bind to address 0.0.0.0:80. AH00451: no listening sockets available, shutting down.’

I discovered that this error was caused by ‘SQL Server Express 2008 Reporting Services’ also using TCP Port 80. Apache HTTP Server also uses TCP Port 80 by default.

Fix: Reconfigure either your SQL Server Reporting Services or the Apache HTTP Server to use another port other than TCP Port 80.
Or you can temporarily stop the SQL Server Reporting Services service in order to continue using your Apache HTTP Server.

SQL Server Reporting Services
Note that the SSRS service can remain active even if you uninstall SQL Server. To stop the service:

  1. Open SQL Server Configuration Manager.
  2. Select “SQL Server Services” in the left-hand pane.
  3. Double-click “SQL Server Reporting Services”.
  4. Hit Stop.
  5. Switch to the Service tab and set the Start Mode to “Manual”.

    If this doesn’t fix your issue then it could be there’s another Windows program using TCP Port 80. You can find out by entering the following on the Windows command line:

    netstat -ao

    The active TCP addresses and ports will be listed. Look for the line where Local Address is “0.0.0.0:80″ and make note of the value in the PID column.

    Now start Task Manager. Navigate to the ‘Processes’ tab. If there’s no ‘PID’ column, click View > Select Columns… to ensure “PID (Process Identifier)” is checked. You can now locate the PID you made a note of above. The ‘Description’ and ‘Image Path’ properties should identify which application is using the port.

    Task Manager can allow you to kill the process, but be very cautious about doing that if it’s a System Process, such as “NT Kernel & System”.

Advertisements

Trying to install reporting services for Microsoft SQL server on Windows 7, but the option to install reporting services is disabled in the setup?

Before you install SQL Server 2005 Reporting Services, you must enable Microsoft ASP.NET and Microsoft Internet Information Services (IIS). To enable ASP.NET and IIS, follow these steps:

  1. In Control Panel, click Programs, and then double-click Programs and Features.
  2. In the User Account Control dialog box, click Continue.
  3. Click Turn Windows features on or off.
  4. In the Windows Features dialog box, expand Internet Information Services, expand Web Management Tools, expand IIS 6 Management Compatibility, and then click to select the following check boxes:
    • IIS 6 WMI Compatibility
    • IIS Metabase and IIS 6 configuration compatibility
  5. Expand World Wide Web Services, expand Application Development Features, and then click to select the following check boxes:
    • ASP.NET
    • ISAPI Extensions
    • ISAPI Filters
  6. Expand Common HTTP Features, and then click to select the following check boxes:
    • Default Document
    • Directory Browsing
    • HTTP Errors
    • HTTP Redirection
    • Static Content
  7. Expand Security, and then click to select the Windows Authentication check box.

Note If you do not enable all these features, the Reporting Services option does not appear in the Feature Selection dialog box of the SQL Server Setup program.

support.microsoft.com – kb934164