Installing Microsoft SQL Server 2005 Reporting Services

Microsoft SQL 2005 Report Server integrates with Report Manager in Civic Platform. You must install this version of Microsoft SQL Reports on the report server before Civic Platform can use it. For installation steps, refer to the documentation that came with your report software.

To link Civic Platform and the Microsoft SQL Reporting Service, create a virtual directory with the Alias Name ReportServiceFacade. You can set this virtual directory to anonymous access or security access when Civic Platform accesses the reports. Configure both the anonymous access and security authentication options in Internet Information Services (IIS). If you use anonymous, the security for each report is controlled from the Civic Platform side. If you use authentication, the Microsoft SQL Reporting Service handles the security for each report. After you configure security, you can deploy the report service.

To link Civic Platform and Microsoft SQL Service

  1. Install and set up MS SQL Server 2005.

  2. Use the Computer Management console to create an administrative user account for the MS SQL Reporting Service to recognize Civic Platform.

    Note:

    If you are going to use anonymous access, then you must enter this User name and Password into the Civic Platform Service Request Form.

    Refer to the Report Manager chapter of the Accela Civic Platform Administrator Guide.

  3. Configure the report server to require authentication or enable anonymous access for the administrative user.

  4. Login to MS SQL Reporting Services Report Manager using URL http://localhost/Reports$SQL2005/Pages/Folder.aspx.

  5. Click the hyperlink Home in the top-right corner.

  6. Click the blue Properties tab.

  7. Click New Role Assignment.

  8. Enter the user/group name created in in the New Role Assignment page. Select appropriate roles for the user/group.

  9. Click OK.

  10. Configure the report server to enable either authentication or anonymous access for the administrative user created in . If it is a Windows 2000 server environment, select the allow IIS to control password option. Complete one of these options:

    • To require user authentication when Civic Platform accesses the MS SQL Reporting Service:

      1. Right-click Default Website and select Properties > Directory Security. In the Anonymous access and authentication control section, click Edit.

        The Authentication Methods window displays.

      2. Clear the Enable anonymous access option and select Basic authentication.

      3. Click OK.

    • To enable Civic Platform to anonymously access the MS SQL Reporting Service:

      1. Right-click Default Website and select Properties > Directory Security. In the Anonymous access and authentication control section, click Edit.

      2. Select the Enable anonymous access and Integrated Windows authentication options.

      3. Click Ok.

  11. Test to ensure the reporting service installation is successful. Run the URL on another machine, for example, http://selfhostaa/Reports$SQL2005/Pages/Folder.aspx.

To deploy the report service

  1. Locate the local path of the virtual directory. In IIS, right-click ReportServiceFacade, and click Properties.

    The ReportServiceFacade Properties window displays.

  2. Use Explorer to locate files C:\Accela\av.deploy\dist\reportadapter\mssql\reportservice and copy them into the Local Path. In the figure the Local Path is E:\MSSQLReportService.

    The C:\Accela path varies depending on the directory folder you select during Civic Platform installation process. The path of av.deploy\dist\reportadapter must always exist on the drive and folder you used for the installation.

  3. Modify the web.config file. Set the add node’s value property in section <appSettings> to the SQL Reporting Services URL.



  4. Open the IIS Administration console. Go to Default Website > New > Virtual Directory.

  5. Create a virtual directory under the Default Website node with an alias of ReportServiceFacade. Click Next.

  6. Specify the Website Directory as the actual directory that contains content.

  7. Specify the actual directory and then click OK.

  8. Click Next.

  9. Click Finish.

  10. Open the property window for the virtual directory of ReportServiceFacade.

  11. Select the Directory Security tab.

  12. In the section anonymous access and authorization control section, click Edit. Select anonymous access, then enter the anonymous user name and its password. If it is a Windows 2000 server environment, select allow ISS to control password.

  13. Test the site by right-clicking the page ReportFacade.aspx and click Browse.

    If ReportFacade.aspx opens successfully, it displays as shown in this example:



    1. If ReportFacade.aspx fails to open, set <identity impersonate=“True”> in section <authentication mode= “Windows” /> in the web.config file, and then restart the application.

      <authentication mode=“Windows”/> 
      <identity impersonate=“True”/>