06-29-2009, 01:01 AM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,036
|
|
KB11716 - How to install a server based notification service on a remote SQL Server
KB11716 - How to install a server based notification service on a remote Microsoft SQL Server
Environment
- BlackBerry® Enterprise Server software version 4.1
- Microsoft® SQL Server®
Overview
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 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.
To install the database notification system
- Connect to the Microsoft SQL Server instance using an account with System Administration permissions.
- Copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
- In the SQL Query Analyzer, browse to the following location depending on the BlackBerry Enterprise Server version. BlackBerry Enterprise Server software version 4.1
BlackBerry Enterprise Server software version 4.1 Service Pack 1
<drive>\Database\DBInstallScripts\SQLServer\4.1 folder on the installation media.
BlackBerry Enterprise Server software version 4.1 Service Pack 2 through Service Pack 6
<drive>\Database\DBInstallScripts\SQLServer\4.1.2 folder on the installation media.
- Open the NotifyInstall.sql file and replace _DATABASENAME_ with the name of your BlackBerry Configuration Database.
- Run the script.
- Confirm that the SQL Query Analyzer displays the message Function dbo.xp_RIM_xxxx registered.
- Repeat steps 1 through 6 for each additional BlackBerry Configuration Database in the environment.
Remove the database notification system
- In the SQL Query Analyzer, browse to the following location depending on the BlackBerry Enterprise Server version. BlackBerry Enterprise Server software version 4.1
BlackBerry Enterprise Server software version 4.1 Service Pack 1
<drive>\Database\DBInstallScripts\SQLServer\4.1 folder on the installation media.
BlackBerry Enterprise Server software version 4.1 Service Pack 2 through Service Pack 6
<drive>\Database\DBInstallScripts\SQLServer\4.1.2 folder on the installation media.
- Open the NotifyUnInstall.sql file.
- Perform one of the following actions: Remove the database notification system from one BlackBerry Configuration Database.
Remove all commands after -- delete notification stored procedures and -- delete notification tables. - Run the script.
Remove the database notification system from all BlackBerry Configuration Databases.
- Run the script.
- At C:\Program Files\Microsoft SQL Server\MSSQL\Binn, 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).
__________________
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
