How to allow Domain Users to run reports (4225392)

By default, Domain Users do not have the appropriate database permissions to run reports.

The Domain User must be:

• A super user of the Desktop Authority console.
• A Local Administrator on the Desktop Authority server.
• The user account also has to be added into SQL and given permission to access the DAReporting database. 
  (Microsoft SQL Server Management Studio will be required and could be downloaded from www.microsoft.com.)

Follow these steps:

1. Open SQL Server Management Studio and connect to the SQL instance.
2. Expand Security
3. Right click "Logins" and select New Login.
4. Click "Search" and find the user account to add. Verify the “From this location” is viewing the domain and not the servername.
5. Click OK.
6. In the Login–New dialog box, select User Mapping, highlight and check DAReporting. Still highlighted, check the db_datareader under the “Database role membership for: DAReporting”.
7. Click OK.
8. Open the Desktop Authority Manager, go to the Role-based Administration on the menu and select Edit Super Users/Groups. Add the user or group & click OK.
9. Finally add the user account to the local Administrators group on the Desktop Authority server using Computer Management.

The next time the user logs onto the Desktop Authority server, they should be able to run reports in Desktop Authority.