Providing IP Address for Reporting Services
Use
With Microsoft SQL 2008, and later, installing a specific website for reporting is not recommended because Reporting Services does not use it.
If you have a website, do not use its name in Reporting Services configuration.
In environments with several customer systems (ASP), create an SQL instance for each customer and configure Reporting Services in that instance.
Procedure
Configuring Reporting Services requires an IP address, and you can use either the hardware IP address of the server, or if you can create a virtual unit with nothing else but the IP address. If you use the server hardware IP address, and the server fails, reporting fails as well, but with a VU with instances on more than one server, high availability can be provided for reporting as well.
To do the latter:
-
Right-click Virtual Units and choose Add Virtual Unit, then choose the base installation from the list and the template Virtual Unit with Access Point. Enter an appropriate name, for example ACME_Reporting and the IP address.
-
To make an instance of the virtual unit on a node, right-click Instances under the VU you just created, and choose Add Instance and one of the nodes from the list.
-
To apply changes, right-click the virtual unit instance under the HAC node and choose .
-
To start the virtual unit, choose and Deployment Mode. Make sure that the VU is active (green triangle appears).