Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL BI   (RSS)

Timeouts and Microsoft SQL Server 2005 Reporting Services

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.
Posted by emilianb | 2 Comments

Slow response time for SQL Server Reporting Services after restart or after period of inactivity - why does it happen and how to fix it -

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)
Posted by emilianb | 1 Comments

Creating Subscriptions Programmatically using different Local Settings (field separators)

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

Unable to load the client print control after installing KB956391

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 the
Posted by emilianb | 0 Comments

Could not locate entry in sysdatabases for database X

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:
Posted by emilianb | 1 Comments

"The specified @name (‘B3F7CB60-6636-4F67-93CF-B94C052DFD29’) already exists" while editing a subscription

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
Posted by emilianb | 1 Comments
 
Page view tracker