BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 11-29-2009, 01:40 AM   #1 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Arrow Knowledge Sharing - BES Domino permission to remote SQL server

Please Login to Remove!

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!
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 12-16-2009, 02:22 AM   #2 (permalink)
New Member
 
Join Date: Dec 2009
Model: 8900
PIN: N/A
Carrier: Lotus Notes Admin
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a lot for this sharing!
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

1785-L40E/E Allen Bradley PLC 5/40E Ethernet Processor 1785-L40E Q01 SST-PFB
$1299.0
1785-L40E/E Allen Bradley PLC 5/40E Ethernet Processor 1785-L40E Q01 SST-PFB picture182026 New-No Box, FES Systems 725-02001C-001 Thermo-Power Processor Board
$831.98
182026 New-No Box, FES Systems 725-02001C-001 Thermo-Power Processor Board pictureOMRON CQM1-CPU45-EV1 / CQM1CPU45EV1 (REPAIR)
$5.5
OMRON CQM1-CPU45-EV1 / CQM1CPU45EV1 (REPAIR) pictureMITSUBISHI A2AS-CPU-S30 / A2ASCPUS30 (REPAIR)
$5.5
MITSUBISHI A2AS-CPU-S30 / A2ASCPUS30 (REPAIR) pictureOMRON CVM1-CPU11-EV1 / CVM1CPU11EV1 (REPAIR)
$5.5
OMRON CVM1-CPU11-EV1 / CVM1CPU11EV1 (REPAIR) picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.