Tuesday, October 13, 2015

Installing Reporting Services

The second time I've had to install Reporting Services I have decided to create a blog. If I were smarter I would have done it the first time.

We have a curious situation where we have Reporting Services partially installed. Perhaps it was installed for an earlier version of SQL Server but not upgraded so now when I run SQL Server xxxx Reporting Services Configuration Manager it cannot find an instance and the screen looks like this...


Follow these steps.

  1. Insert your SQL Server installation DVD and when SQL Server Installation Center pops up click on "Installation" on the left and then "New SQL Server stand-alone installation or add features to an existing installation" on the right.
  2. Click [Next >] in the wizard until you get to Installation Type.
  3. Select the "Add features to an existing instance" radio button and select the instance. Click [Next >]
  4. Check the "Reporting Services - Native" checkbox (unless you wanted sharepoint). Click [Next >] until you get to the [Install] option
  5. Click [Install]. Have a cup of tea and read the newspaper. Click [Close]
Configure your new Reporting Service

  1. Run Reporting Services Configuration Manager. The Report Server Instance should now be populated
  2. Click [Connect]
  3. Click Service Account on the left. The default service account is ReportServer. This is good.
  4. Click Web Service URL on the left. The default Virtual Directory is ReportServer. This is good. Click [Apply]
  5. Click Database on the left. There is no default database so click [Change Database]
     - You will probably want to create a new report server database. Click [Next]
     - Enter the server name and authentication used to create the new databases. I default to Current User - integrated security. Click [Next] and [Finish]
  6. Click Report Manager URL on the left. The default virtual directory is "Reports". This is good. Click [Apply]
  7. That's all you have to do. You can exit the application now.
Now go to my previous blog on enabling non-administrator access to a new instance of reporting services at http://wpfthoughts.blogspot.com/2015/05/running-report-manager-on-newly.html

No comments:

Post a Comment