Category Archives: SSRS
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
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
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
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