Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack (9) Thread Tools Display Modes
KB03633 - What are the required permissions in the Microsoft SQL Server
 
  9 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 04-07-2009, 05:22 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,252
Blog Entries: 147
Default 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:
Role Description Software version
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.
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/featured-blackberry-kb-articles/852-kb03633-what-required-permissions-microsoft-sql-server.html
Posted By For Type Date
Latvian National Armed Forces Forum • View topic - ????? ????? ?? ?????? ???????? ? ?????? This thread Refback 04-18-2011 11:03 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-22-2009 07:20 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-15-2009 07:44 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-14-2009 11:20 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-12-2009 08:08 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-10-2009 09:08 PM
BlackBerry Support Community Forums - SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-10-2009 10:52 AM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-09-2009 09:09 PM
BlackBerry Support Community Forums - Re: SQL database creation error - BlackBerry® Professional Software and BlackBerry® Unite! - BlackBerry Support Community Forums This thread Refback 06-09-2009 09:00 PM


All times are GMT -4. The time now is 10:03 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2