BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-06-2008, 11:08 AM   #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, 01: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, 07: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 07:08 PM.
Offline  




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