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.
- 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.
- Click [Next >] in the wizard until you get to Installation Type.
- Select the "Add features to an existing instance" radio button and select the instance. Click [Next >]
- Check the "Reporting Services - Native" checkbox (unless you wanted sharepoint). Click [Next >] until you get to the [Install] option
- Click [Install]. Have a cup of tea and read the newspaper. Click [Close]
Configure your new Reporting Service
- Run Reporting Services Configuration Manager. The Report Server Instance should now be populated
- Click [Connect]
- Click Service Account on the left. The default service account is ReportServer. This is good.
- Click Web Service URL on the left. The default Virtual Directory is ReportServer. This is good. Click [Apply]
- 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] - Click Report Manager URL on the left. The default virtual directory is "Reports". This is good. Click [Apply]
- That's all you have to do. You can exit the application now.
No comments:
Post a Comment