Saturday, December 31, 2011

Enable ASP.NET Session State By Program

A blog Acticle by Abhijit, telling how to build a HttpModule for .Net 4.0 to enable or disable Session State for the Pages that need it or the whole site.
the article is here.

Tuesday, December 27, 2011

Reporting Services Timeout Settings

Location of Report Web Directory : C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager

copied from an answer by Ryna Shripat on StackOverflow here:

You can fiddle with any of the following:

1) Modify SessionTimeout and SessionAccessTimeout system properties.

Here is a sample script for rs.exe which will set these values for you:

Public Sub Main()      Dim props() as [Property]      props = new [Property] () { new [Property](), new [Property]() }      props(0).Name = "SessionTimeout"      props(0).Value = timeout      props(1).Name = "SessionAccessTimeout"      props(1).Value = timeout      rs.SetSystemProperties(props) End Sub  

You can run this script with the following command:

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"The timeout is expressed in seconds, so this example sets the SessionTimeout and SessionAccessTimeouts to about an hour and a half.

(via http://blogs.msdn.com/b/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx)

2) Change Report Execution Timeout via Report Manager Open Report Manager At the top of the page, click Site Settings. This opens the General Properties page of the site.

Report Execution Timeout Specify whether report processing times out after a certain number of seconds. (viahttp://msdn.microsoft.com/en-us/library/ms181194.aspx)

3) Set the HttpRuntime ExecutionTimeout

  1. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services.
  2. From there, expand Web Sites -> Default Web Site, and click on ReportServer. On the right-hand pane, right-click ‘Web.Config’ and select ‘Open’.
  3. Locate the HttpRuntime parameter. If it doesn’t exist, you will have to create it within the section.
  4. Set the executionTimeout value to ‘10800’ (3 hours) as shown below:
       

4) Increase the script timeout on the report server

  1. Go onto your Reporting Server and open up Internet Information Services; right-click on the ReportServer and select Properties.
  2. Go to the Options tab, and set the ASP Script timeout to 300 seconds (this didn't really work for me).

5) Set the report to never time out on the server

  1. Open your web browser on the server and go to http://localhost/Reports
  2. Navigate to the Report location and click on the problem report(s).
  3. On the left-hand pane, click on Properties.
  4. In the ‘Report Execution Timeout’ click the ‘Do not timeout report execution’. (viahttp://geekswithblogs.net/ssrs/archive/2009/10/30/steps-to-resolve-ssrs-timeout-issues.aspx)

Monday, December 26, 2011

Publishing Reports to the CRM Server

Customer Effective Blog on Restoring SSRS Server and Publishing reports

SimpleTals Blog on Reporting Services

Ryan Duclus wrote a post on Reporting Servics with some nice solutions, including repeating row header for every page a how to create a calendar like report. it is recommended reading : Ten Common SQL Server Reporting Services Challenges and Solutions by .
The SimpleTalk Blog has all the reporting services related artices here. some very advanced solutions but essetial for good reporting generation.

Thursday, December 1, 2011

CRM 2011 IFD and AS FS2.0 Resources

Configuring IFD with Microsoft Dynamics CRM 2011 on MS Blog
Microsoft Dynamics CRM 2011 Implementation Guide explanation on the Document
Introducing Microsoft Dynamics CRM 2011 Claims-based Authentication - Movie on Youtube, starts at installing AD FS, made by MS Tech.
Microsoft CRM 2011 How to Configure IFD Hosted Setup - detailed script at InteractiveWebs Blog, following all the steps needed including the definition of a SSL certificate.