book
Article ID: 100022124
calendar_today
Updated On:
Cause
This issue occurs because the Backup Exec SQL instance, by default, doesn't allow any non-administrative user to access it.
Resolution
Assign the domain/local user to the "
Sysadmin" role in the Backup Exec's SQL Instance and also add it to the '
Backup operators' group on the Backup Exec Server/Active directory.
Steps: (Login to the Backup Exec Server with any Administrator account)
1. Install the Microsoft SQL Server Management Studio Express
Download Link:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
2. Open Microsoft SQL Server Management Studio.
Start-> Programs-> Microsoft SQL Server Management Studio
3. Connect using SQL Studio to the Backup Exec SQL instance (Server Name\BKUPEXEC64).
4. Add the non-administrator user account with "Sysadmin" role to the BKUPEXEC instance's Security tab.
Servername\BKUPEXEC64 - Security - Logins - Select User Account - Right click - Properties. Select Server Roles and enable the "Sysadmin" role.
5. Add the non-administrator user account to the Backup operators group on the Backup Exec server.

6. Login to the Backup Exec Server with the same non-administrator user account and launch the Backup Exec console.
Note: Though the non-Administrative User may now be able to launch the console, this user may not be able to create or edit jobs if the Administrative Account listed at Configuration and Settings --> Logon Accounts --> Manage Logon Accounts has a Type of "Restricted" (instead of Common). Other operations, such as installing patches, repairing the installation, etc... may also fail if a user without full Administrative Rights is not logged on to the machine.
Applies To
Backup Exec Console (Local)
Backup Exec Remote Admin Console
Issue/Introduction
Logon Failure error occurs when a non-administrator domain/local user tries to login to the Backup Exec console.