Folks, sometimes due to re-org or hardware upgrades, we die die must cutover the BES to a new box. From many support experience, we find that we almost certainly will 100% forgot about the NEW box permissions (and hence the connectivity) to the poor SQL server that housed the BESMgmt database.
MAGT logs will have these error if you have forgotten the SQL server out of your battle plan:-
NT AUTHORITY\ANONYMOUS LOGON'.0x80040E4D NativeError=18456
Unable to open BESMgmt database: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Unable to open BESMgmt database: SQL Network Interfaces: The target principal name is incorrect. 0x80004005 NativeError=-21468930220x80004005
Login failed for user '<computer_name$>'
No fear, below are the checklist to help remind all:-
The BlackBerry Messaging Agent can authenticate with the Microsoft SQL Server using Windows credentials, or SQL Authentication. Complete one of the two steps below based on what is appropriate in your environment.
Configuring the BlackBerry Messaging Agent to authenticate with Windows Trusted Authentication:
Check the Windows Services on the BlackBerry Enterprise Server and determine the
Log On As settings for the Lotus Domino Server service. This is typically called
Lotus Domino Server.
- If the Lotus Domino service logs on as "Local System", please follow the instructions in KB12096 to configure the SQL Server.
Basically you need to grant in SQL server the permission to the account <DOMAIN>\<COMPUTER_NAME>$- If the Lotus Domino service logs on as a Windows Domain Account, please change the Domain user for the Lotus Domino service to match the user that logs on the BlackBerry Enterprise Server services, which should already have the SQL permissions needed.
Configuring the BlackBerry Messaging Agent to authenticate using SQL Authentication:
Please follow the instructions found in
KB04260 to add/check the SQL Authentication settings for the Messaging Agent.
Basically, you will need to create a registry key to include the Login and Password values for the SQL account:-
HKEY_USERS\.DEFAULT\SOFTWARE\Research In Motion\BlackBerry Enterprise Server\Database
Have fun!