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

Published 18 November 07 11:27 PM | shawnfel 
  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 - http://blogs.msdn.com/sharepoint/attachment/4194088.ashx

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Simon said on February 4, 2008 7:16 PM:

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

# shawnfel said on April 30, 2008 1:38 PM:

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

# Rob said on July 28, 2008 2:20 PM:

WOW...I have been beating my head against the wall for days, searched high and low, tried this and that and now you have the answer right in front of me...it worked like a charm...thanks!

# Sameer Surve said on September 12, 2008 5:45 PM:

As with any production environment, the next exercise (after configuring SSRS in SharePoint Integrated

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required

About shawnfel

I'm a consultant for Microsoft Consulting Services specializing in SharePoint and BI Products. I've been with Microsoft since 03/2006. The opinions expressed herein are my own personal opinions and do not represent my employer's views in anyway.

Search

This Blog

Syndication

Page view tracker