Report Builder Button is not showing in SQL Server (Report Manager)

On March 16, 2012, in MS Reporting Services, MS SQL Server, Technical Knowledge, by Soheib
0

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

Tagged with: • •
 

SQL Server 2012 Reporting Services UAC (User Access Control)

On March 15, 2012, in MS Reporting Services, Technical Knowledge, by Soheib
59

There are two issues that you will find out when you finish the installation of SQL Server 2012 or SQL Server 2008 R2:

  1. When you try to access Reporting Services using your IE browser, it will constantly prompt you to enter username and password.
  2. After the successful entry of login details in IE, you will get the following error message:
User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

image_thumb65

To resolve the first issue, please read the following article:

SSRS Prompt username and password

Here is the steps that you need to do to resolve the second issue:

1. From Start > All Programs > Internet Explorer, Right Click and choose Run as administrator

image

2, Enter the Reporting Services URL: http://localhost/Reports_SQLExpress

3. Running as administrator will allow you to have access to Site Settings. Click on it:

image

4. You will see the General Site Settings page:

image

5. Click on Security from the left side menu and choose New Role Assignment:

image

6. Add the username or Group that you want to grant permission to and select the appropriate role:

image

7. Now go to Home page and click on Folder Settings. Add the username or Group that you want to grant permission to the main Home page:

image

8. All done now. You can normally open IE and it will work without an AUC error. You can also create Folders within the Home page and restrict access to specific users.

Tagged with: •
 

SSRS Prompt for username and password in IE

On March 15, 2012, in MS Reporting Services, Technical Knowledge, by Soheib
19

After the successful installation of SQL Sever Reporting Services 2012 or 2008 R2 (read this article for an installation tutorial: SQL Server 2012 Express Installation Tutorial), you will get constantly prompted with Windows Security dialog box to enter login details. This is related to IE9 which ships with Windows 7 operating systems.

image

It is easy to fix this issue by following these steps:

1. Open Internet Explorer (IE9) and from the tools menu, choose Internet Options:

image

2. From the Security Tab, choose Local intranet and click on Sites:

image_thumb[15]

3. Click on Advanced button:

image_thumb[16]

4. Type in localhost in Add this website text field and click on Add button (Un-tick the box Require server verification (https:) for all sites in this zone):

image

 

All done. If you open your IE again and type in Reporting Services URL, you will no longer be prompted to enter login details.

However, you may see a UAC (User Access Control) authorization error message. To learn how to resolve this issue, read this article:

SQL Server 2012 UAC authorization error

Tagged with: •
 

SQL Server Reporting Services 2008 Installation Tutorial

On March 9, 2012, in MS Reporting Services, Technical Knowledge, by Soheib
3

This article is a step-by-step walk through of SSRS 2008 installation on a virtual machine. If you are going to install SSRS on a physical machine, then the steps are still similar and you can benefit from it.

Environment Check List

To follow the steps, you would need to have the following programs installed and configured on your machine:

  • Have already setup a virtual machine. I am using VMware with Windows XP as guest operating system (if you need help to do this, read article: How to install VMware Player?)
  • Have already installed SQL Server 2008 R2 on your machine (without the Reporting Services)
  • Have already created an ISO image from the installation disk
    (If you need help to do this, read article: How to create ISO disk image?)

If you have the above installed and ready, here are the steps:

1. This first thing we need to do is to boot the virtual machine. Once the guest operating system is on, we have to mount the optical disk drive to the ISO image which we have already created and contains the installation files. To do this, right click on the CD icon located on the bottom right of your VMware Player window box and choose Settings:

image

2. Be default the connection is set to use physical drive. Choose, Use ISO image file and browse to the directory were file is stored then click OK:

image

3. If the ISO image is connected successfully, you will see the file mounted as your CD drive in My Computer window:

image

4. Right Click on the CD drive and choose Open to view the content. Browse to the appropriate folder directory (D:\English\SQLServer2008R2\Developer) and double click on the installation file Setup:

image

5. SQL Server Installation Center will open:

image

6. From the left menu, choose Installation and then click on New installation or add features:

image

7. Setup checks if you have the necessary support files. Click OK:

image

8. Click install:

image

9. The system checks if you have all the required software dependencies. If any of the rules fail for you, then setup will provide a link which contains further instructions. You have to install the prerequisites software before you can proceed. In this case, all rules passed and we click on Next:

image

10. Since we are adding the Reporting Services to an existing instance of SQL Server, we will select the second option and click Next:

image

11. The next window asks to select the new features that we want to add. Select (Tick) Reporting Services & Business Intelligence Development Studio and click Next:

image

12. Another check. Click Next:

image

13. Checking Disk Space Requirement. Click Next:

image

14. Next is server configuration which asks you to associate an Account to use for the Reporting Services. I am choosing SYSTEM (You can also create a separate account), click Next:

image

15. Choose Install, but do not configure the report server and click Next:

image

16. If you want to report errors to Microsoft, then tick the box; otherwise, click Next to continue installation:

image

17. Another check for installation rules. Click Next:

image

18. Setup is almost ready to proceed with the actual installation. Click Install:

image

19. Setup is complete and Reporting Services is added.

image

20. It is time now to configure the Reporting Services. Browse to:
Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager and click on it: (we can also see that SQL Server Business Intelligence Development Studio is installed):

image

21. You will be asked to connect to the Reporting Services. Click Connect:

image

22. If the installation is successful, you will be connected. On your left side, there is a menu which you would need to configure few. The first is Service Account, I have left this to the default which is Local Account but as it was mentioned previously, you can specify a separate account. Now go to next, Web Service URL:

image

23. Under the Web Service URL tab, it is best to leave the Virtual Directory name as defaulted to ReportServer. This is common and widely known. Click on Apply to deploy this configuration.

image

24. Under Database tab, Reporting Services store all reports and related information in separate database. Since this is the first time, we do not have them. Click on Change Database to create them.

image

25. Follow the steps in next few screens to create the reporting databases:

image

image

image

image

image

image

26. Now go to the next tab Report Manager URL. Leave the virtual directory as Reports and click on Apply to deploy the configuration. You will see once its done green checks under Results section.

For the purpose of this exercise, I am not going to skip Email Settings but you can add your details there if you want reports to be scheduled and sent to email address. Click on Exit to finish.

image

 

27. Finally, there are two important URL which allow us to access the Reporting Services:

http://localhost/Reports
(This is where all reports are going to displayed once deployed. It is also the place where users can view and run reports)

http://localhost/ReportServer
(This is the location where reports are going to be deployed to)

To check that everything is done correctly and the installation is successful, to test this, open your internet explorer and type the above URL, you should see this:

image

image

Tagged with: • • • • •