BlackBerry Enterprise Server 4.1 for MDS Applications, 20u PRD-10459-034 User Manual
Product codes
PRD-10459-034
Setting up the database connection
3
The BlackBerry® Enterprise Server can connect to the BlackBerry Configuration Database on the Microsoft® SQL Server® using
Microsoft® Windows® authentication or database authentication. If you use Microsoft Windows authentication, the BlackBerry
Manager logs in to the BlackBerry Configuration Database using the Microsoft Windows account that you used to complete the
installation process.
Microsoft® Windows® authentication or database authentication. If you use Microsoft Windows authentication, the BlackBerry
Manager logs in to the BlackBerry Configuration Database using the Microsoft Windows account that you used to complete the
installation process.
If you use database authentication with Microsoft SQL Server, the BlackBerry Manager authenticates to the database using the
database credentials that the administrator provides.
database credentials that the administrator provides.
Specifying permissions when connecting to the BlackBerry Configuration
Database using Microsoft Windows authentication
Database using Microsoft Windows authentication
During the BlackBerry® Enterprise Server installation process, if you choose to connect to the BlackBerry Configuration Database
using Microsoft® Windows® authentication, the Microsoft Windows account that you use must have permissions on the database
server. The type of permissions depends on the BlackBerry Enterprise Server setup option that you choose, and on whether you
create the BlackBerry Configuration Database on the same computer as the BlackBerry Enterprise Server or on another database
server.
using Microsoft® Windows® authentication, the Microsoft Windows account that you use must have permissions on the database
server. The type of permissions depends on the BlackBerry Enterprise Server setup option that you choose, and on whether you
create the BlackBerry Configuration Database on the same computer as the BlackBerry Enterprise Server or on another database
server.
Specifying MSDE 2000 permissions for the Microsoft Windows account
If you install MSDE 2000 during the BlackBerry® Enterprise Server installation process, you do not need to specify additional
permissions. When you select Microsoft® Windows® authentication during the BlackBerry Enterprise Server installation process,
the setup application automatically assigns the required permissions to the Microsoft Windows account that you are using to
complete the installation.
permissions. When you select Microsoft® Windows® authentication during the BlackBerry Enterprise Server installation process,
the setup application automatically assigns the required permissions to the Microsoft Windows account that you are using to
complete the installation.
Assign Microsoft SQL Server permissions to the Windows account
Perform one of the following actions:
• If you create the BlackBerry® Configuration Database on the same computer as the BlackBerry® Enterprise Server, or if
• If you create the BlackBerry® Configuration Database on the same computer as the BlackBerry® Enterprise Server, or if
you install the BlackBerry MDS Integration Service, assign the system administrator permission to the Windows® account
that you are using to complete the installation.
that you are using to complete the installation.
• If you create the BlackBerry Configuration Database on another computer, assign server administrator and database
creator permissions to the Windows account that you are using to complete the installation process. If you are using
Microsoft® SQL Server® 2005, assign the system administrator permission to each of the following roles:
SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole.
Microsoft® SQL Server® 2005, assign the system administrator permission to each of the following roles:
SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole.
Upgrade Guide
Setting up the database connection
11