IBM AH0QIKO Upgrade Guide - Page 63

Upgrade the BlackBerry database notification system, Before you begin, Tools\DBNS\x86, RimEsp.dll

Page 63 highlights

Upgrade Guide Upgrade the BlackBerry database notification system When you upgrade a BlackBerry® Enterprise Server, the setup application creates new MdsLogin.conf or krb5.conf files and creates backup versions of the old BlackBerry MDS Connection Service configuration files in the same location. If you changed the MdsLogin.conf or krb5.conf files before you perform the upgrade, you should restore the backup versions of the files so that the BlackBerry MDS Connection Service can authenticate BlackBerry devices with the content servers that use NTLM or Kerberos. 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 makes to the BlackBerry Configuration Database. If you upgrade the BlackBerry Configuration Database on the computer that hosts the BlackBerry Enterprise Server, 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, you can upgrade 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. 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® 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 installation files. 5. Open the NotifyMasterInstall.sql file. 6. Run the script. 7. Open the NotifyInstall.sql file. 8. Change 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 Databaseinstances in your organization's environment, repeat steps 7 to 10. 12. Restart the database server and the computer that hosts the BlackBerry Enterprise Server. 61

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88

When you upgrade a BlackBerry® Enterprise Server, the setup application creates new MdsLogin.conf or krb5.conf
files and creates backup versions of the old BlackBerry MDS Connection Service configuration files in the same
location. If you changed the MdsLogin.conf or krb5.conf files before you perform the upgrade, you should restore
the backup versions of the files so that the BlackBerry MDS Connection Service can authenticate BlackBerry devices
with the content servers that use NTLM or Kerberos.
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 makes to the BlackBerry Configuration Database.
If you upgrade the BlackBerry Configuration Database on the computer that hosts the BlackBerry Enterprise Server,
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, you can upgrade 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.
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® 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 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.
Upgrade Guide
Upgrade the BlackBerry database notification system
61