IBM AH0QIKO Upgrade Guide - Page 28

IBM AH0QIKO - Lotus Domino Enterprise Server Manual

Get IBM AH0QIKO - Lotus Domino Enterprise Server PDF manuals and user guides View all IBM AH0QIKO manuals
Add to My Manuals
Save this manual to your list of manuals

Page 28 highlights

Upgrade Guide Configuring connections for the BlackBerry Enterprise Server databases The BlackBerry Enterprise Server and BlackBerry Monitoring Service can connect to their databases on the Microsoft® SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server and BlackBerry Monitoring 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 BlackBerry Configuration 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 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. 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 Serverauthentication, you must assign the database creator (dbcreator 26

  • 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
The BlackBerry Enterprise Server and BlackBerry Monitoring Service can connect to their databases on the Microsoft®
SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server
and BlackBerry Monitoring 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 BlackBerry Configuration 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 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.
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 Serverauthentication, you must assign the database creator (dbcreator
Upgrade Guide
Configuring connections for the BlackBerry Enterprise Server databases
26