Troubleshooting › Authentication Problems › Restricted Users Cannot Access the Activity Log and the Audit Log

Restricted Users Cannot Access the Activity Log and the Audit Log

Valid on Windows Server 2003, Windows Vista, and Windows Server 2008 systems.

Symptom

When you log in to Arcserve Backup using Windows authentication and a Windows account with restricted privileges (for example, Backup Operator and Remote Desktop User), you cannot access the Arcserve Backup Activity Log and Audit Log.

Note: This behavior does not occur when you configure Arcserve Backup to authenticate with the Arcserve Backup database using SQL Server authentication.

Solution

To remedy this behavior, grant all Windows accounts that require access to the Activity Log and the Audit Log the privilege to connect to SQL Server using Microsoft SQL Server authentication.

To grant privileges on Microsoft SQL Server 2000

1. Allow Microsoft SQL Server to communicate by adding the application to the Windows firewall exceptions list.
2. Allow the restricted Windows accounts to communicate as members of the SQL instance group or the sysadmin group.

To grant privileges on Microsoft SQL Server 2014 Express Edition and Microsoft SQL Server 2005 or later

1. Allow Microsoft SQL Server to communicate by adding the application to the Windows firewall exceptions list.
2. Allow the restricted Windows accounts to communicate as members of the SQL instance group or the sysadmin group
3. Add the restricted Windows accounts into Microsoft SQL Server by doing the following:
   1. Open Microsoft SQL Server Management Tool.

      Open Object Explorer.

      Expand the Arcserve Backup server, Security, and Logins as illustrated by the following screen:

   

   1. Right-click the Arcserve Backup instance and click Properties on the pop-up menu.

      The Login Properties dialog opens as illustrated by the following screen.

   

   1. Click User Mapping.
   2. In the Users mapped to this logon field, select the databases that you want to map by click the Map check box.
   3. In the Database role membership for field, select the roles that you want to apply to this user for the selected database and click OK.