04-07-2009, 06:22 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,036
|
|
KB03633 - What are the required permissions in the Microsoft SQL Server
KB03633 - What are the required permissions in the Microsoft SQL Server to create and manage the BlackBerry Configuration Database
Environment
- BlackBerry® Enterprise Server software version 3.6 to 4.1 for IBM® Lotus® Domino®
- BlackBerry® Enterprise Server software version 3.6 to 4.1 for Microsoft® Exchange
- Microsoft® SQL Server® 2000 Desktop Engine (MSDE 2000)
- Microsoft SQL Server 2000
- Microsoft SQL Server 2005
Overview
This article applies when the BlackBerry Configuration Database is hosted on a Microsoft SQL Server 2000 or on a computer where MSDE 2000 is installed. MSDE 2000 is installed with the BlackBerry Enterprise Server software.
To create the BlackBerry Configuration Database, the BlackBerry Enterprise Server administrator requires access to a Windows® account (Trusted) or a SQL account on the BlackBerry Enterprise Server with the following roles:
| Database creators (db_create) | This role is required to create the BlackBerry Configuration Database.
| 3.6 - 4.1 | | Server administrator (serveradmin) | This role is needed to create tasks in the new BlackBerry Configuration Database. The administrator does not need access to the SQL system administrator account.
| 3.6 and 4.0 | | System administrator (sysadmin) | This role is needed for BlackBerry® Mobile Data System (BlackBerry MDS) Services (MDSS) installation and for role administration. | 4.1 only |
To update and maintain the BlackBerry Configuration Database, the BlackBerry Enterprise Server administrator requires the following roles:
- SQL Server (serveradmin)
- Database role (db_owner)
Note: When you add the BlackBerry Enterprise Server administrative account to the local administrators account, the administrative account automatically becomes a member of the above roles in MSDE.
Additional Information
Refer to the BlackBerry Enterprise Server Installation Guide for more information on setting up the BlackBerry Configuration Database.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
