05-26-2009, 12:44 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,237
|
|
KB18176 - BlackBerry Administration Service user interface is not accessible ...
KB18176 - BlackBerry Administration Service user interface is not accessible due to mismatched SQL configuration settings
Environment
BlackBerry® Enterprise Server version 5.0
BlackBerry® Administration Service
Overview
When the install completes for BlackBerry Enterprise Server version 5.0, you may not be able to access the BlackBerry Administration Service user interface. In addition, if you try to restart the BlackBerry Administration Service Application Server it may start and immediately stop.
Cause
You are using a Microsoft® SQL Server® instance with your BlackBerry Enteprise Server installation that has conflicting settings (static or dynamic ports setup) to what is set in the BlackBerry Enterprise Server Configuration Tool on the Database Connectivity tab.
This issue will also result in the the BlackBerry Administration Service Application Server service starting and then stopping after a few minutes.
The following log lines will appear in the BBAS-AS log file if you are experiencing this problem:
[WARN] ... Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
Resolution
Check the database settings that the BlackBerry Enterprise Server is using by going under the BlackBerry Enterprise Server Configuration Tool on the Database Connectivity tab. Make sure that it matches the database settings on the Microsoft SQL Server.
For Microsoft SQL Server 2005:
- Open Microsoft SQL Configuration Manager, click Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager > SQL Server 2005 Network Configuration.
- Select the Microsoft SQL Server instance that contains the BlackBerry Configuration Database.
- Right-click TCP/IP and select Properties.
- Select the IP Addresses tab.
- For every Internet Protocol entry that is active (IP1, IP2, etc) confirm the settings here match the settings on the BlackBerry Enterprise Server Configuration Tool on the Database Connectivity tab. If the value does not match update the BlackBerry Enterprise Server.
- In Windows® Services, right-click each of the Microsoft SQL Services, and then select Restart.
- Restart the BlackBerry Administration Service - Administration Server from Windows Services.
For Microsoft SQL Server 2000/MSDE:
- Navigate to Start > Run and enter svrnetcn.exe and click OK.
- Locate the Microsoft SQL Server instance the BlackBerry Configuration Database is running on from the drop-down list on the General tab.
- Select TCP/IP from the Enabled protocols column and click Properties.
- Confirm that the value in the Default Port field matches the BlackBerry Server Configuration tool on the Database Connectivity tab. If the value does not match, update the BlackBerry Enterprise Server.
- Restart the Microsoft SQL Server service from the Windows Services console.
- Restart the BlackBerry Administration Service - Administration Server from Windows Services.
__________________
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.
|
Linear Mode
