Installing Microsoft SQL Server 2008 Reporting Services

Complete the steps described in this section to install the Microsoft SQL 2008 Report Server and integrate it with Report Manager.

Before you can install the Microsoft SQL 2008 Report Server, ensure that you have the required software described in Microsoft SQL 2008 Report Server Software Requirements.

If you are installing the Microsoft SQL 2008 Report Server on a Windows 2003 Server, you must install the Windows 2003 Hotfix. For instructions on how to install the Hotfix, see Installing the Windows 2003 Hotfix for the Windows 2003 Server.

After you run the Windows 2003 Hotfix, you can install the Microsoft SQL 2008 Report Server. For instructions, see Installing the Microsoft SQL 2008 Report Server.

After you install Microsoft SQL 2008 Report Server, navigate to the Microsoft SQL 2008 Reporting Servers Configuration Manager and complete the necessary steps. For instructions on how to work with the Configuration Manager, see Opening the Microsoft SQL 2008 Reporting Servers Configuration Manager. Next, test the report service. For instructions on how to test the report service, see Testing the Report Service. Finally, set the server authentication mode. For instructions on how to set the server authentication mode, see Setting the Authentication Mode on the Server.

Topics

Installing the Windows 2003 Hotfix for the Windows 2003 Server

If you are installing the Microsoft SQL 2008 Report Server on a Windows 2003 Server, you must install the Windows 2003 Hotfix.

To install the Windows 2003 hotfix

  1. Navigate to the Software Update Installation Wizard. Click Next.

  2. Read and accept the License Agreement. Click Next.

    A Setup dialog displays, informing you that certain services must be stopped and restarted.

  3. Click Continue.

    The Installation Wizard completes.

  4. Click Finish.

    A dialog displays to inform you that you must reboot Windows.

  5. Click OK and then restart your computer and run the SQL Server 2008 setup.

Installing the Microsoft SQL 2008 Report Server

For any steps below that have no description, accept the default settings.

To install the Microsoft SQL 2008 Report Server

  1. Click New SQL Server stand-alone installation or add features to an existing installation.

    The Setup Support Rules run.

  2. When the Setup Support Rules finish running, click OK.

  3. If you have a license key, select Enter the product key then enter the key.

  4. Click Next.

  5. Read and accept the License Terms. Click Next.

  6. Click Install.

  7. When the Setup Support Rules finish running, click Next.

  8. Select the features to install. Click Next.

  9. Enter the SQL Server name and instance ID. Click Next.

  10. Review the Disk Space Summary. Click Next.

  11. Specify the configuration. Click Next.

  12. Select the Windows authentication mode.

  13. Click Add Current User.

  14. Click Next.

  15. Specify Analysis Services administrators and data directories.

  16. Click Add Current User.

  17. Click Next.

  18. Select the first option.

  19. Click Next.

    The Error and Usage Reporting window displays.

  20. Clear all options on this page. Click Next.

  21. When the Installation Rules complete running, click Next.

    The Ready to Install window displays.

  22. Click Install.

  23. When the process is complete, click Next.

  24. Click Close.

Opening the Microsoft SQL 2008 Reporting Servers Configuration Manager

The images below highlight important steps when opening and using the Microsoft SQL 2008 Report Servers Configuration Manager, including how to update the ICP port and how to obtain the Report Manager and web service URLs.

To open the Microsoft SQL 2008 Reporting Services Configuration Manager

  1. Navigate to Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > Reporting Services Configuration Manager.

  2. Configure the URL used to access the Report Server.

Testing the Report Service

After you obtain the Report Manager and web service URLs, navigate to each URL in a browser window. If the URLs do not open successfully, update the server name to IP in the URL and try again.

For example,

Report Manager URL: http://10.50.70.75/Reports_MSSQLSERVER2008/Pages/Folder.aspx

Web Service URL: http://10.50.70.75/ReportServer_MSSQLSERVER2008

Setting the Authentication Mode on the Server

After you install Microsoft SQL 2008 Report Server, use the Reporting Service Configuration to initialize the Microsoft SQL 2008 Report Server.

This section describes how to configure Basic and Anonymous authentication for Microsoft SQL Reports.

By default, the Microsoft SQL 2008 Report Server requests Specify Negotiate or NTLM authentication. Below is an example of the default authentication information found in the rsreportserver.config:

<Authentication> 
     <AuthenticationTypes> 
          <RSWindowsNegotiate/> 
          <RSWindowsNTLM/> 
     </AuthenticationTypes> 
     <EnableAuthPersistence>true</EnableAuthPersistence> 
</Authentication> 

Topics

Enabling NTLM Protocol for IIS 6.0

If your agency uses IIS Manager 6.0, you must disable the Negotiate process to force IIS to use the NTLM protocol for authentication.

Run the following command to verify the NTLM protocol is in use:

cscript C:\inetpub\adminscripts\adsutil.vbs get W3SVC/1/Root/MyApp /NTAuthenticationProviders

