BlackBerry MDS Services - Apache Tomcat Service will not start

[BESadmin]

BlackBerry MDS Services - Apache Tomcat Service will not start

Doc ID : KB12235
Last Modified : 2007-07-11
Document Type : Support


Environment

• BlackBerry® Enterprise Server software version 4.1.x

Problem

BlackBerry® Mobile Data System (BlackBerry MDS) Services - Apache Tomcat™ Service starts and stops immediately. No error message appears.

Cause

This issue may be caused by one of the following:

1. TCP/IP and Named Pipes are not enabled in the Microsoft® SQL Server™ Network Utility.
2. TCP/IP for the BlackBerry MDS Services – Apache Tomcat Service and the database server program are not configured to communicate on the same port.
3. The SQL account password that BlackBerry MDS Services - Apache Tomcat Service uses is incorrect.

Resolution

Complete the appropiate resolution for the cause.

Cause 1

TCP/IP and Named Pipes are not enabled in the SQL Server Network Utility.

Resolution

1. Enable the TCP/IP and Named Pipes protocols. For instructions, refer to the Microsoft Support Knowledge Base.
2. Stop all BlackBerry services.
3. Restart the Microsoft SQL Service.
4. Start the BlackBerry services. Note: See KB13718 for the order in which to stop and start BlackBerry services.

Cause 2

TCP/IP for the BlackBerry MDS Services – Apache Tomcat Service and the database server program are not configured to communicate on the same port

Resolution


1. Verify the TCP/IP port the database server program is configured to use.

For Microsoft SQL Server Desktop Engine (MSDE) and Microsoft SQL Server 2000

1. On the computer on which the SQL database resides, go to Start > Run and type svrnetcn in the Open field.
2. Select TCP/IP in the Enabled Protocols list.
3. Click the Properties button.
4. Record the default port listed.

For Microsoft SQL Server 2005

1. Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.
2. In the SQL Server Configuration Manager, expand SQL Server Network Configuration.
3. Click Protocols for MSSQLServer.
4. On the right-hand window, double-click TCP/IP.
5. Click the IP Addresses tab.
6. Record the TCP Port values.

2. Determine the TCP/IP port used by BlackBerry MDS Services – Apache Tomcat Service.

1. Open the server.xml file located in C:\Program Files\Research In Motion\BlackBerry Enterprise Server\MDSS\jakarta-tomcat-5.5.9\conf\.
2. Locate the following line:
   
   <Resource name="jdbc/db_server" auth="Container" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLS erverDriver" url="jdbc:sqlserver://SQLSERVERNAME:1433;databaseName=mdss;forwardReadOnlyMethod=serverCur sor" username="admin" password="password" connectionProperties="" maxActive="75" maxIdle="75" maxWait="10000"/> where ‘1433’ indicates the port the BlackBerry MDS Services – Apache Tomcat Service is using to connect to the Microsoft SQL Server
3. To change the port the BlackBerry MDS Services – Apache Tomcat service uses to communicate to the Microsoft SQL Server, edit the server.xml port values to correspond with the values recorded from the database program. There are 3 identical lines in the server.xml that will need to be edited. Each line has the following format:

<Resource name="jdbc/db_server" auth="Container" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLS erverDriver" url="jdbc:sqlserver://SQLSERVERNAME:1433;databaseName=mdss;forwardReadOnlyMethod=serverCur sor" username="admin" password="password" connectionProperties="" maxActive="75" maxIdle="75" maxWait="10000"/>

Cause 3

An incorrect password is specified for the SQL account created during the BlackBerry Enterprise Server installation and used by the BlackBerry MDS Services - Apache Tomcat Service.

Resolution


The username and password of the SQL account is recorded in the server.xml file located in C:\Program Files\Research In Motion\BlackBerry Enterprise Server\MDSS\jakarta-tomcat-5.5.9\conf\.

<Resource name="jdbc/db_server" auth="Container" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLS erverDriver" url="jdbc:sqlserver://SQLSERVERNAME:1433;databaseName=mdss;forwardReadOn lyMethod=serverCursor" username="admin" password="password" connectionProperties="" maxActive="75" maxIdle="75" maxWait="10000"/>

In the above example, “admin” is the name of the SQL user account and “password” is the password of the “admin” account. Verify the username and password of the account in the database program.

For MSDE

1. Ensure you are logged into the BlackBerry Enterprise Server as the BlackBerry service account.
2. Go to Start > Run and type svrnetcn in the Open field.
3. Type osql –E and press Enter.
4. Type the following commands in the specified order:

1. 1> sp_password @old = null, @new = 'password', @loginame ='admin’

   2> go

where ‘password’ is the password listed in the server.xml file and ‘admin’ is the name of the SQL account listed in the server.xml file

For Microsoft SQL Server 2000

1. Go to Start > All Programs > Microsoft SQL Server > Enterprise Manager.
2. Expand SQL Server.
3. Expand the Security folder.
4. Click Logins.
5. Locate the SQL account that is recorded in the server.xml file.
6. Right-click the account and select Properties.
7. Re-type the password as it appears in the server.xml file.
8. Click OK.

For Microsoft SQL Server 2005

1. Go to Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
2. Expand the SQL Server.
3. Expand the Security folder.
4. Expand the Logins folder.
5. Locate the SQL account that is recorded in the server.xml file.
6. Right-click the account and select Properties.
7. Re-type the password as it appears in the server.xml folder.
8. Confirm the password and click OK.