How do I manage Users & Groups Permissions in SQL-RD?

You can set up new users and administrators, set up security groups and manage permissions using the User manager.

System - User Manager

  • Go to System.
SSRS. SQL-RD Home Menu.
  • Select User Manager.
SSRS. SQL-RD System Menu

What is user management?

The principle behind the user management is simple:

  • Administrators are able to view and manipulate all schedules
  • Users can only see and manipulate schedules they have created.
  • Create Group policies to determine what user can/cannot access in SQL-RD.
SSRS. SQL-RD Authentication section in User Manager in SQL-RD.

How to set up a user

  • Click Add User.
SSRS. SQL-RD Authentication section in User Manager in SQL-RD.

SSRS. User information SQL-RD Authentication section in User Manager in SQL-RD.
  • First Name: Enter the user's first name.
  • Last Name: Enter the user's last name.
  • User ID: Enter a suitable username for the user.
  • Password: Create here the password for the user.
  • Verify Password: verify the user’s password.
  • Security Role: Select a security role.
SSRS. User information  SQL-RD Authentication section in User Manager in SQL-RD.
  • Apply: Click Apply to create the new user.
  • Automatically logon with this user: When this option is checked, SQL-RD will always logon using this user's credentials. When SQL-RD starts, the splash screen will show this user and the system will automatically log in after 10 seconds. You can interrupt the automatic logon process by typing in a different username and password and manually log on as a different user.

Assigned Schedules

  • Select the schedule or folder from the left hand pane and assign it to this user by clicking the green button.
SSRS. User Schedules SQL-RD Authentication section in User Manager in SQL-RD.

Amending a user's details

  • Click on the user.
  • Select Edit User.
SSRS. SQL-RD Authentication section in User Manager in SQL-RD.
  • Overwrite the existing details with the new details.
  • Click OK.
You can also double-click on the user.

Deleting a user

  • Click on the user.
  • Click Delete User
SSRS. SQL-RD Authentication section in User Manager in SQL-RD.
  • Click Yes.
SSRS. Deleting an user pop-up in SQL-RD.

Security Roles

SQL-RD comes with the Administrator and User security roles. Roles help you to easily manage which functionality is available to people who will be using SQL-RD.

You can create new roles by creating groups.

  • Click Add to create a new group.
SSRS. Groups section in User Manager in SQL-RD.

Creating a New User Group

By placing users into different groups, you can determine what they can and cannot access in SQL-RD. Restrict access to certain functionality, activation/deactivation and even assign blackout times.

SSRS. Group Editor section in User Manager in SQL-RD.

Permissions

In the Permissions Tab, you can then specify access to system features such as operational hours, or the options menu. Check the boxes to indicate whether the group has access to these features.

SSRS. Group Editor section in User Manager in SQL-RD.

Destinations Restrictions

SSRS. Group Editor section in User Manager in SQL-RD.

You can also restrict what destinations the group has access to.

  • Allow all destinations: This group can access all destinations.
  • Only allow certain destination types: Check the boxes to indicate which destinations the group has access to.
  • Only allow assigned default destinations: Use only default destinations (created in the Options menu) and assign them to a specified group as shown below. See: Default Destinations
Pre-create destinations in this manner and assign these destinations to the specific group. Perfect for avoiding giving out sensitive logon information such as FTP or SharePoint site info.
SSRS. Group Editor section in User Manager in SQL-RD.

Blackout Times

Set Blackout Times to prevent users from scheduling reports during a certain time frame. Use Operational Hours to build time frames.

SSRS. Group Editor section in User Manager in SQL-RD.

SSRS. Configuring Blackout HOurs in  Group Editor section in User Manager in SQL-RD.

Custom Tasks

SSRS. Group Editor section in User Manager in SQL-RD.
  • Allow all Custom Tasks: All users in this group can use custom tasks.
  • Allow Certain Custom Tasks: Specify which task types this group has access to.

Folders

  • Allow the Group to have access to the folders.
SSRS. Group Editor section in User Manager in SQL-RD.
  • After you finish click OK.

Enable Windows Integrated Authentication

SSRS. SQL-RD Authentication section in User Manager in SQL-RD.

You will now be able to assign new and existing users to the newly defined security role as below.

Windows Authentication

To enable Windows Authentication check the box in the lower left hand corner of the User Manager.

Windows Authentication allows you to use Windows Authentication to log in to SQL-RD. This can help save time in creating new users for SQL-RD. Security roles created in SQL-RD can also be applied to users under Windows authentication.

SSRS. Windows Authentication section in User Manager in SQL-RD.

Add User

  • Add Active Directory users as SQL-RD users.
SSRS. Windows Authentication section in User Manager in SQL-RD.

SSRS. Windows user information in  Windows Authentication section in User Manager in SQL-RD.
  • Domain Name: Enter the domain name.
  • Group Name: You can select from the drop down list the group where the user(s) are located.
  • Add the entire group: All users in the user group will be added to SQL-RD.
Users added in this manner WILL NOT be displayed as individual users in the Users list in the User Manager.
  • Security Role: Assign a SQL-RD specific group to the user. The user will then take on the permissions allotted in the user group. User Groups can be created in the Groups Tab.
  • Assigned Schedules: Assign schedules to the added user/group. Learn more about assigning schedules near the top of this topic.