Blackberry PRD-10459-005 Configuration Guide - Page 53

Con minimum Microsoft SQL Server permissions for the Windows account

Page 53 highlights

Installation and Configuration Guide Changing the BlackBerry Configuration Database Server and database roles rim_db_bes_server Description 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. Changing the BlackBerry Configuration Database If you want a BlackBerry® Enterprise Server to use a different BlackBerry Configuration Database, you must run the setup application and specify the BlackBerry Configuration Database that you want the BlackBerry Enterprise Server to use. When you change the BlackBerry Configuration Database, the BlackBerry Enterprise Server becomes unavailable and users cannot send or receive messages on their BlackBerry devices. Organizer data synchronization occurs after you have changed the BlackBerry Configuration Database. 51

  • 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

Server and database roles
Description
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.
Changing the BlackBerry Configuration Database
If you want a BlackBerry® Enterprise Server to use a different BlackBerry Configuration Database, you must run the
setup application and specify the BlackBerry Configuration Database that you want the BlackBerry Enterprise Server
to use.
When you change the BlackBerry Configuration Database, the BlackBerry Enterprise Server becomes unavailable and
users cannot send or receive messages on their BlackBerry devices. Organizer data synchronization occurs after you
have changed the BlackBerry Configuration Database.
Installation and Configuration Guide
Changing the BlackBerry Configuration Database
51