During an installation of the BlackBerry® Enterprise Server, where the BlackBerry Configuration Database is installed locally, a custom event-based notification system is installed. This Database Notification System is designed to reduce the number of database queries made by the BlackBerry Enterprise Server to the BlackBerry Configuration Database.

When the BlackBerry Configuration Database is created on a remote database server, the Database Notification System is not installed automatically. The Database Notification System can be installed manually after the BlackBerry Enterprise Server has been installed.

Note: The paths mentioned below are all relative to the root of the installation media or the root of the extracted BlackBerry Enterprise Server setup files from the downloaded software.

Installing the Database Notification System

Complete the following instructions to install the Database Notification System:

1.      Connect to the Microsoft® SQL Server® instance using an account with System Administrator permissions.

2.      On the database server, open the BlackBerry Enterprise Server installation media.

3.      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 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

For Microsoft SQL Server 2008 R2, in the Tools\DBNS\x64 folder, copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL10.<SQLSERVER_NAME>\MSSQL\Binn

4.      In the SQL Query Analyzer, browse to the following location depending on the BlackBerry Enterprise Server version:

BlackBerry Enterprise Server 4.1 SP1

\Database\DBInstallScripts\SQLServer\4.1

BlackBerry Enterprise Server 4.1 SP2 to 4.1 SP7

\Database\DBInstallScripts\SQLServer\4.1.2

BlackBerry Enterprise Server 5.0 to 5.0 SP3

\Database\DBInstallScripts\SQLServer\5.0

5.      Perform one of the following actions:

BlackBerry Enterprise Server 4.1 SP1 to SP7

Proceed to step 6.

BlackBerry Enterprise Server 5.0 to 5.0 SP3

Open the NotifyMasterInstall.sql file.

Run the script.

6.      Open the NotifyInstall.sql file.

7.      Change <_DATABASENAME_> to the name of the BlackBerry Configuration Database (for example, BESMgmt).

8.      Run the script.

9.      Confirm that the SQL Query Analyzer displays the message Function dbo.xp_RIM_xxxx registered.

To create additional BlackBerry Configuration Database instances in your organization's environment, repeat steps 7 to 10.

Removing the DBNS

Complete the following instructions to remove the DBNS:

1. In the SQL Query Analyzer, browse to the following location depending on the BlackBerry Enterprise Server version:
   
   
   BlackBerry Enterprise Server 4.1 SP1
   
   \Database\DBInstallScripts\SQLServer\4.1
   
   BlackBerry Enterprise Server 4.1 SP2 to 4.1 SP7
   
   \Database\DBInstallScripts\SQLServer\4.1.2
   
   BlackBerry Enterprise Server 5.0 to 5.0 SP3
   
   \Database\DBInstallScripts\SQLServer\
   
   
2. Open the NotifyUnInstall.sql file.
3. Change <_DATABASENAME_> to the name of the BlackBerry Configuration Database (for example, BESMgmt).
4. Run the script.
5. On the Microsoft SQL Server, browse to C:\Program Files\Microsoft SQL Server\MSSQL\Binn and remove the RimEsp.dll file.

To complete the removal of the Database Notification System, it may be necessary to restart the Microsoft SQL Server. If it is not possible to restart the Microsoft SQL Server, rename the RimEsp.dll file (for example, to RimEspXXX.tmp).

• BlackBerry® Enterprise Server 4.1 SP1 to 5.0 SP3
• Microsoft® SQL Server®