Upgrade Guide

Local Navigation

Upgrade the BlackBerry database notification system

The BlackBerry® database notification system is a publish/subscribe system that is designed to reduce the number of database queries that a BlackBerry® Enterprise Server Express makes to the BlackBerry Configuration Database.

If you upgrade the BlackBerry Configuration Database on the computer that hosts the BlackBerry Enterprise Server Express, the BlackBerry database notification system upgrades automatically.

If you upgrade the BlackBerry Configuration Database on a database server that you installed on a computer that is not the computer that hosts the BlackBerry Enterprise Server Express, you can upgrade the BlackBerry database notification system manually after you complete the BlackBerry Enterprise Server Express installation process.

Before you begin:
  • You must have the system administrator permission for the database.
  • The database server must run on Windows Server® 2003.
  1. On the database server, open the BlackBerry Enterprise Server Express installation files.
  2. Perform one of the following actions:
    • If a 32-bit Microsoft® SQL Server® 2005 is running in your organization's environment, in the Tools\DBNS\x86 folder, copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
    • If a 64-bit Microsoft SQL Server 2005 is running in your organization's environment, in the Tools\DBNS\x64 folder, copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
  3. Open the Microsoft SQL Server Management Studio.
  4. Using the Microsoft SQL Server Management Studio, navigate to Database\DBInstallScripts\SQLServer\5.0 in the BlackBerry Enterprise Server Express installation files.
  5. Open the NotifyMasterInstall.sql file.
  6. Run the script.
  7. Open the NotifyInstall.sql file.
  8. Change <_DATABASENAME_> to the name of the BlackBerry Configuration Database (for example, BesMgmt).
  9. Run the script.
  10. Confirm that the Microsoft SQL Server Management Studio displays the "Function dbo.xp_RIMxxxx registered" message.
  11. To add additional BlackBerry Configuration Database instances in your organization's environment, repeat steps 7 to 10.
  12. Restart the database server and the computer that hosts the BlackBerry Enterprise Server Express.

Was this information helpful? Send us your comments.