Databases Reference
In-Depth Information
Figure 6-17.
The Create User dialog
3.
In the Create User dialog, enter a username and password. Select an Item role and an
optional System role. Click OK.
4.
Click OK on the Manager Users dialog.
Even though both My Reports and Report Builder are listed in the Item role drop-down list on the Create User
dialog, they are not available nor supported in SQL Reporting. However, depending on role assignments, users can
perform different tasks on the server. By granting users the Browser role, you give those users permission to read
reports. You can assign users to multiple roles, and via the combination of roles and permission create users who have
the appropriate permissions for our reporting environment.
Using the Management Portal
Except for provisioning the Report Server and managing users, the majority of this chapter has used tools such as SQL
Server Data Tools to create and deploy reports. However, a lot of what you did in this chapter can also be done through
the Management Portal, which provides additional functionality. Figure
6-18
shows the ribbon in the Management
Portal when a SQL Reporting server is selected. Notice that you can create a shared data source, create and set
permissions on a folder, upload a report, and look at server usage statistics. Server statistics provides the ability to look
at the overall usage of SQL Reporting over a given time span. By default it will show you the usage over a single day,
but you can also view usage data over a 2-day period, 1-week period, 1-month period, and 3-month period.
Figure 6-18.
The Management Portal ribbon
