Monday, May 17, 2010

BlackBerry Express Dispatcher service fails to start

Recently in an installation of BB Express with SQL Server 2005 Express I had some issues with the Dispatcher and SQL.

Event Type: Warning
Event Source: BlackBerry Dispatcher pubBESExpress
Event Category: None
Event ID: 25137
Date: 5/17/2010
Time: 10:11:24 AM
User: N/A
Computer:
Description:
{ConnectionItem::ConnectToDB} Failed to connect. Connection string is Provider=SQLNCLI.1;Server=servername\SQLEXPRESS;Database=BESMgmt;

This error was followed by:
Event Type: Warning
Event Source: BlackBerry Dispatcher pubBESExpress
Event Category: None
Event ID: 25105
Date: 5/17/2010
Time: 10:11:24 AM
User: N/A
Computer:
Description:
Failed to authenticate connection - local machine time may be out of sync with domain controller time. Please restart Windows Time Service.

I eventually found this here: http://supportforums.blackberry.com/t5/BlackBerry-Enterprise-Server/BES-5-0-Post-installation-Issues/td-p/420078 where Keithk23 nails it.

Set the SQL Browser service to automatic and started it and all was well.