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

• 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.

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

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.