Blackberry PRD-10459-005 Configuration Guide - Page 25

Configuring authentication to the BlackBerry MDS Integration Service database

Get Blackberry PRD-10459-005 - Enterprise Server For Novell GroupWise PDF manuals and user guides View all Blackberry PRD-10459-005 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 25 highlights

Installation and Configuration Guide Configuring connections for the BlackBerry Enterprise Server databases Assign permissions to the Windows account or Microsoft SQL Server account Perform one of the following actions: • If you create the BlackBerry® Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and you require the setup application to install Microsoft® SQL Server® Express during the installation process and you choose Windows® authentication, you are not required to assign Microsoft SQL Server permissions to the Windows account. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account. • If you create the BlackBerry Enterprise Serverdatabases on the computer that hosts the BlackBerry Enterprise Server and you require the setup application to install Microsoft SQL Server Express during the installation process and you choose Microsoft SQL Server authentication, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Microsoft SQL Server account. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Microsoft SQL Server account. • If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and the computer already hosts a Microsoft SQL Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows account or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account. • If you create the BlackBerry Enterprise Server databases on a computer that does not host the BlackBerry Enterprise Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account. Configuring authentication to the BlackBerry MDS Integration Service database When the setup application creates the BlackBerry® MDS Integration Service database during the installation process, you must use the same authentication method and account that you specified for the BlackBerry Configuration Database. The BlackBerry MDS Integration Service requires the same permissions to access the BlackBerry MDS Integration Service database that the BlackBerry® Enterprise Server requires to access the BlackBerry Configuration Database. 23

  • 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
Assign permissions to the Windows account or Microsoft SQL Server account
Perform one of the following actions:
•
If you create the BlackBerry® Enterprise Server databases on the computer that hosts the BlackBerry
Enterprise Server and you require the setup application to install Microsoft® SQL Server® Express during the
installation process and you choose Windows® authentication, you are not required to assign Microsoft SQL
Server permissions to the Windows account. If you want the setup application to install the BlackBerry
database notification system, you must assign the Microsoft SQL Server permission for the database system
administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the
Windows account.
•
If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise
Server and you require the setup application to install Microsoft SQL Server Express during the installation
process and you choose Microsoft SQL Server authentication, you must assign the database creator (dbcreator
server role) Microsoft SQL Server permission to the Microsoft SQL Server account. If you want the setup
application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server
permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server
Management Studio) to the Microsoft SQL Server account.
•
If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise
Server and the computer already hosts a Microsoft SQL Server, you must assign the database creator
(dbcreator server role) Microsoft SQL Server permission to the Windows account or Microsoft SQL Server
account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup
application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server
permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server
Management Studio) to the Windows account or Microsoft SQL Server account.
•
If you create the BlackBerry Enterprise Server databases on a computer that does not host the BlackBerry
Enterprise Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server
permission to the Windows or Microsoft SQL Server account that you use to complete the BlackBerry
Enterprise Server installation process. If you want the setup application to install the BlackBerry database
notification system, you must assign the Microsoft SQL Server permission for the database system
administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the
Windows account or Microsoft SQL Server account.
Configuring authentication to the BlackBerry MDS Integration Service
database
When the setup application creates the BlackBerry® MDS Integration Service database during the installation process,
you must use the same authentication method and account that you specified for the BlackBerry Configuration
Database. The BlackBerry MDS Integration Service requires the same permissions to access the BlackBerry MDS
Integration Service database that the BlackBerry® Enterprise Server requires to access the BlackBerry Configuration
Database.
Installation and Configuration Guide
Configuring connections for the BlackBerry Enterprise Server databases
23