 |
(Tim Ford) Servers don't last forever. With Microsoft SQL Server 2005 going on three years many of us are in the process of acquiring new hardware and getting new instances up and running. In our company this means a shuffle of some of our Database Services, Reporting Services, and Analysis Services installs in order to load balance our SQL environment correctly. Many DBAs may not be aware that they do not need to install Reporting Services at the same time that Microsoft SQL Server 2005 Database Services are being installed on a server; for that matter, you don't need to install Reporting Services on a server that is running Database Services. Reporting Services does not require additional licensing charges if installed on an existing properly-licensed Database Services instance however. There are some subtle differences between installing SQL Server Reporting Services 2005 as part of a fresh SQL Server 2005 Database Services installation, versus installation on an existing instance of SQL Server 2005. In this tip we look at the process of installing Reporting Services on a server that is already running Database Services. |
