Search This Blog

Sunday, June 7, 2015

Add Reporting Services to an existing SQL Server 2005 instance

navigate to Add and Remove Programs on the Control Panel from your computer's Start menu.  Once the list of installed programs populates, locate Microsoft SQL Server 2005 and click Change. 
Select the instance you're going to modify and select Database Engine.  The example below presents a server that has only a single, default instance of SQL Server 2005 installed.  As you can see, you would use this same process to make changes to any installed SQL Server 2005 component, be it Database, Integration, or Notification Services.  You can also make changes to the Workstation Components from Add/Remove Programs in the Control Panel.


To install the new component click on "To install a new component, click here". You'll be prompted for the location of the setup.exe file that corresponds to your installation media.  Browse or enter the location of the setup.exe file and click OK.


This point in the process will begin to look familiar.  Accept the Software License Terms and click Next.  Setup.exe will install setup component files, perform system checks and launch the installation wizard.  This is identical to a simultaneous installation of Microsoft SQL 2005 Database Services and Microsoft SQL 2005 Reporting Services.  If warnings or errors are discovered at this point you may need to quit the installation, resolve the issues, and restart the installation from the beginning.








Select Reporting Services from the listing of components available for installation or upgrading.  Similarly, you can also install or upgrade other components at this time.


Select the instance for the installation.  In the example below, I am installing a default instance of Microsoft SQL  2005 Reporting Services.


As is the case with a side-by-side installation of Database Services and Reporting Services, you'll now be prompted for the account you wish to run Reporting Services under.  This decision depends upon how your environment is set up.  Here are some recommendations for service account assignments.


At this point you've supplied all the information that the setup program needs to perform the installation on the existing Microsoft SQL Server 2005 instance.  You will not be able to configure Reporting Services at this time.  You will do so after the completion of the install via use of the Reporting Services Configuration Tool.  Click next to continue and then select Install to begin the physical installation process.






You've now successfully installed Microsoft SQL Server 2005 Reporting Services on the same physical server as an existing instance of Microsoft SQL Server 2005 Database Services.  If you've been keeping up with your service pack installations, you'll need to patch Reporting Services to correctly match your other SQL Server 2005 components before configuring SQL Reporting Services.

No comments:

Post a Comment