05-26-2009, 02:12 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
KB15058 - How to prepare BES for Exchange to support DST changes in 2008
KB15058 - How to prepare BlackBerry Enterprise Server for Microsoft Exchange to support DST changes in 2008
Environment
- BlackBerry® Enterprise Server version 4.0 Service Pack 7 (4.0.7) and 4.1 for Microsoft® Exchange
- BlackBerry smartphones
- SDR159527
- SDR138787
Overview
BlackBerry Enterprise Server for Microsoft Exchange
To support the Daylight Savings Time (DST) 2008 changes to the BlackBerry Enterprise Server for Microsoft Exchange, complete the following steps:
- To support the time zone changes, a Microsoft® Windows® operating system must have a Windows time zone update applied. If the time zone update is not applied, the TimeZoneUpdate[DATE].zip script will not function as intended. For more information, go to www.support.microsoft.com and search for article 951072.
- The new time zone information provided by CDO.dll must be applied to the BlackBerry Enterprise Server. For more information, go to www.support.microsoft.com and search for article 943068.
Note: A known issue exists as a result of applying the CDO.dll change. A duplicate appointment may occur if meetings are updated after they have been accepted.
Modify BlackBerry Enterprise Server registry to add time zone information
Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Windows operating system. Document and back up the registry entries prior to implementing any changes.
Complete the following steps:
- Download the Update_for_CDO_6.5.7653.21-6.5.7974.0.reg file attachment to the BlackBerry Enterprise Server.
- Double-click the file to apply the changes.
- Restart the BlackBerry Enterprise Server. Important: Restarting the BlackBerry Enterprise Server will delay email message delivery to BlackBerry smartphones. For more information, see KB04789.
- Download and run one of the following attached script files on the BlackBerry Enterprise Server. For instructions, see the Additional Information section in this article.
- For BlackBerry Enterprise Server software version 4.0, download the TimeZoneUpdateFall2008-BES4.0.zip file attachment.
- For BlackBerry Enterprise Server software version 4.1, download the TimeZoneUpdateFall2008-BES4.1.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.
Note: An alternative to using the TimeZoneUpdate[DATE].zip script to update BlackBerry smartphone time zones is to apply the DST 2008 patch wirelessly through the BlackBerry smartphone or through the BlackBerry Enterprise Server, as described in the following section.
BlackBerry smartphones
Warning: If you apply the DST 2008 time zone change to a BlackBerry smartphone that is already patched, or if you activate a new BlackBerry smartphone with the correct DST values against a BlackBerry Enterprise Server that does not have the newest time zone table, the BlackBerry Enterprise Server will override the values on the BlackBerry smartphone.
The patch can also be deployed to BlackBerry smartphones from the BlackBerry Enterprise Server. For instructions on preparing a software configuration for wireless deployment, see KB03748.
Downloads and most recent DST updates
To find the most up-to-date downloads and DST information, see KB16182.
Additional Information
Running the script against the BlackBerry Configuration Database
When running the LoadSyncDeviceConfig.sql script (located in the attached TimeZoneUpdate20080207.zip file), you can customize how this script is processed by using various switches. The following tables list the required and optional switches to run this 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 TimeZoneUpdate20080207.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.
Complete the following steps:
- 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 (MDSE), 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
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 the 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 <Database Name> -dbms <SQL> -n <SQL Server Name> -dbauth -dbuser <User Name> -dbpass <Password> -input <.\SQLServer\LoadSyncDeviceConfig.sql>
where
- is the name of the BlackBerry Configuration Database
- <SQL> 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
- <Password> 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.
|
Linear Mode
