KB19076 - Page cannot be displayed and the BAS will not stay started


Environment

• BlackBerry® Enterprise Server version 5.0
• BlackBerry Administration Service
• Microsoft® SQL Server® 2005

---

Overview

If this issue is being experienced, the BlackBerry Administration Service - Application Server (BAS-AS) service will continuously restart. Also, you will not be able to log in to the web console.
The BAS-AS logs will display the following:
Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "" requested by the login. The login failed.)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalMan agedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(Int ernalManagedConnectionPool.java:577)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConn ectionPool.java:262)
(date):{main} [com.rim.bes.bas.authenticationmanager.AuthenticationManagerUtilities] [FATAL] [BBAS-4001] {unknown} initializeCredentialCacheAsRequired could not read credentials for BAS-AS, com.rim.bes.bas.util.BASCouldNotCompleteRequestRollbackException: Caught unhandled RuntimeException in org.jboss.ejb3.EJBContainerInvocation method getAuthenticationCredentialsLocal - org.hibernate.exception.GenericJDBCException: Cannot open connection

---

Cause

There is another instance on the Microsoft SQL Server that is using the port that the BlackBerry Administration Service - Application Server is configured to use.

---

Resolution

1) On the Microsoft SQL server, access Start -> Run -> CMD -> type netstat -an
2) Choose a port not currently in use, to confirm this, type the following command, netstat -an | find ":"

When a port is chosen, complete the following steps:

1) On the Microsoft SQL Server, access Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
2) Expand SQL Server 2005 Network Configuration, and select " Protocols for "
3) Double-click TCP/IP -> IP Addresses tab.
4) Navigate to the IPALL section, type the new port number chosen in the TCP Port field. Ensure that the TCP Dynamic Ports field is blank. when using netstat, Apply and OK.

NOTE: If necessary, in the IP1, and IP2 blocks, type the same port number in TCP Port fields.

5) Restart the Microsoft SQL Server instance Service, and ensure the SQL Server Browser Server Service is running.
6) On the BlackBerry Enterprise Server, go to Start -> All Programs -> BlackBerry Enterprise Server -> BlackBerry Server Configuration.
7) On the Database Connectivity Tab, ensure that Use dynamic ports or specify SQL port is not checked, and type your new port number in the field provided.
8) Stop the following BlackBerry Enterprise Server services:

9) Start the services in the same order. If the other BlackBerry Enterprise Server services do not start automatically, start them manually.

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.