BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-06-2008, 12:08 PM   #1 (permalink)
New Member
 
Join Date: Aug 2008
Model: None
PIN: N/A
Carrier: AT&T
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default [ODBC SQL Server Driver][SQL Server]Login failed for user

Please Login to Remove!

Morning,

I am new to BES and this was my first install. Everything is working incuding emails, calendar, etc but I keep getting this error in the event logs and I have yet to find a solution for it.

<2008-08-06 07:29:48.730 AKDT>:[23]:<MDS-CS_V-BES_MDS-CS_1>:<ERROR>:<LAYER = SCM, EVENT = java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user

Everytime I start the Blackberry MDS Connection Service it gives this error.

Here is all the info:

BES: 4.1.6.26 on its own server
Exchange 2007 SP1 on its own server
SQL 2005 on its own server

Any help would be great. Thanks!

Shawn
Offline  
Old 08-06-2008, 02:01 PM   #2 (permalink)
New Member
 
Join Date: Aug 2008
Model: None
PIN: N/A
Carrier: AT&T
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default More Info.

Here is what I found in the log files. Is it supposed to try and login with the sever name? If not, where do I change the user name?

<2008-08-06 09:33:26.320 AKDT>:[52]:<MDS-CS_V-BES_MDS-CS_1>:<WARNG>:<LAYER = SCM, EVENT = server could not update its configuration entry in database, due to java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'CARLILE\V-BES$'.>
<2008-08-06 09:33:26.320 AKDT>:[53]:<MDS-CS_V-BES_MDS-CS_1>:<EVENT>:<LAYER = SCM, EVENT = MDS-CS server has started>
<2008-08-06 09:33:27.492 AKDT>:[54]:<MDS-CS_V-BES_MDS-CS_1>:<INFO >:<LAYER = SCM, initiate server shutdown from native code>
<2008-08-06 09:33:27.961 AKDT>:[55]:<MDS-CS_V-BES_MDS-CS_1>:<DEBUG>:<LAYER = SCM, Web Server Started>
<2008-08-06 09:33:30.586 AKDT>:[56]:<MDS-CS_V-BES_MDS-CS_1>:<EVENT>:<LAYER = SCM, EVENT = MDS-CS server has stopped>
<2008-08-06 09:33:30.586 AKDT>:[57]:<MDS-CS_V-BES_MDS-CS_1>:<DEBUG>:<LAYER = SCM, EVENT = Statistics save task started>
<2008-08-06 09:33:30.586 AKDT>:[58]:<MDS-CS_V-BES_MDS-CS_1>:<DEBUG>:<LAYER = SCM, EVENT = Statistics save task finished -- number of rows inserted:6>
<2008-08-06 09:33:30.586 AKDT>:[59]:<MDS-CS_V-BES_MDS-CS_1>:<INFO >:<LAYER = SCM, EVENT = JDBC Service stopping. Waiting maximum wait time: 1 minute(s)>
<2008-08-06 09:33:30.586 AKDT>:[60]:<MDS-CS_V-BES_MDS-CS_1>:<EVENT>:<LAYER = SCM, EVENT = MDS-CS server disconnects from the database>
<2008-08-06 09:33:30.601 AKDT>:[61]:<MDS-CS_V-BES_MDS-CS_1>:<EVENT>:<LAYER = SCM, EVENT = MDS-CS server disconnects from the database>
Offline  
Old 08-06-2008, 08:07 PM   #3 (permalink)
Thumbs Must Hurt
 
Keyscan's Avatar
 
Join Date: Aug 2007
Model: 8800
PIN: N/A
Carrier: Rogers
Posts: 140
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is the NetBIOS computer name of your BES? The netbios name must be reflected in the MDS_CS server name.

Read through this:

BlackBerry MDS Connection Service starts and stops unexpectedly
Doc ID : KB11117
Last Modified : 2008-02-26
Document Type : Support
BlackBerry Search Results

And this:

Unable to Start the BlackBerry MDS Connection Service after upgrading to software version 4.1 service pack 2
Doc ID : KB10865
Last Modified : 2007-03-26
Document Type : Support
BlackBerry Search Results
__________________
BES 4.1.4 - Exchange 2003
8800 and my trusty 8700r.
To change your PIN to FFFFFFFF, drop the BB in a lake.

Last edited by Keyscan : 08-06-2008 at 08:08 PM.
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





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