SQL Express and Reporting Services Catalog

SQL Server Express with Advanced Services SP1 shipped a while ago and it includes Reporting Services.  There is a bit of an annoying issue though.  In the Express SKU, the database engine automatically creates databases with AutoClose on.  This behavior means that when all of the connections to the database are closed, the database shuts itself…

0

Session Timeout during execution

Reporting Services has a notion of a user session.  This is not the same as ASP.Net’s notion of a user session, and in fact the two are completely orthogonal to each other.  SSRS’s session maintains information about which report a user is looking at, the data that is in that report (we call this a…

4