Installing Microsoft SQL Server 2012 Reporting Services

Follow the instructions in this section to install and integrate Microsoft SQL Server 2012 Reporting Services with Report Manager in Civic Platform.

Topics

Prerequisites

You must have functioning instances of the following software prior to installing the integration:

  • Microsoft .NET Framework 3.5 SP1 or higher. Download here.

  • Microsoft Visual Studio 2010 Service Pack 1. Download here.

Installing Microsoft SQL Server 2012 Reporting Services

To install Microsoft SQL Server 2012 Reporting Services

  1. Double-click setup.exe to launch the installation.

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

    The installer checks your installation setup.

  3. Click OK to continue after the installer checks your installation setup. You must correct any failures before you can proceed with the next step in the installation.

  4. Enter your product license key and then click Next.

  5. Click I accept the license terms and then click Next.

  6. Click Include SQL Server Product Updates and then click Next.

    The installer extracts the updates.

  7. Click Install to install the setup files.

    The installer checks your installation setup for the second time.

  8. Click Next to continue after the installer checks your installation setup. You must correct any failures before you can proceed with the next step in the installation.

  9. Click SQL Server Feature Installation and then click Next.

    The following screen displays.



  10. On the feature selection screen, select all features. You can change the installation directory, as needed. Click Next to continue.

    The following screen displays.



  11. Specify a named instance or use the default instance. You can change the instance root directory, as needed. Click Next to continue.

  12. Review the disk space requirements, ensure that you have adequate disk space, and then click Next.

  13. Specify the service accounts and the collation configuration, and then click Next.

    The following screen displays.



  14. Specify Windows authentication mode, an Administrator user, and data directories. Click Next to continue.

    The following screen displays.



  15. Specify Multidimensional and Data Mining mode, add an Administrator user, and specify data directories. Click Next to continue.

  16. Specify an Administrator user and then click Next.

    The following screen displays.



  17. Configure the Distributed Replay Client, as shown, and then click Next.

  18. Choose whether or not to send error reports to Microsoft, and then click Next.

    The installer checks your installation setup for the third and final time.

  19. Click Next to continue after the installer checks your installation setup. You must correct any failures before you can proceed with the next step in the installation.

    The following screen displays.



  20. Click Install.

    The installation progress screen displays. When the installation is complete the following screen displays.



  21. Click OK.

  22. Click Close.

  23. Restart your computer.

Validating the MS SQL Reporting Services Configuration

To validate the configuration

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

    The following screen displays.



  2. Connect to the server.

    The following screen displays.



  3. Select the report server in the left pane, and then click Start.

  4. Select the Web Service URL option in the left pane, and then click the link that displays in the right pane. Validate that it opens successfully.



  5. Select the Report Manager URL option in the left pane, and then click the link that displays in the right pane. Validate that it opens successfully.



  6. If the URLs do not open successfully, change the server name to the IP address in the URL, and try again. For example:

    • Web Service URL: http://10.50.130.93/ReportServer

    • Report Manager URL: http://10.50.130.93/Reports/Pages/Folder.aspx

Configuring Authentication Modes

After you install MS SQL 2012 Report Server, use Reporting Services Configuration Manager to initialize the MS SQL Report.

To access Reporting Services Configuration Manager, navigate to Windows Start menu > All Programs > Microsoft SQL Server 2012 > Configuration Tools > Reporting Services Configuration Manager.

MS SQL 2012 Report Server defaults to Specify Negotiate or NTLM authentication. The following is the default authentication information in rsreportserver.config:

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

Follow the procedures below to change the default authentication modes to Anonymous Access and Basic Authentication.

Topics

Configuring MS SQL 2012 for Anonymous Access

Because MS SQL 2012 no longer supports anonymous access, you must manually configure the installation to enable anonymous access, using the following steps.

