Install Requirements
- The original Aspose installer
- 'Aspose.Words.ReportingServices 3.0.0.0.msi'
- The latest Aspose manual install files
- 'Aspose.Words.ReportingServices 3.4.0.0.zip'
- The Aspose license file for Aspose.Words Reporting Services
- 'Aspose.Words.Reporting.Services.lic'
- Make sure that external reporting is licensed for Manitou
Install Steps
Run the 3.0.0.0 Installer
- Open the installer labeled Aspose.Words.ReportingServices 3.0.0.0.msi.
- Select Next.
- Select the appropriate version of reporting services for the install and select Next.
- Set to install for Everyone and select Next.
- On the Confirm Installation page, select Next.
- Once the installation for Aspose Report Service is complete, select Close.
Updating to the latest version of Aspose 3.4.0.0
- Extract the contents of Aspose.Words.ReportingServices 3.4.0.0.zip into a new folder.
- Navigate to the Bin Folder that was just extracted.
- Open the corresponding SSRS folder.
- For example, if SQL Server 2008 is installed, open SSRS2008.
- Copy and paste the Aspose.Words.ReportingServices.dll from the SSRS folder over the current .dll in the folder of the ReportServer directory.
- SQL Server 2000 - The ReportServer directory is located at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Servcies\ReportServer\bin.
- SQL Server 2005 - The ReportServer directory is generally located at C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\bin, however MSSQL.1 may be listed as MSSQL.2 or MSSQL.3 depending on how many SQL Server configurations there are.
- SQL Server 2008 - The ReportServer directory is located at C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Report Server\bin.
Licensing Aspose for SQL Server Reporting Services
- Copy the file Aspose.Words.Reporting.Services.llc into the bin directory or Reporting Services. (see above for help on locating the bin directory)
- Remove any NTFS file permissions that may have been assigned to either the .lic (license) file or to the .dll that was previously placed within the bin directory.
Assigning Permissions to Administrative User for SQL Reporting
- Run Internet Browser as Administrator and browse to HTTP://<Machine Name>/Reports
- If the webpage does not exist or it does not load, navigate to the proper Reports directory or start the Reporting Services from the Reporting Services Confirmation Manager.
- Open Site Settings.
- Select Security.
- Select the New Role Assignment.
- Add the administrative Windows user (generally the user named Administrator).
- Select all the system roles listed and then press OK.
- Return Home by selecting Home (located at the top right of the webpage).
- Select Folder Settings.
- Select New Role Assignment and repeat steps 5 and 6 (more options will be available this time, still select all of them).
- HTTP://localhost/ and HTTP://<ServerName> must both be added as trusted Internet browser sites.
- The Web browser can now be closed.
Adding the Configuration into Manitou
- Open Supervisor Workstation and log in with the BOLD user.
- Go to Maintenance>Setup>Configuration.
- Under Report Server, add the following parameters:
- -uhttp://<Local Server>/reportserver/reportexecution2005.asmx
- -v<User Login>
- -w<User Password>
- -x<Domain for User> (must be included even if it is localhost)
NOTES:
- The user added here must be the same user authorized to access the reports in HTTP://<Machine Name>/Reports.
- The 2005 in reportexecution2005 will not change no matter which version of SQL that is running.
- Make sure that the path specified in reportexecution2005.asmx can be accessed in a web browser.
- Save the changes.
- Open the MSM if not already open and stop the Report Server.
- Once stopped, close and reopen the MSM so that the configuration refreshes.
- Start the Report Server so that the changes are applied.
