KB10563 - BlackBerry Dispatcher immediately stops responding when started

Environment

• BlackBerry® Enterprise Server software version 4.1 for IBM® Lotus® Domino®
• Microsoft® SQL Server®
• Microsoft® SQL Server® Desktop Engine (MSDE)

Problem

The BlackBerry Dispatcher immediately stops responding when started.

Cause

The BlackBerry Dispatcher is unable to authenticate MSDE or Microsoft SQL Server to access the BlackBerry Configuration Database. Registry keys are also missing. These are needed for Microsoft SQL authentication to the BlackBerry Configuration Database.

Resolution

To resolve this issue, complete the following steps:

1. Create an Open Database Connectivity (ODBC) test connection from the BlackBerry® Enterprise Server by completing the following steps:
   1. Click Start > Control Panel > Administrative Tools > Data Sources.
   2. Click the System DSN tab.
   3. Click the Add button.
   4. Scroll through the list.
   5. Click SQL Server.
   6. Type BBTest in the Name field.
   7. Type the computer name or the Internet Protocol (IP) address of the Microsoft SQL Server in the Server field.
   8. Click Next.
   9. Select the authentication type.
   10. Click Next.
   11. Click Next.
   12. Click Finish.
   13. Click Test Data Source to verify the account can access the Microsoft SQL Server.
2. Use the OSQL.exe file to authenticate to the BlackBerry Configuration Database by completing the following steps:
   1. Copy the OSQL.exe file from C:\Program Files\MSSQL Server\80\tools\bin\ to C:\.
   2. Click Start > Run.
   3. Type CMD.
   4. Click OK.
   5. Type OSQL-E for Windows® authentication or -U for SQL Authentication or -S if the BlackBerry Enterprise Server is on a remote server.
   6. The 1> prompt should appear when the authentication is successful.
3. Create the required registry keys by completing the following steps: Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Windows operating system. Document and back up the registry entries prior to implementing any changes.
   1. Open the Registry Editor.
   2. In the left pane, locate the registry key HKEY_USERS\.DEFAULT.
   3. Create the following nested registry keys (if they do not already exist ): Software > Research In Motion > BlackBerry Enterprise Server > Database
   4. Right-click the Database registry key.
   5. Create the following string values:
      • Login - Type a database account that has the required database permissions.
      • Password - Type the password for the database account.

Additional Information

The following BlackBerry Dispatcher log file entries show that the connection failed:
[20659] (10/12 22:46:02.765):{0x884} GetSQLServerVer: COM exception
[20641] (10/12 22:46:02.765):{0x884} COM Error 0x4632D0 in GetSQLServerVer - Timeout expired - IDispatch error #3121
[20642] (10/12 22:46:02.765):{0x884} Database error in GetDBMSVer (err=0x80040E31, native err=0) - Timeout expired
[20659] (10/12 22:46:03.015):{0x884} CheckValidConnection: COM exception
[20641] (10/12 22:46:03.015):{0x884} COM Error 0x4632D0 in CheckValidConnection - Connection failure - Unspecified error
[20642] (10/12 22:46:03.015):{0x884} Database error in CheckValidConnection (err=0x80004005, native err=0) - Connection failure