
05-26-2009, 02:38 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,246
|
|
KB18251 - How to prepare BES for Microsoft Exchange to support DST 2009
KB18251 - How to prepare BlackBerry Enterprise Server for Microsoft Exchange to support DST changes in 2009
Environment
- BlackBerry® Enterprise Server versions 4.1 SP3 and later for Microsoft® Exchange
Overview
BlackBerry Enterprise Server for Microsoft Exchange
To support the Daylight Savings Time (DST) 2009 changes to the BlackBerry Enterprise Server for Microsoft Exchange, complete the following steps:
- To support the time zone changes, the Windows® operating system must have a time zone update applied. If the Windows time zone update is not applied, the TimeZoneUpdate[DATE].zip script will not function as intended. For more information, search for article 970084 on the Microsoft Support web site.
- Ensure CDO.dll on the BlackBerry Enterprise Server is 6.5.7654.01 or higher; or 6.5.8067.0 or higher.
BlackBerry Enterprise Server Registry modifications to add time zone information
- Download and run the attached script file TimeZoneUpdate[DATE].zip on the BlackBerry Enterprise Server. For instructions, see the Additional Info section in this article.
- For BlackBerry Enterprise Server software version 4.1, download the TimeZoneUpdateSpring2009-BES4.1.zip file attachment.
- For BlackBerry Enterprise Server software version 5.0, download the TimeZoneUpdateSpring2009-BES5.0.zip file attachment.
The script updates the BlackBerry Enterprise Server through the BlackBerry Configuration Database, which starts an update with the BlackBerry smartphone time zone databases using a slow synchronization process.
Downloads and most recent DST updates
To find the most up-to-date downloads and DST information, see KB18250.
Additional Information
Running the script against the BlackBerry Configuration Database
When running the LoadSyncDeviceConfig.sql script (located in the attached TimeZoneUpdate[DATE].zip file), you can customize how the LoadSyncDeviceConfig.sql script is processed by using various switches. The following tables list the required and optional switches to run the LoadSyncDeviceConfig.sql script.
Required Switches
| -db | Use this switch to specify the BlackBerry Configuration Database name. The default name is BESMgmt. | | -n | Use this switch to specify the location of the Microsoft® SQL Server®. | | -input | Specifies which LoadSyncDeviceConfig.sql script to run. The BlackBerry Configuration Database is compatible with both Microsoft SQL Server and IBM® DB2® Universal Database. The attached TimeZoneUpdate[DATE].zip contains two scripts, one for Microsoft SQL Server and one for IBM DB2 Universal Database. | Optional Switches
| -dbms | Use this switch to specify if you are using a Microsoft SQL Server or IBM DB2 Universal Database to host the BlackBerry Configuration Database. The default option is SQL.
| | -dbauth | Use this switch to enable Microsoft SQL Server authentication. If this switch is not used, Windows authentication is used. | | -dbuser | Use this switch to specify the user name to be used with the Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used. | | -dbpass | Use this switch to specify the password to be used with the Microsoft SQL Server authentication. This switch is required if the -dbauth switch is used. |
Running the TimeZoneUpdate[DATE].zip Update
Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
- Download the attached TimeZoneUpdate[DATE].zip file and extract it to the BlackBerry Enterprise Server. Important: Do not modify the file structure of TimeZoneUpdate[DATE].zip.
- If you are using Microsoft SQL Server or Microsoft® SQL Server® Desktop Engine (MSDE), go to the TimeZoneUpdate[DATE\SQLServer folder and open the LoadSyncDeviceConfig.sql file using a text editor, such as Notepad.
- Modify the following line to specify the name of the BlackBerry Configuration Database: USE "_DATABASENAME_"
For example, USE BESMGMT
- Save the changes and close the file.
- On the BlackBerry Enterprise Server, open a command prompt.
- Navigate to the root folder where the LoadSyncDeviceConfig.sql script is contained.
- Type the appropriate command for your environment. The following is an example using the default BlackBerry Configuration Database name and a remote Microsoft SQL Server: BBDBUpdate.exe -db BESMgmt -n SQL.domain.com -input .\SQLServer\LoadSyncDeviceConfig.sql
The full command syntax is as follows:
BBDBUpdate.exe -db -dbms -n -dbauth -dbuser -dbpass -input <.\SQLServer\LoadSyncDeviceConfig.sql>
where
- is the name of the BlackBerry Configuration Database
- is selected if you are running a Microsoft SQL Server in your environment
- is the Microsoft SQL Server name
- is the appropriate user name for Microsoft SQL Server authentication
- is the appropriate password for Microsoft SQL Server authentication
- <.\SQLServer\LoadSyncDeviceConfig.sql> is the Microsoft SQL Server location for the LoadSyncDeviceConfig.sql script when using Microsoft SQL Server
__________________
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.
|