Share via

Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos

  • Article
  1. Install SQL Server 2005 - Reporting Services Only
  2. Install SQL Server Service Pack 2
  3. Install Sharepoint (as WFE)- SKU (Enterprise Edition, Standard,etc..) has to match the other SKUs in the farm
  4. Run the Sharepoint Server Configuration (do not add central admin unless you want to) - Not sure if this step is needed but can't hurt
  5. Install the reporting services add-in for sharepoint
  6. Run the Reporting Services Configuration Utility [start-->all programs-->microsoft sql server-->configuration-->reporting services configuration]
  7. Create the ReportServer Virtual Directory (ReportServer) preferably
  8. ReportServer AppPool and Reporting Services Windows Service should both be a domain account
  9. Create the Database (create the database in Sharepoint integration mode) -
  10. (Here's the Trick) - the Website that contains the report server vdir attempts to negotiate authentication by default.  This is not needed if you are not configuring kerberos. 
  11. To fix this if you do not intend to use kerberos, open a command prompt, cd to c:\inetpub\adminscripts\
  12. First check to see if there is an authentication provider run cscript "adsutil.vbs get w3svc/{WebSiteId}/root/NTAuthenticationProvider" ({WebSiteId} being the id for the website containing the RS Vdir), this should return [The parameter "NTAuthenticationProviders" is not set at this node.]
  13. Then run [cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "NTLM"]
  14. This should return [NTAuthenticationProviders       : (STRING) "NTLM"]
  15. Next go to Sharepoint central administration and enable the reporting services feature and then configure the rest of reporting services within application management.  Be sure to set the authentication method to Trusted Account. 
  16. For more information on this see - https://blogs.msdn.com/sharepoint/attachment/4194088.ashx

Comments

  • Anonymous
    February 04, 2008
    Thanks for the article and the fantastic document.  Why can't Microsoft make all their documents this easy to follow  :)   Do you know if there is one similar that relates to enabling Kerberos authentication? Thanks again, Simon

  • Anonymous
    April 30, 2008
    There isn't a specfic article i know of regarding reporting services configuration but there should be enough info in Martin Kearns post to figure it out.  http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

  • Anonymous
    July 28, 2008
    The comment has been removed

  • Anonymous
    September 12, 2008
    As with any production environment, the next exercise (after configuring SSRS in SharePoint Integrated