Service Pack installation failing with "Cannot open user default database. Login failed. Login failed for user 'Domain\User'" or Backup Exec upgrade is not completing successfully.
When trying to install a Service Pack or any hotfix for Backup Exec, or upgrade from a previous version of Backup Exec an error is seen in the installation log file.
04-21-2008,15:21:04 : V-225-206: Cannot open user default database. Login failed. Login failed for user 'Domain\User'. ***To search for information about this error, click here
04-21-2008,15:21:04 : V-225-210: Unable to connect to SQL Server. ***To search for information about this error, click here
04-21-2008,15:21:04 : V-225-118: Error installing BEDB ***To search for information about this error, click here
The above error message would appear if the account used for installation doesn't have required privileges on the Database. The above error would also occur if the Backup Exec Service Account is different than the account used to log in to Windows is during the upgrade.
Login to the Windows using the BESA (Backup Exec Service Account) and run the update.
1. Open BEUtility from X:\Program Files\Symantec\Backup Exec ( where 'X' is the drive within which the software is installed. By Default it would the 'C' drive).
2. Right Click on the Server name and select "Change Database Access" to grant access to the Database for the account that you are using to install the Service Pack.
Solution 3 :
1. Make sure that SQL instance for backup exec is running on a local system account
2. Tried to install the service pack through live update or run the manual installation
For more information on how to Change Database Access please check the related documents section.