Please enter search query.
Search <product_name> all support & community content...
Logon Failure error occurs when a non-administrator domain/local user tries to login to the Backup Exec console
Article: 100022124
Last Published: 2011-08-09
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
Give the domain/local user the "Sysadmin" role on to 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: http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en#filelist }
2. Open Microsoft SQL Server Management Studio Express.
{Start-> programs-> Microsoft SQL Server 2005-> SQL Studio Express}
3. Connect using SQL Studio Express to the Backup Exec SQL instance (Server Name\BKUPEXEC).
4. Add the non-administrator user account with "Sysadmin" role to the BKUPEXEC instance's Security tab.
5. Add the non-administrator user account to the Backup operators group on the Backup Exec server.
Steps: (Login to the Backup Exec Server with any Administrator account)
1. Install the Microsoft SQL Server Management Studio Express
{Download Link: http://www.microsoft.com/downloadS/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en#filelist }
2. Open Microsoft SQL Server Management Studio Express.
{Start-> programs-> Microsoft SQL Server 2005-> SQL Studio Express}
3. Connect using SQL Studio Express to the Backup Exec SQL instance (Server Name\BKUPEXEC).
4. Add the non-administrator user account with "Sysadmin" role to the BKUPEXEC instance's Security tab.
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 Network>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.
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 Network>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.