BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 02-21-2008, 05:08 AM   #1
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default Tomcat/SQL Problem

Please Login to Remove!

Hi. I've got a BES Enterprise Server 4.1.4 and Microsoft SQL Base on the same machine. It's running under SBS2003 and it's a version for Exchange.
I can't go to mds configuration. I've read about 3 steps recommended for BB (Certificates, Proxy, ...) and it doesn't help for my situation.

When i'm trying to go in to mds throught BBManager i'm asking about Login and Pass. I'm sure that what i'm writing there is correct. The same situation is when i'm trying to go into mds by https.

I can add that in services i'm worried about:
- BB Instant Messaging Connector - i can't run it service,
- BB MDS Services - Apache Tomcat Service - after 2 seconds from running it's stops.

Do you have any ideas to resolve my problem?

Tomcat is running for me indyvidually (startup.bat). After logging it's something this in log file:

[ERROR][2008-02-21 09:54:12,847][[Catalina]]Exception performing authentication
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'admin'. Reason: Not associated with a trusted SQL Server connection.)

Last edited by oriontg; 02-21-2008 at 05:12 AM.. Reason: Additonal information about problem
Offline  
Old 02-21-2008, 05:39 AM   #2
bl0rb
Knows Where the Search Button Is
 
Join Date: Apr 2006
Location: Görlitz
Model: 8800
Carrier: T-Mobile DE
Posts: 29
Default

Please check KB12235...

cause 2 and 3 are relevant.

Link:

BlackBerry Search Results
Offline  
Old 02-21-2008, 05:53 AM   #3
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

Thank You bI0rb for answer, but it doesn't help.
Port's numbers are the same (1433), and login and pass is correct and the same. Do you have any ideas?
Offline  
Old 02-21-2008, 06:16 AM   #4
bl0rb
Knows Where the Search Button Is
 
Join Date: Apr 2006
Location: Görlitz
Model: 8800
Carrier: T-Mobile DE
Posts: 29
Default

Have you installed msde with additional parameter "SECURITYMODE=SQL"
Offline  
Old 02-21-2008, 06:40 AM   #5
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

no, i didn't. Should I reinstal msde?
Offline  
Old 02-21-2008, 06:45 AM   #6
gibson_hg
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Default

Not sure if you know or not but the MDS Apache Tomcat service is not needed for web browsing. That service is only needed if you plan to create and publish BB apps developed by your company.

The MDS Connection Service is for web browsing.

What happens when you try to run the instant message connector? Any errors pop up? Any errors in the Event Viewer?

If you are getting prompted for a login and password when you click on the MDSS URL in the BB Manager it is the login and pass you picked during the install of the MDS Service.

If you don't need the service and you have no active users just clean uninstall and reinstall the BES. Might be easier on ya. You mght want to think about moving your BES to another machine as well. BES/DC/Exchange/MSDE on one machine is never a good combo.
Offline  
Old 02-21-2008, 06:59 AM   #7
bl0rb
Knows Where the Search Button Is
 
Join Date: Apr 2006
Location: Görlitz
Model: 8800
Carrier: T-Mobile DE
Posts: 29
Default

I had the same problem on the test system.

Turn on Mixed Mode Authentication after you install MSDE
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

By default, the value of the LoginMode Windows registry subkey is set to 1 for Windows Authentication. To turn on Mixed Mode authentication after you install MSDE, you must change this value to 2. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance.xxx8226; If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
xxx8226; If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode

To change the value of LoginMode to 2, follow these steps:1. In Control Panel, open the Services tool, and then stop MSSQLSERVER and all other related services (such as SQLSERVERAgent).
2. On the Start menu, click Run, type regedt32, and then click OK to start Registry Editor.
3. Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance): xxx8226; HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer\

-or-
xxx8226; HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\

4. In the right pane, double-click the LoginMode subkey.
5. In the DWORD Editor dialog box, set the value of this subkey to 2, verify that the Hex option is selected, and then click OK.
6. Restart the MSSQLSERVER service and the SQLSERVERAgent service for this change to take effect.
Offline  
Old 02-21-2008, 07:00 AM   #8
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

When i'm trying to run the instant message connector it's a popup: It's impossible to run BBIMC on local computer. Error: 1075 - dependence service isn't exsist or will be deleted.

In event viewer i've got a notification that BlackBerry Instant Messaging Connector service depends on MSMQ service, which isn't exist.

When i'm getting prompted for a login and password and click on the MDSS URL in the BB Manager there is no login and pass.

Actually i've got only this machine available.


Login mode is mixed - the value is set to 2. I don't have change it.

Last edited by oriontg; 02-21-2008 at 07:05 AM..
Offline  
Old 02-21-2008, 07:04 AM   #9
gibson_hg
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Default

You need the MSMQ service installed to use the Instant Message Connector, it's a necessary component.

Again, if you don't need the Instant Message service or MDSS service and you have no active users then clean uninstall the BES and reinstall or just disable those services and forget about them.
Offline  
Old 02-21-2008, 07:21 AM   #10
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

Ok, so only way to resolve my problem is reinstal bes and before this instal msde with SECURITYMODE=SQL? Should it solve my problem?

No any ideas?

Last edited by oriontg; 02-21-2008 at 07:54 AM..
Offline  
Old 02-21-2008, 08:23 AM   #11
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

Information from the BES log after logging to MDS through BB Manager.

[30000] (02/21 13:40:12.334):{0x27FC} Bad hResult 0x80004003, at mdsagview.cpp line 384, from AG call CMDSAGView::PrepareData - getServerStatus, source - MDSAGAdminMgmt, error - Odwoxxx322;anie do obiektu nie zostaxxx322;o ustawione na wystxxx261;pienie obiektu. - "Link to this object wasn't set on object performance".


Maybe there is another reason ?
Offline  
Old 02-22-2008, 03:27 AM   #12
oriontg
New Member
 
Join Date: Feb 2008
Model: 8800
PIN: N/A
Carrier: administrator
Posts: 9
Default

Thanx for help. Everything is working fine - i had to change my SAP-key, because it was wrong.
Offline  
Closed Thread



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


OEM Dell XPS 8910 8920 8930 Alienware Aurora R5 R6 R7 Front Cooling Fan 7M0F5 picture

OEM Dell XPS 8910 8920 8930 Alienware Aurora R5 R6 R7 Front Cooling Fan 7M0F5

$14.63



Dell OEM Latitude Rugged Extreme 7404 GPS Antenna Junction Cable Cable KMX0M picture

Dell OEM Latitude Rugged Extreme 7404 GPS Antenna Junction Cable Cable KMX0M

$2.95



Dell OEM Latitude Rugged Extreme 7404 Left and Right Mouse Buttons 00008 picture

Dell OEM Latitude Rugged Extreme 7404 Left and Right Mouse Buttons 00008

$5.95



NEW VESA ADAPTER PLATE FOR DELL E-SERIES MONITORS - OEM picture

NEW VESA ADAPTER PLATE FOR DELL E-SERIES MONITORS - OEM

$8.49



DELL 330-6581 3306581 725-10229 OEM LAMP FOR 1510X 1610HD 1610X  - Made By DELL picture

DELL 330-6581 3306581 725-10229 OEM LAMP FOR 1510X 1610HD 1610X - Made By DELL

$39.98



6 New OEM Dell 1320c,1320cn CCMMMK Toner Cart WM138, KU051, DT615 Same Day Ship picture

6 New OEM Dell 1320c,1320cn CCMMMK Toner Cart WM138, KU051, DT615 Same Day Ship

$148.00







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