Reporting Services HTTP 401 (Unauthorized) – Host Headers require your attention

In a previous post, I talked about issues with repeated login prompts when trying to access either Report Server or Report Manager using your browser.  Recently, during an upgrade of our internal test server we identified a new type of HTTP 401 (Unauthorized) message.  This post provides a description of the problem and the solution.   …

6

Per user snapshots? Or multiple snapshots for a report each with different parameters at the same time

I’ve received questions in the past about whether the report server supports per user snapshost – that is report snapshots customized with different parameter values for a given user.   The answer I have always given is no – you get one snapshot per report and that snapshot always uses the default parameter values. Well, it…

3

Report Designer for SQL Server 2000 Reporting Services does not work on Visual Studio 2005

Some folks have run into a problem using SQL Server 2000 Reporting Services now that Visual Studio 2005 has been released. Specifically, the Report Designer in RS 2000 doesn’t work in Visual Studio 2005.  Luckily, there is a solution: The Visual Studio 2005 license includes a downgrade provision.  The details are located here: http://msdn.microsoft.com/vbasic/previous/downgrade.aspx The…

0

SQL Server 2005 SP1 Reporting Services database expected version is ‘C.0.8.43’ problem

(Originally I thought this post should be titled: SQL 2005 SP1 Tattered my Report Server Database – What’s up with that?)   When you upgrade SQL Server 2005 to SP1 and you are running Reporting Services, you may start to get the following error message:   The version of the report server database is either…

5

Upgrading Reporting Services – What about my Report Definitions (RDLs)?

Some folks have asked me what happens when I upgrade my RS 2000 to an RS 2005 deployment with respect to Report Definitions (RDLs).   This is an interesting lifecycle problem that we’ve approached using the following idea: What you publish to the report server is what you retrieve from the report server.   Here’s how…

1

Populating the Cache before your users pound your report server

Often people take a look at their report execution times and wonder how to optimize it.  They readily see that it is possible to cache a report the first time a user runs it so that subsequent users don’t have to incur the initial execution time.   Well that still leaves the first person to…

1

Monitoring Subscription Status (also calling RS SOAP methods from inside reports)

While posting on the Reporting Services forum, I came across a post by some folks looking to know how to automatically find out that a subscription had failed to run.  Right now, the way the RS tools are, there is no way to do this automatically without calling a SOAP method – ListSubscriptions.  These folks…

2

Windows SharePoint Services and RS 2005

In RS 2000, users had a lot of grief to get RS to work on the same computer as Windows SharePoint Services (WSS).  The reason for this is that WSS version 2.0 effectively commandeers the computer.  We provide a trouble shooting document for these here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp In RS 2005 we’ve done some work to make…

0