Logon Failure error occurs when a non-administrator domain/local user tries to login to the Backup Exec console

Article: 100022124
Last Published: 2023-09-29
Ratings: 0 0
Product(s): Backup Exec

Problem

Logon Failure error occurs when a non-administrator domain/local user tries to login to the Backup Exec console.

 

Error Message

Logon Failure

 

Cause

This issue occurs because the Backup Exec SQL instance, by default, doesn't allow any non-administrative user to access it.

 

Solution

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
 

 

Was this content helpful?