Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB16184 - DB Upgrade Failed error when upgrading BESMgmr database during BES upgrade
 
  #1 (permalink)  
Old 01-14-2009, 07:44 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default 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:

  1. Grant the System Administrator role to the account being used for installation.
  2. Attempt the database upgrade again. Launch the setup again if the installation was cancelled or closed.
  3. The System Administrator role can be removed after successfully upgrading the database.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB03569 - DB Upgrade Failed. Error Executing SQL statement hdawg Featured BlackBerry KB Articles 0 09-14-2009 09:50 PM
KB18743 - "Failed (error=5406) to convert XML record" error occurs after 5.0 Upgrade hdawg Featured BlackBerry KB Articles 0 07-30-2009 03:23 PM
KB04953 - DB Upgrade Failed. Error Executing SQL statement. hdawg Featured BlackBerry KB Articles 0 05-26-2009 01:12 PM
KB15451 - An attempt to upgrade the database was unsuccessful. An error occurred hdawg Featured BlackBerry KB Articles 0 05-26-2009 12:09 AM
KB14537 - Issue with a BlackBerry MDS database upgrade script during a large upgrade hdawg Featured BlackBerry KB Articles 0 04-01-2009 03:08 PM


All times are GMT -4. The time now is 05:30 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2