Category: SQL

How To: Stop SQL Server Reporting Services from using Port 80 by default

How To: Stop SQL Server Reporting Services from using Port 80 by default

Problem

SQL Server Reporting Services uses port 80 by default on any server it’s installed on.

This can be rather annoying since SQL is quite often used in conjunction with other web services or applications that also use the default http port 80.

Solution

At first thought I thought ah great time for a google, but its actually a surprisingly easy process:

  • Log on to the server that hosts SQL Reporting Services.
  • Navigate to Start > Programs > SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager
  • Connect to the SQL instance in question (usually your local server)
  • Go to the “Web Service URL” section
  • Change the TCP port to an open port other than port 80 (I changed mine to 8080) and hit “Apply”
  • Go to the “Report Manager URL” section
  • Click “Advanced”
  • Click the entry with a TCP port of 80 and then click the “Edit” button.
  • Change the “TCP Port” entry to the same thing you changed it to in the “Web Service URL” section previously and Click “OK”.
  • Click “OK” again.