Important Update: Cohesity Products Knowledge Base Articles
All Cohesity Knowledge Base Articles are now managed via the Cohesity Support Portal: https://support.cohesity.com/s/searchunify. The Knowledge Base articles available here will not reflect the latest information or may no longer be accessible.
Problem
When running a Backup Exec report, the report fails to run. "Unable to Run Report No further Information is Available".
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.
.
Solution
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:
One of the following errors may be returned:
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:
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.
For more information on using BEUtility reference https://www.veritas.com/docs/000090559
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 ...
In the Default database field, select BEDB as the Default database, then close out Enterprise Manager.
Return to Backup Exec and retry the report.
Related Knowledge Base Articles
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.