Messaging Agent does not start after installing Service Pack 2 for BlackBerry Enterprise Server

Article ID: KB04412

Type: Support Content

Last Modified: 04-20-2012

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Novell GroupWise
CollapseEnvironment
  • BlackBerry® Enterprise Server 4.0
  • Novell® GroupWise®
  • SDR52705
  • SDR66957

Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Microsoft® Windows® operating system. Document and back up the existing registry entries prior to implementing any changes.

CollapseOverview

After upgrading to Service Pack 2, the Messaging Agent of the BlackBerry Enterprise Server is unable to connect to the Microsoft SQL Server. The following lines occur in the MAGT log file:

[30058] (09/15 08:50:03):{0x674} Starting Database

[40000] (09/15 08:50:03):{0x156C} [DIAG] EVENT=Register_thread, THREADID=0x156C, THREADNAME="ExtUDPLogThread"

[50049] (09/15 08:50:03):{0x156C} Waiting for external UDP log messages on port 4085

[50000] (09/15 08:50:03):{0x156C} Controller: This BES Agent is under control of BlackBerry Agent Controller

[10000] (09/15 08:50:19):{0x674} COM Error 0x80004005 in ConnectionItem::ConnectToDB() - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. - Unspecified error

[10031] (09/15 08:50:19):{0x674} Open() failed

[50004] (09/15 08:50:19):{0x674} Stopping BlackBerry

[40507] (09/15 08:50:20):{0x156C} ExtUDPLogThread: Code on closing = 0

[40000] (09/15 08:50:20):{0x156C} [DIAG] EVENT=Unregister_thread, THREADID=0x156C, THREADNAME="ExtUDPLogThread"

[30065] (09/15 08:50:20):{0x674} Shutdown complete

CollapseCause
The BlackBerry Messaging Agent is unable to connect to the database because the port is not set to the default of 1433.
CollapseResolution
  1. Enable TCP/IP, if needed.
  2. In the Registry Editor, go to HKEY_LOCAL_MACHINE\SOFTWARE\Research In Motion\BlackBerry Enterprise Server\Database\
  3. Click Edit > New > DWORD Value.
  4. The new key name is highlighted. Rename the new key to Port and press ENTER.
  5. Right-click on the new key and select Modify.
  6. Change the Base Option to Decimal.
  7. Set the decimal value to the port number you wish to use by typing the port number in the Value data field.
  8. Click OK

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.