01-14-2009, 06:44 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
KB16184 - DB Upgrade Failed error when upgrading BESMgmr database during BES upgrade
KB16184 - DB Upgrade Failed error when upgrading the BlackBerry Configuration database during an upgrade of the BlackBerry Enterprise Server
Environment
- BlackBerry® Enterprise Server software version 4.1 Service Pack 4 (4.1.4) for Microsoft® Exchange
- Microsoft® SQL Server® 2005
Overview
When upgrading the BlackBerry Enterprise Server, the following error message appears: DB Upgrade Failed.
In the setup log file, located in your BlackBerry Enterprise Server log file directory, the following error message appears at the bottom of the file. [20000] (10/04 14:32:11.795):{0xB90} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E09 - IDispatch error #3081 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'." Native error = 229
[20000] (10/04 14:32:11.795):{0xB90} [CBESDBInstaller::ExecuteDDL] SQL Error for /*+---------------------------------------------------------------------------
* RIMPurgeHistory - delete rows from ServerConfigHistory table
*+--------------------------------------------------------------------------*/
exec sp_add_job 'RIMPurgeHistoryBESMgmt',
@description = 'Remove old data from history table'
Cause
The account used to install the BlackBerry Enterprise Server software is not assigned the System Administrator role on the Microsoft SQL Server.
Resolution
Complete the following steps:
- Grant the System Administrator role to the account being used for installation.
- Attempt the database upgrade again. Launch the setup again if the installation was cancelled or closed.
- The System Administrator role can be removed after successfully upgrading the database.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
