SharePoint and Reporting Services Together

<< yukon final version seems to be stable | Home | Registry Fix >>

SharePoint and Reporting Services Together

If you have a Win2k3 machine which already has SPS installed and you want to install SQL Server 2000 Reporting Services.

And, Even after excluding your ReportServer URL(s) from Sharepoint Server you are getting a error while opening Report Manager as -"Session state has been disabled for ASP.NET. Report Manager requires that session state be enabled."

Here is the solution...

STEP 1. Add the following to SharePoint's Web.config file (By default located at C:\Inetpub\wwwroot)

STEP 2. Now enable session state for the pages element by adding/editing enableSessionState attribute as true.

Now your Report Server Should work!

Print | posted on Tuesday, January 17, 2006 10:35 AM

Comments on this post

# re: SharePoint and Reporting Services Together

Unfortunatly, your STEP 1 actions are note shown. I would like to see them, could you repost.

Left by bill_lawrence80@yahoo.com on Jun 30, 2006 3:58 PM

# re: SharePoint and Reporting Services Together

Hey Bill Thanks for pointing that out, here are the missing actions:

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. )

<HttpModules>
<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

Please refer to this MSDN Article for more details - "Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services"(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp)

Hope this helps.

Left by Raj on Jul 03, 2006 6:12 AM

# Phentermine no prescription.

Phentermine online. Phentermine. Generic phentermine. Phentermine no prescription. Adipexdrug addiction order phentermine online. Phentermine diet.

Left by Phentermine free shipping. on Jul 09, 2007 5:42 PM

# Xanax.

2mg xanax order. Xanax. Generic xanax 2 mg no prescription. Xanax with 5-htp. Xanax 2mg.

Left by Xanax online without prescription. on Jul 10, 2007 11:12 PM

# Ephedra yellow jackets.

Thermogenic with ephedra in it. Wyoming ephedra lawyer. Ephedra pills. Ephedra weight loss products. Ephedra.

Left by Ephedra yellow swarm. on Jul 12, 2007 7:35 AM

# Xanax cocktail.

Buy xanax. Buy xanax online. Xanax no prescription. No rx online xanax. Xanax. Xanax cocktail.

Left by Xanax no prescription. on Jul 12, 2007 3:59 PM

# re: SharePoint and Reporting Services Together

Works like a charm, thanks

Left by Bonginkosi Ngubane on Jul 22, 2009 12:21 AM

# re: SharePoint and Reporting Services Together

that is excellent

Left by samanta on Dec 15, 2009 12:22 AM

# re: SharePoint and Reporting Services Together

I have had the same problem with Sharepoint in the past. Your solution is straightforward.

Left by turtle beach x11 on Oct 14, 2010 8:04 PM

Your comment:

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 7 and 8 and type the answer here:

DotNetRaj