Blackberry PRD-10459-005 Configuration Guide - Page 24

Configuring connections for the BlackBerry Enterprise Server databases

Page 24 highlights

Installation and Configuration Guide Configuring connections for the BlackBerry Enterprise Server databases Configuring connections for the BlackBerry Enterprise Server databases The BlackBerry® Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service store data in their own databases. The database for the BlackBerry Enterprise Server is the BlackBerry Configuration Database. You create the BlackBerry Configuration Database when you install a BlackBerry Enterprise Server or BlackBerry Administration Service or when you run the CreateDB executable. You can create the BlackBerry MDS Integration Service database or BlackBerry Monitoring Service database during the installation processes for the BlackBerry MDS Integration Service or BlackBerry Monitoring Service, respectively. The BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service can connect to their databases on the Microsoft® SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service log in to their databases using the Windows account that you use to complete the installation process or the database credentials you provided during the installation process. To support database mirroring for the the BlackBerry Configuration Database or BlackBerry MDS Integration Service database with Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you must use Windows authentication. The BlackBerry Monitoring Service does not support database mirroring. Specifying permissions when you connect to the BlackBerry Enterprise Server databases using Windows authentication or Microsoft SQL Server authentication If you connect the BlackBerry® Enterprise Server, BlackBerry MDS Integration Service, and BlackBerry Monitoring Service to the BlackBerry Enterprise Server databases using Windows® authentication or Microsoft® SQL Server® authentication during the BlackBerry Enterprise Server installation process, the Windows account or Microsoft SQL Server account that you specify must have database permissions on the database server. The type of permissions that you specify is determined by the setup option that you select and whether you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server components or on another database server. Specifying permissions for the Windows account or Microsoft SQL Server account If you install Microsoft® SQL Server® 2005 Express during the BlackBerry® Enterprise Server installation process, you might need to specify permissions for the Windows® account or Microsoft SQL Server account, depending on the type of authentication you select. When you select Windows authentication during the BlackBerry Enterprise Server installation process, the setup application automatically assigns the required permissions to the Windows account that you use to complete the installation process. When you select Microsoft SQL Server authentication during the BlackBerry Enterprise Server installation process, you must assign the required database permissions to the Microsoft SQL Server account that you use to complete the installation process. 22

  • 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

Configuring connections for the BlackBerry Enterprise
Server databases
The BlackBerry® Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service store data
in their own databases. The database for the BlackBerry Enterprise Server is the BlackBerry Configuration Database.
You create the BlackBerry Configuration Database when you install a BlackBerry Enterprise Server or BlackBerry
Administration Service or when you run the CreateDB executable. You can create the BlackBerry MDS Integration
Service database or BlackBerry Monitoring Service database during the installation processes for the BlackBerry MDS
Integration Service or BlackBerry Monitoring Service, respectively.
The BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service can connect
to their databases on the Microsoft® SQL Server® using Windows® authentication or database authentication. By
default, the BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service log
in to their databases using the Windows account that you use to complete the installation process or the database
credentials you provided during the installation process.
To support database mirroring for the the BlackBerry Configuration Database or BlackBerry MDS Integration Service
database with Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you must use Windows authentication. The
BlackBerry Monitoring Service does not support database mirroring.
Specifying permissions when you connect to the BlackBerry Enterprise
Server databases using Windows authentication or Microsoft SQL Server
authentication
If you connect the BlackBerry® Enterprise Server, BlackBerry MDS Integration Service, and BlackBerry Monitoring
Service to the BlackBerry Enterprise Server databases using Windows® authentication or Microsoft® SQL Server®
authentication during the BlackBerry Enterprise Server installation process, the Windows account or Microsoft SQL
Server account that you specify must have database permissions on the database server. The type of permissions
that you specify is determined by the setup option that you select and whether you create the BlackBerry Enterprise
Server databases on the computer that hosts the BlackBerry Enterprise Server components or on another database
server.
Specifying permissions for the Windows account or Microsoft SQL Server account
If you install Microsoft® SQL Server® 2005 Express during the BlackBerry® Enterprise Server installation process, you
might need to specify permissions for the Windows® account or Microsoft SQL Server account, depending on the
type of authentication you select.
When you select Windows authentication during the BlackBerry Enterprise Server installation process, the setup
application automatically assigns the required permissions to the Windows account that you use to complete the
installation process.
When you select Microsoft SQL Server authentication during the BlackBerry Enterprise Server installation process,
you must assign the required database permissions to the Microsoft SQL Server account that you use to complete
the installation process.
Installation and Configuration Guide
Configuring connections for the BlackBerry Enterprise Server databases
22