Sign In
Random Thoughts on SharePoint, BI, and .NET
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Blog Home
About
Email Blog Author
Share this
RSS for posts
Atom
RSS for comments
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
.NET
Search
SharePoint
SQL Server Analysis Services
SQL Server Reporting Services
Archive
Archives
May 2010
(1)
May 2009
(1)
January 2009
(1)
December 2008
(1)
November 2008
(1)
September 2008
(2)
June 2008
(3)
May 2008
(1)
November 2007
(11)
Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos
MSDN Blogs
>
Random Thoughts on SharePoint, BI, and .NET
>
Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos
Quick Guide on how to install Reporting Services on its own server/cluster in SharePoint Integration Mode without using Kerberos
shawnfel
18 Nov 2007 6:27 PM
Comments
4
Install SQL Server 2005 - Reporting Services Only
Install SQL Server Service Pack 2
Install Sharepoint (as WFE)- SKU (Enterprise Edition, Standard,etc..) has to match the other SKUs in the farm
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
Install the reporting services add-in for sharepoint
Run the Reporting Services Configuration Utility [start-->all programs-->microsoft sql server-->configuration-->reporting services configuration]
Create the ReportServer Virtual Directory (ReportServer) preferably
ReportServer AppPool and Reporting Services Windows Service should both be a domain account
Create the Database (create the database in Sharepoint integration mode) -
(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.
To fix this if you do not intend to use kerberos, open a command prompt, cd to c:\inetpub\adminscripts\
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.]
Then run [cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "NTLM"]
This should return [NTAuthenticationProviders : (STRING) "NTLM"]
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.
For more information on this see -
http://blogs.msdn.com/sharepoint/attachment/4194088.ashx
4 Comments
SharePoint
,
SQL Server Reporting Services
Blog - Comment List MSDN TechNet
Comments
Loading...
Leave a Comment
Name
Comment
Please add 8 and 2 and type the answer here:
Post