First of all check your "Reporting Services configuration" settings under Programs -> MSSQL -> Configuration Tools. With which account is your Reporting Services Service accessing the Database?

You could even...

Hi Dave,

the roles are all used. Beneath every user has its own set of rights. We calculated the number of roles we would have to create if just creating...

Hi,

I was just checking the aggregation design again. Usage based optimization still does not work. Indeed the target server in the project solution is set to the live server's url it...

Hi Dave and Steve,

the size of the measure groups differs. The biggest (budget data on day level) is 83 Mio rows but only 2 dimensions (400000 and 90000 elements)...

Hi Grasshopper and Jeff,

> Since you're constrained by version, consider multiple cubes as sort of a poor man's version of partitioning. (Better to pay for the full version, but...

Hi,

> Is there any IIS optomisation we can do ? I would have thought that visual studio design studio used the same engine as the web site though.

It could...

Hi Steve,

I checked that behaviour with the profiler several times. The cache is hit beneath every query for any measure group. If not the cache is hit then the...

Hi,

I know that PDF is a format from Adobe. But reporting services has a rendering extension to export to pdf.

I have to export the report programmatically for customer reasons....

Hi Michael,

thanks for your post. I already tried this. It works but the problem is, that it is too slow. For every row in the data flow a seperate...

Simply adding more RAM to your machine may not be useful. Is it a 32 or 64bit system? If it is a 32bit System one process (e.g. SQL Server DB Engine) could...

Hi El,

thanks for your fast feedback!

I know the dashboard reports and use them, but I'm not sure how to use them for monitoring SSRS. Could you please explain...

Hi Sam,

no, I did not find a way. Like you I even don't like the clicki-tool they introduced.

In my opinion SQL 2008 is the SP3 for SQL 2005, which is...

Hi,

I experienced the same problem when migrating 2000er reports to 2005. I did not want to completely rewrite all the reports. This would have been pretty much work.

To...

Did you ever experience slow performance with your RAID Systems? We have the problem that we cannot set the stripe to higher than 16k for the RAID 5 using HP...

Hi,

we have the same system. You should see 4 processor graphs.

Best regards,

Stefoon