Installation and Configuration Guide

Local Navigation

Install 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 makes to the BlackBerry Configuration Database.

If you create the BlackBerry Configuration Database on the computer that hosts the BlackBerry Enterprise Server, the BlackBerry database notification system installs automatically.

If you create 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, you can install the BlackBerry database notification system manually after you complete the BlackBerry Enterprise Server installation process.

Before you begin:
  • You must have the system administrator permission for the database.
  • The database server must run on Windows Server® 2003 or later.
  1. On the database server, open the BlackBerry Enterprise Server installation files.
  2. Perform one of the following actions:
    • If a 32-bit Microsoft® SQL Server® 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 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 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.

Was this information helpful? Send us your comments.