04-07-2009, 06:22 PM
Join Date: Nov 2008
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
- 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
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:
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.
- SQL Server (serveradmin)
- Database role (db_owner)
Refer to the BlackBerry Enterprise Server Installation Guide for more information on setting up the BlackBerry Configuration Database.
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.