Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services

Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services

SQL Server 2000

To enable a side-by-side installation of Reporting Services and Windows SharePoint Services, perform the following steps.

  1. While installing Reporting Services, you may experience activation failures. Ignore any activation errors that occur.
  2. Add the Reporting Services virtual directories to the Windows SharePoint Services list of exclusions. If you installed Reporting Services using the default virtual directories, run the following at the command prompt:
    STSADM.EXE -o addpath -url http://localhost/ReportServer -type exclusion


    STSADM.EXE -o addpath -url http://localhost/Reports -type exclusion
  3. Add the following under the HttpModules configuration element of the SharePoint Web.config file if it does not already exist. By default, the SharePoint Web.config file is located at C:\Inetpub\wwwroot.
       <add name="Session" type="System.Web.SessionState.SessionStateModule"/>

    In addition to adding the session state module, you must also enable session state for the pages element by changing the enableSessionState attribute from false to true. The entry in the configuration files should look like the following:

    <pages enableSessionState="true" enableViewState="true" enableViewStateMac="true" validateRequest="false" />
  4. From the Internet Information Services (IIS) Manager, ensure that the report server is in an application pool that is separate from the SharePoint server. The report server management user interface, Report Manager, can remain in the same application pool to which it was originally installed. To assign the report server to a separate application pool, you must first create a new application pool. After you have created a new application pool, expand Web Sites, expand Default Web Site, right-click the report server virtual root that you created during setup (the default is ReportServer), and then click Properties. From the Application pool drop-down list, select the newly created application pool. For more information about application pools, see your Internet Information Services documentation.
  5. Finally, use the rsactivate utility to activate the local instance of Reporting Services. You need to install Administrative Tools and Utilities as part of Reporting Services setup in order to use the rsactivate utility. By default, rsactivate is located at C:\Program Files\Microsoft SQL Server\80\Tools\Binn. If you installed your report server to the default location, run the following at the command prompt:
    rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
See Also

Troubleshooting an Installation of Reporting Services

© 2016 Microsoft