In the syntax sample, replace MyApp in the command with your actual web application name. For example, ReportServiceFacade or Myreports.

  • If the result is “NTAuthenticationProviders: (STRING) ‘NTLM’ then the NTLM protocol is in use.

  • If the result is “The parameter ‘NTAuthenticationProviders’ is not set at this node," the NTLM protocol is not in use. You need to run the following command to disable the Negotiate process.

    cscript C:\inetpub\adminscripts\adsutil.vbs //nologo SET W3SVC/1/Root/MyApp/NTAuthenticationProviders NTLM

For more information about how to configure IIS to support both the Kerberos protocol and the NTLM protocol for authentication, go to Microsoft's support article on the subject.

Setting Up Basic Authentication in Report Manager

You can set up Basic authentication for the Microsoft SQL 2008 Report Server.

To set up basic authentication in Report Manager

  1. Change the authentication mode in the rsreportserver.config to “RSWindowsBasic” on report server.

    <Authentication> 
         <AuthenticationTypes> 
              <RSWindowsBasic/> 
         </AuthenticationTypes> 
         <EnableAuthPersistence>true</EnableAuthPersistence> 
    </Authentication> 
  2. Enter the user name and password on the Report Service Form in Civic Platform.

Setting Up Anonymous Access

You can modify the Microsoft SQL 2008 configuration to support Anonymous access.

To set up Anonymous access

  1. Change the authentication mode in rsreportserver.config to “Custom”:

    <Authentication> 
         <AuthenticationTypes> 
              <Custom/> 
         </AuthenticationTypes> 
         <EnableAuthPersistence>true</EnableAuthPersistence> 
    </Authentication> 
    File Path: D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2008\Reporting Services\ReportServerrsreportserver.config 
  2. Change the authentication mode in the report server and report manager web.config file to None.

    Set the impersonation property to “false”:

    <authentication mode=“None”/> 
    <identity impersonate=“false”/> 
    (original: <authentication mode=“Windows”/> <identity impersonate=“true”/> 
  3. Copy Microsoft.Samples.ReportingServices.AnonymousSecurity.dll into reportserver directory (e.g., D:\Program Files\Microsoft SQL Server\MSRS 10.MSSQLSERVER2008\Reporting Services\ReportServer\bin)

    The file path is C:\Accela\av.deploy\dist\reportadaptor. If you have trouble locating this file, note that the C:\Accela portion of the navigation path varies depending on the location of the installation. The av.deploy\dist\reportadapter must always exist in whatever folder you selected for the installation.

  4. Add extension to rsreportserver.config file:

    <Security> 
     <Extension Name=“None” Type=“Microsoft.Samples.ReportingServices.AnonymouSecurity.Authorization, Microsoft.Sample.ReportingServices.AnonymousSecurity”/> 
    </Security> 
    <Authentication> 
     <Extension Name=“None” Type=“Microsoft.Samples.ReportingServices.AnonymousSecurity.AuthenticationExtension, Microsoft.Samples.ReportingServices.AnonymousSecurity”/> 
    </Authentication> 
  5. Configure code access security. Add the following information into rssrvpolicy.config. In this example, the project has no strong name, so we are using url membership:

    <CodeGroup 
              class=“UnionCodeGroup” 
              version=“1” 
              PermissionSetName=“FullTrust” 
              Name=“Private_assembly” 
              Description=“This code group grants custom code full trust.”> 
              <IMembership Condition 
                   class=“UrlMembsershipCondition” 
                   version=“1” 
                   Url=“D:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2008\Reporting Services\ReportServer\bin\MicrosoftSamples.ReportingServices.Anonymoussecurity.dll”/> 
    </CodeGroup> 
  6. Restart the report server to use Anonymous authentication. Navigate to Microsoft SQL Server 2008 > Configuration Tools > Report Services Configuration Manager

  7. Open the URL below using a browser on a separate machine:

    http://10.50.70.75/Reports_MSSQLSERVER2008

  8. Copy the ReportFacade.aspx and the ReportFacade.aspx.cs to the reportManager folder (e.g., D:\Program Files\Microsoft SQL Server\MSRS10MSSQLSERVER2008\Reporting Services\ReportManager). Add the following information to the web.config file:

    <appSettings> 
              <add key=“URL” 
              value=“http://10.50.70.75/ReportServer_MSSQLSERVER2008/ReportService2005.asmx”/> 
              <add key=“reportFolders” value=”/”/> 
    </appSettings> 
    Note:

    The “http://10.50.70.75/ReportServer_MSSQLSERVER2008” portion of the URL represents the report service. The default file path is C:\Accela\av.deploy\dist\reportadaptor

  9. Ensure that you enter these URLs in the corresponding Civic Platform Report Service Form fields:

    Report Name List URL http://10.50.70.75/Reports_MSSQLSERVER2008/ReportFacade.aspx
    Report Service URL http://10.50.70.75/ReportServer_MSSQLSERVER2008
    Report Manager http://10.50.70.75/Reports_MSSQLSERVER2008