Monthly Archives: June 2010

SSRS and UAC (User Access Control)

One of the frequently asked question in many forums is “I am an admin on the machine (Windows Vista or Windows 7 or Windows 2k8) where SSRS is installed but I am not able to access the reports”.  Recently I … Continue reading

Posted in SSRS | 52 Comments

SSRS 2008 R2: Browser Caption

In SSRS 2008 and earlier versions, if you have opened many reports in multiple windows, then there is no easy way to find which window corresponds to which report. For example, say I have 3 reports, Report 2, Report 3 … Continue reading

Posted in SSRS | Leave a comment

SSRS Error: The version of the report server database is either in a format that is not valid, or it cannot be read…

Last week I had to install SSRS 2008 R2 on a machine which already has SSRS 2008. I installed the R2 as a named instance pointing to the SQL 2008 DB and choose the option “Install  but do not configure”. Then … Continue reading

Posted in SSRS | 12 Comments

SQL Server 2008 SSMS crashes when SSRS 2008 R2 installed with Method not found: Int32 Microsoft… error

In my DEV machine, I have SQL Server 2008 SP1 with all the components (DB, SSIS, AS , & RS). Last week I had to install SSRS 2008 R2  on the same machine. I installed it as a named instance. … Continue reading

Posted in SSMS | Leave a comment

SSRS case sensitive?

Seems so. Here is what I did. Created a new report with data source “DataSource1” and a dataset “DataSet1”. Went to the “View Code” mode (right-click on the report to go to this mode) and modified the data source assigned … Continue reading

Posted in SSRS | Tagged | 4 Comments