Install the BlackBerry database notification system

The BlackBerry® database notification system 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 is installed on a computer that is separate from 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.
  • Your database server must run on Windows Server® 2003.
  1. On the database server, open the BlackBerry Enterprise Server installation media.
  2. Perform one of the following actions:
    • If 32-bit Microsoft® SQL Server® 2003 is running in your organization's environment, in the Tools\DBNS folder, copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
    • If a 64-bit Microsoft SQL Server 2003 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 Query Analyzer.
  4. Use the Microsoft SQL Query Analyzer console, navigate to Database\DBInstallScripts\SQLServer\4.1.2 on the BlackBerry Enterprise Server installation media.
  5. Open the NotifyInstall.sql file.
  6. Change <_DATABASENAME_> to the name of the BlackBerry Configuration Database (for example, BesMgmt).
  7. Run the script.
  8. Confirm that the Microsoft SQL Query Analyzer displays the "Function dbo.xp_RIMxxxx registered" message.
  9. To create additional BlackBerry Configuration Database instances in your organization's environment, repeat steps 7 to 10.

Was this information helpful? Send us your comments.