BlackBerryForums.com : Your Number One BlackBerry Community      

»Sponsored Links




Reply
 
LinkBack Thread Tools
  (#1 (permalink)) Old
colinb Offline
New Member
 
Posts: 11
Join Date: Jun 2005
Location: Halifax, NS
Model: 8100
Carrier: Rogers
Default SQL 2005 64bit master ???? BES-service? - 07-10-2008, 10:50 AM

Hi All:

Operating BES 4.1.5 on Domino 8.0 with remote SQL 2005 64bit database windows auth..

Getting some failure audits in the app log on the SQL server, looks like the BES -service account is trying to connect to the master database and failing.

It does connect fine to the BESMgmt database, and through BES manager everything seems fine, but the failure audits are filling up the logs.

Anyone else see this?

CB
   
Reply With Quote
Sponsored Links
Please Login or Register to Remove these Advertisements!

  (#2 (permalink)) Old
hdawg Offline
BlackBerry Genius
 
hdawg's Avatar
 
Posts: 5,495
Join Date: Aug 2006
Model: hdawg
Carrier: hdawg
Default 07-11-2008, 07:53 AM

Nope, don't see it here. Is the account that is connecting to SQL a member of the sql role 'sysadmin' (it should be)?
   
Reply With Quote
  (#3 (permalink)) Old
colinb Offline
New Member
 
Posts: 11
Join Date: Jun 2005
Location: Halifax, NS
Model: 8100
Carrier: Rogers
Default 07-11-2008, 12:38 PM

Yeah it is.... But, turns out that when the BESMgmt was migrated to a new server the owner was set as sa, however in sql config I had set windows authentication only since sa is a sql built in account I had to change to mixed mode authentication! errors gone, lesson learned.

Thanks hdawg
   
Reply With Quote
  (#4 (permalink)) Old
hdawg Offline
BlackBerry Genius
 
hdawg's Avatar
 
Posts: 5,495
Join Date: Aug 2006
Model: hdawg
Carrier: hdawg
Default 07-11-2008, 01:49 PM

   
Reply With Quote
Reply


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






Copyright © 2004-2008 BlackBerryNews.com, BlackBerryFAQ.com, BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of Research In Motion Limited.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.1