On his blog , Cristian Petculescu posted a cool video demonstrating the capabilities of the PivotViewer Extension for Reporting Services. The PivotViewer Extension for Reporting Services provides an application generator that enables users to effortlessly...

Prash announced yesterday the availability of a new whitepaper - Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products . The whitepaper contains all the needed information for setting up Kerberos Authentication in your environment...

http://msdn.microsoft.com/en-us/library/cc765421.aspx - SQL Server Setup and Deployment Support and Information This is a Solution-Based portal, a totally new approach for our technology-based portals, which focuses on aggregating the relevant SQL...

In april 2009, I posted an article on using Brian Murphy Booth's DelegConfig tool for troubleshooting Kerberos delegation issues. Today I'll talk a bit about the version 2.0 of the tool which brings some cool new features and also supports IIS 7.0...

Some customers have lately raised the discussion around, what they thought it was, a misbehavior of the Excel Rendering extension when dealing with expandable regions. The behavior can be described as follows. On Reporting Services 2008, we are exporting...

Sometimes, if your server is under heavy load, or after installing Windows Security patches, like http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx , you might experience issues where the SSRS service fails to start with the following information...

Over the last months I've seen more and more customers inquiring about issues when trying to Copy text from PDF files exported from Reporting Services reports and Pasting it into other documents. The issue they were complaining about makes so that pasting...

When working with Microsoft SQL Server 2005 Reporting Services, there are more levels of execution\session timeout configurations. On one hand we have the ASP.NET session which we have to consider since the SSRS service is actually a ASP.NET Web Service...

I can think of 2 separate issues and causes. First is related to the Web Service recycling and the time needed for restarting and reloading its components\assemblies. The second could be a question of response time for a report (the first time it is executed...

A couple of days ago I delivered a presentation on troubleshooting Kerberos configuration issues, especially from the SQL Server's perspective. Part of this presentation I demonstrated the use of Brian Murphy-Booth's ( http://blogs.iis.net/brian-murphy...

Here's a quick guide describing a few checks you could make if you encounter any WMI related errors while trying to connect to your SSRS instance either with Management Studio or with the Configuration Tool. 1. The most common cause for these type...

If you want to create subscriptions programmatically, using the SOAP API, you would call the CreateSubscription method exposed by the API, through the proxy class created against the Web Service (ReportService.asmx; ReportService2005.asmx). However, you...

In order to integrate Reporting Services into your Web Application you have the following options: using the Reporting Services SOAP API (consuming the Reporting Services web service), using the ReportViewer control and using URL Access ( Integrating...

Recently, one of my colleagues put together a very comprehensive action plan that normally should fix this issue. So, if you happen to have this error message while trying to print a report in Reporting Services 2005 after having recently installed...

While upgrading a SQL Server 2005 Reporting Services instance to SP2 from SP1 or from RTM, you might encounter the following error and the upgrade fails, if your reporting Services database name is of the form XReportServer, where X is a string of characters...

Consider the following scenario: You have a report deployed on a SQL Server 2000 Reporting Services SP2 instance. This report contains conditional formatting for some of the dataregions or for some cells inside a table/matrix. The format property that...

As you probably heard, IE8 introduces the Developer Tools. Lots of great features like live HTML and CSS editing, JScript debugging and profiler, HTML, CSS validators. More information: http://blogs.msdn.com/ie/archive/2008/09/03/developer-tools-in...

We might find ourselves in the following scenario: for a SQL Server 2005 edition, you accidentaly specify a wrong "Alias Local Host Server" in Management Studio. Now, what happens is that, when the SQL Server Agent starts, it tries to connect to this...

Consider the following scenario: You have either SQL Server 2000 Reporting Services or SQL Server 2005 Reporting Services set up. You have SSRS configured so that the application pool used by the SSRS virtual directories (Reports and ReportServer) has...