Category Archives: SSRS

SSRS Subscriptions – Internals

This URL talks about the internals of SSRS Subscriptions.For someone to wants to debug data driven subscriptions, this would be a great help. http://blogs.msdn.com/b/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspx -Jegan Advertisements

Posted in DataFeeds, SSRS | Leave a comment

Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name is not recognized.

Problem: Recently our Data Driven Subscriptions started failing with the following error message (as in SSRS Error Logs found in Program Files\Microsoft SQL Server\MSRS10.SqlServer\Logfiles\….). library!WindowsService_0!960!01/07/2011-14:17:59:: e ERROR: Error processing data driven subscription: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name ‘<UserName>’  is … Continue reading

Posted in SSRS | Leave a comment

SSRS Data Driven Subscriptions – Queueing Mechanism

When thousands of data driven subscriptions are fired in SSRS, they are stored in ReportServer.dbo.Notifications table. Based on the workload of SSRS Service, subscriptions are picked from this table for processing. This means even if SSRS Server / Windows Service … Continue reading

Posted in SSRS | Leave a comment

Where is SSRS RDL Content Stored in ReportServer Database?

When an SSRS Report (.RDL) is deployed to SSRS Report Server, this is stored in SSRS Database ReportServer tables. To retrieve SSRS RDL from ReportServer DB, use the following SQL by connecting to  Reporting Service SQL server. SELECT [Path], Name, CAST(CAST(Content AS … Continue reading

Posted in SSRS | Leave a comment