To configure MS SQL 2012 for Anonymous Access

  1. Copy the AnonymousSecurity.dll file from the MS SQL 2008 installation directory, for example:

    <Installation Dir>/reports/mssql/2008/ReportServer/bin/Microsoft.Samples.ReportingServices.AnonymousSecurity.dll

    And paste it into the MS SQL 2012 installation directory, for example:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin

  2. Navigate to:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

  3. Add the following code to the rsreportserver.config file:

    <Security> 
    <Extension Name="None" Type="Microsoft.Samples.ReportingServices.AnonymousSecurity.Authorization, Microsoft.Samples.ReportingServices.AnonymousSecurity"/> 
    </Security> 
     
    <Authentication> 
    <Extension Name="None" Type="Microsoft.Samples.ReportingServices.Anonymous
    Security.AuthenticationExtension, Microsoft.Samples.ReportingServices.AnonymousSecurity"/> 
    </Authentication> 


  4. Configure code access security, as follows:

    Add the following into the rssrvpolicy.config file in the ReportServer folder. Because this sample project had no strong name, we are using url membership in this example. Replace the red text below with your URL:

    <CodeGroup 
    class="UnionCodeGroup" 
    version="1" 
    PermissionSetName="FullTrust" 
    Name="Private_assembly" 
    Description="This code group grants custom code full trust."> 
    <IMembershipCondition 
    class="UrlMembershipCondition" 
    version="1" 
    Url="C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.AnonymousSecurity.dll"/> 
    </CodeGroup> 


  5. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

    and change the authentication mode in the rsreportserver.config file, as follows:

    <Authentication> 
    <AuthenticationTypes> 
    <Custom/> 
    </AuthenticationTypes> 
    <EnableAuthPersistence>true</EnableAuthPersistence> 
    </Authentication> 
  6. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportManager

    Change the authentication mode to “None” and set “impersonation property” to “false” in the web.config files in the ReportManager folder:

    <authentication mode="None"/> 
    <identity impersonate="false"/> 
  7. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

    Change authentication mode to “None” and set “impersonation property” to “false” in the web.config files in the ReportServer folder:

    <authentication mode="None" /> 
    <identity impersonate="false"/> 
  8. Restart the report server to finalize the Anonymous Access configuration.

  9. Navigate to Windows Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools > Reporting Services Configuration Manager

  10. Open this URL in a browser on a second machine: http://10.50.130.93/Reports, using your IP address in place of this example.



  11. Copy the ReportFacade.aspx and ReportFacade.aspx.cs files from the installation directory to the ReportManager and ReportServer folders.

    For example, copy the files from this location:

    <Installation Directory>/reports/mssql/2012/ReportManager/ReportFacade.aspx.cs

    And paste the files into these two locations:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\

  12. Add the following code into the web.config file in the ReportManager folder:

    <appSettings> 
    <add key="URL" value="http://10.50.130.93/ReportServer/ReportService2005.asmx"/> 
    [Note: In this example, http://10.50.130.93/ReportServer is the report service URL, replace the URL with the one you are using.] 
    <add key="reportFolders" value="/"/> 
    </appSettings>  


  13. Navigate to Civic Platform > V360 Admin > Report Manager > Report Services > MSSQL2012, and change the Report Name List URL and Report Service URL to the following, using your IP address in place of the IP address examples here:

    Report Name List URL: http://10.50.130.93/Reports/ReportFacade.aspx

    Report Service URL: http://10.50.130.93/ReportServer

    Report Manager URL: http://10.50.130.93/Reports

Configuring Basic Authentication

Use the following procedure to configure Basic Authentication for MS SQL.

To configure Basic Authentication for MS SQL

  1. Navigate to the installation directory, for example:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

  2. Change the authentication mode in the rsreportserver.config file to RSWindowsBasic, as follows:

    <Authentication> 
    <AuthenticationTypes> 
    <RSWindowsBasic/> 
    </AuthenticationTypes> 
    <EnableAuthPersistence>true</EnableAuthPersistence> 
    </Authentication> 
  3. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportManager

    Change the authentication mode to “Windows” and set “impersonation property” to “true” in the web.config file in the ReportManager folder:

    <authentication mode="Windows" /> 
    <identity impersonate="true"/> 
  4. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

    Change authentication mode to “Windows” and set “impersonation property” to “true” in the web.config files in the ReportServer folder:

    <authentication mode="Windows" /> 
    <identity impersonate="true"/> 
  5. Navigate to Civic Platform > V360 Admin > Report Manager > Settings > Report Services > MSSQL2012, and change the following fields:



Configuring NT Authentication

To configure NT Authentication for MS SQL

  1. Navigate to the installation directory, for example:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

  2. Change the authentication mode in the rsreportserver.config file, as follows:

    <Authentication> 
    <AuthenticationTypes> 
    <RSWindowsNTLM/> 
    </AuthenticationTypes> 
    <EnableAuthPersistence>true</EnableAuthPersistence> 
    </Authentication> 
  3. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportManager

    Change the authentication mode to “Windows” and set “impersonation property” to “true” in the web.config file in the ReportManager folder:

    <authentication mode="Windows"/> 
    <identity impersonate="true"/> 
  4. Navigate to the following location:

    C:\Program Files\Microsoft SQL Server2012\MSRS11.MSSQLSERVER\Reporting Services\ReportServer

    Change authentication mode to “Windows” and set “impersonation property” to “true” in the web.config files in the ReportServer folder:

    <authentication mode="Windows" /> 
    <identity impersonate="true"/> 
  5. Navigate to Civic Platform > V360 Admin > Report Manager > Report Services > MSSQL2012, and change the following fields: