After the successful installation of SQL Server Reporting Services and when you are trying to access the Report Manger via link: http://localhost/Reports an error message is prompted when you click on Report Builder:

image

The error message is:

To use Report Builder, you must install .Net Framework 3.5 on this computer. To visit the Microsoft Download Centre and install .Net Framework 3.5, click install.

image

 

If you already have .Net Framework 3.5 installed, then you do not need to do this. Even if you install it again, it will still prompt you with the same message again.

Solution:

This is a problem with Internet Explorer version 9. To bypass this, simply click on the compatibility icon, then try to access Report Builder again. This time it will work.

image

Now you will see the Report Builder has launched:

image

 

Hope this is helpful and send me your questions if you have problems or write in the comments.

Tagged with:
 

If you are accessing SQL Server Reporting Services in Report Manager and wondering where the Report Builder button is, this could be due to one of the following:

image

1) You are using the Express version of SQL Server.
Report Builder feature is not included in the express version of SQL Server.

2) You do not have Report Builder role assigned to the logged in user accessing SQL Server Reports:

image

To learn on how to do this, you can view a similar problem where required to change the Role setting. Jump to step number 3:

Edit Role Assignment Report Manager