IBM AH0QIKO Upgrade Guide - Page 70

Con minimum Microsoft SQL Server permissions for the Windows account

Page 70 highlights

Upgrade Guide Configuring a computer for monitoring Server and database roles rim_db_bes_server Description You can remove this role from the Windows account that the BlackBerry Enterprise Server uses to run after the setup application creates or upgrades the BlackBerry Configuration Database. The BlackBerry Enterprise Server requires this role to run the BlackBerry Enterprise Server services. The setup application or the createDB executable creates the role automatically when it creates the BlackBerry Configuration Database. This role is the minimum Microsoft SQL Server permission for running the BlackBerry Enterprise Server. Configure minimum Microsoft SQL Server permissions for the Windows account You can configure the minimum Microsoft® SQL Server® permissions for the Windows® account that the BlackBerry® Enterprise Server uses to run. 1. Open the Microsoft SQL Server console. 2. Expand Microsoft SQL Server > Security > Logins. 3. Right-click the Windows account that the BlackBerry Enterprise Server uses to run. Click Properties. 4. Map the Windows account to the BlackBerry Configuration Database. 5. Change the Database role membership to rim_db_bes_server. 6. Remove all other database role memberships. 7. Apply your changes. Configuring a computer for monitoring Configure the SNMP service for monitoring You can configure the SNMP service on the computer that hosts the BlackBerry® Enterprise Server so that the BlackBerry Monitoring Service can monitor BlackBerry Enterprise Server activity. Before you begin: Verify that the SNMP service is installed and running. 1. On a computer that hosts the BlackBerry Enterprise Server or BlackBerry Enterprise Server components, in the Windows® Services, right-click SNMP Service. Click Properties. 2. On the General tab, change the startup type to Automatic. 3. On the Traps tab, in the Community name field, type the community name for the SNMP service. The field is case-sensitive. 4. In the Trap Destinations section, add the IP address of the computer that hosts the BlackBerry Monitoring Service. 68

  • 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

Server and database roles
Description
You can remove this role from the Windows account that the BlackBerry
Enterprise Server uses to run after the setup application creates or upgrades
the BlackBerry Configuration Database.
rim_db_bes_server
The BlackBerry Enterprise Server requires this role to run the BlackBerry
Enterprise Server services. The setup application or the createDB
executable creates the role automatically when it creates the BlackBerry
Configuration Database.
This role is the minimum Microsoft SQL Server permission for running the
BlackBerry Enterprise Server.
Configure minimum Microsoft SQL Server permissions for the Windows
account
You can configure the minimum Microsoft® SQL Server® permissions for the Windows® account that the BlackBerry®
Enterprise Server uses to run.
1.
Open the Microsoft SQL Server console.
2.
Expand
Microsoft SQL Server > Security > Logins
.
3.
Right-click the Windows account that the BlackBerry Enterprise Server uses to run. Click
Properties
.
4.
Map the Windows account to the BlackBerry Configuration Database.
5.
Change the
Database role membership
to
rim_db_bes_server
.
6.
Remove all other database role memberships.
7.
Apply your changes.
Configuring a computer for monitoring
Configure the SNMP service for monitoring
You can configure the SNMP service on the computer that hosts the BlackBerry® Enterprise Server so that the
BlackBerry Monitoring Service can monitor BlackBerry Enterprise Server activity.
Before you begin:
Verify that the SNMP service is installed and running.
1.
On a computer that hosts the BlackBerry Enterprise Server or BlackBerry Enterprise Server components, in the
Windows® Services, right-click
SNMP Service
. Click
Properties
.
2.
On the
General
tab, change the startup type to
Automatic
.
3.
On the
Traps
tab, in the
Community name
field, type the community name for the SNMP service. The field is
case-sensitive.
4.
In the
Trap Destinations
section, add the IP address of the computer that hosts the BlackBerry Monitoring
Service.
Upgrade Guide
Configuring a computer for monitoring
68