Unable to Run Report due to database access denied

book

Article ID: 100018198

calendar_today

Updated On:

Description

Error Message

Unable to Run Report. No further Information is Available.

V-260-5: Unable to run media set report, Database access denied


Backup Exec Debug:

BESERVER: -1 SQLLog(198142):Database Exception Context:m_QueryTimeoutInSeconds=30 sql=ReportDiskStorageSummary  N'' Error:-536837662: :: -2147217900:Cannot open user default database. Login failed. :: DB Error Set 0: native=0xfe0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Cannot open user default database. Login failed. :: DB Error Set 1: native=0x4818 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Login failed for user 'DOMAIN\BESA'.

BESERVER: 13 Reports: Database Exception.  0x4818.
BESERVER: -1 Error(13/45): 5:Database Access Denied

 

Cause


The SQL instance hosts the Backup Exec database, the BESA account, or Administrator group in SQL Logins Default database set to a offline database.
.

Resolution


This error is usually related to Backup Exec Database access.

A) Logon to the Backup Exec server as the BESA Backup Exec Service account and open  a command window. Start > Run > CMD), type the following and press Enter:

 
osql -E -S SERVER\BKUPEXEC
 

One of the following errors may be returned:

 
Login failed for users 'DOMAIN\'.
 
Cannot open user default database. Login failed.
 

 
[SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance
 
Specified [xFFFFFFFF].
 
[SQL Native Client]Login timeout expired
 
[SQL Native Client]An error occurred while establishing a connection to
 
the server. When connecting to SQL Server 2005, this failure may be caused by
 
the fact that under the default settings SQL Server does not allow remote
 
connections.
 

The first error indicates there are authentication issues. It is necessary to ensure Backup Exec is correctly set up with an appropriately configured service account.


1. Log into Windows as the Backup Exec Service Account (BESA).  This is usually the same account that is used to perform backups (re: the System Account under Backup Exec's Network > Logon Accounts Menu).

2. Make sure the Backup Exec Service Account and the Logon Account of the Backup Exec Services are using the same accounts. In the Network > Logon Accounts Screen, the Owner column of the System Account should be the BESA as well as the same account under the User name column; if changes need to be made to make these identical, perform the steps in the following article:

 
How to create a System Logon Account in Backup Exec for Windows Servers
 
3. Open BEUtility; select All Media Servers, then select the server. From Database tasks, select Change Database Access and enter the BESA, the domain name, and make sure that the radio button labeled Grant Access is selected, then click OK.

SQL Server
The SQL instance hosting the Backup Exec database  may have no default database associated with the Backup Exec Service Account. Open SQL Management Studio, then expand Security and select Logins; select the User account and right click and select Properties ...

 image.png
In the Default database field, select BEDB as the Default database, then close out Enterprise Manager.

Return to Backup Exec and retry the report.
 
 

 

Issue/Introduction

When running a Backup Exec report, the report fails to run. "Unable to Run Report No further Information is Available".

Powered by Wolken Software