Tackling Reporting Services Issues
Adam Saxton (Microsoft CSS)
Have you ever wanted to see what CSS does with the data you provide them? Have you wondered what tricks they know? This is your chance! We will look at some of the top issues we receive from the Support side and show you what we do to troubleshoot them. This will include, but not limited to:
The issues we look at in this area will lead into how to interpret the server logs and what changes can be made to get more details. It will also lead us into configuration settings and how this can impact processing and rendering of reports along with system resources. These will also include areas such as Subscriptions, Forms based Authentication (i.e. custom security extensions) along with a Single Sign On scenario and System Resource issues (Memory, I/O, etc..).
We will go over Pagination issues and what are some thing we can do to mitigate those types of issues. We will also look at issues that will lead into different settings that can be set when designing your reports and how those can affect the layout of your report. In addition, we will take a look at some of the new features that SQL 2008 R2 offers in regards to Report Design.
Integration with SharePoint is always a hot topic and we will go over some of the hurdles you may encounter when trying to set this up and how to avoid them. This will range from initial setup and configuration to usage within the Document Libraries.We’ll also walk through how we streamlined SharePoint Integration in SQL 2008 R2.
We’ll look at how Kerberos relates to Reporting Services. We continue to see issues in this area and we’ll look at what you need to do to get this working correctly along with how to figure out what is wrong if it fails.
These items will also lead into discussions about how Reporting Services works internally. We will also have time to answer question you may have about the product or about how to identify and correct issues. This is also your chance to have a look at some of the new features in Reporting Services 2008 R2 and how they relate to issues we see.
Register now for PASS European Conference 2010
Return to pre-conference listings