Showing posts with label port. Show all posts
Showing posts with label port. Show all posts

Wednesday, March 21, 2012

Reporting Services - Port Number

Hi,

I have managed to get reporting services working, my reports and reportserver sites are not under the default site but under a custom site i have created, this site has been configured for port 8089. Reporting services for the most part is working fine but several of the links and buttons which navigate to a different pages getting the port number 8089 added to the end of the link which is causing the page to not be found why are these being added and how can i stop this port from being added. If i remove the port number then the correct page is displayed.

The URL within the two config files associated with reporting services does not have the port number, i use ISA to redirect to the port 8089.

Thanks and Regards,

Hi,

Heres some info. i recieved:

Tips on Changing the port number:
Part 1: IIS Configuration
Note: IIS routes incoming URL requests to the appropriate place based upon matching the URL's Host (DNS Name or IP Address) and Port (defaults to 80) to the IIS Web Site whose identity matches or accepts these parameters of the URL. The IP address of the URL's Host, the Port, and the Host header value (when multiple Domain Names map to the same IP address / server) must match. The default configuration is for the default web site to accept all un-matched URLs requested on port 80.

A. Modifying the IIS Web Site Identity - Open the IIS Manager, select a web site object, and click Properties. The Web Site Identification is configured in the "Web Site" tab of the Web Site Properties dialog.
- If a server hosts more than one domain name then create a new web site specifying a host header that matches a domain name
- If a port besides 80 required in the URL then configure the TCP port(s) of the web site to match the port required. From a client, the URL will require the port to be specified as follows: http://host:port/path


B. Modifying the SQL Server Reporting Services - Report Manager URL / path and Report Server Web Service URL / Path. These are assumed to be "/Reports" and "/ReportServer" respectively, but they can be changed or even created manually.
- The Report manager always uses the Report Server Web Service, so if http://host:port/<report server> does not work then http://host:port/<report manager> will not work.
- The Report manager must be configured to reference the correct URL to the Report Server Web Service (see part 2 below).

- The following two web sites describe how to create or move these virtual directories:
KB Article 867872 You receive a 1603 error message or a 25619 error message when you try to install SQL Server 2000 Reporting Services
<http://support.microsoft.com/?id=867872>
Moving Reporting Services' Virtual Directories
<http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk>

Part 2: SQL Server Reporting Services Configuration
- The RsWebApplication.Config file in the ReportManager folder contains a Configuration\UI\ReportServerUrl tag whose value is the URL to the <report server> web site. This value needs to be configured to match the URL to the <report server> virtual directory specified above.


Also if you are doing port redirection in ISA, try turning this off after going through the above steps as the two may be conflicting with each other.

sql