02-13-2006, 02:58 PM
Talking BlackBerry Encyclopedia
Join Date: Apr 2005
Location: The Netherlands
Post Thanks: 0
Thanked 0 Times in 0 Posts
If you wish to allow an account other than the BlackBerry Enterprise Server service account, for example, BESAdmin access to the BESMgmt.mdf database, you can use the Structured Query Language (SQL) Enterprise Manager. However, if you have Microsoft Data Engine (MSDE) installed, the following steps need to be performed on the server that hosts the MSDE:
Note: This account must be able to resolve the BlackBerry Enterprise Server administration mailbox using a Messaging Application Programming Interface (MAPI) profile.
1. Open a command prompt and change directory to [Drive]:\MSSQL7\binn.
Where [Drive]: is the installation location of the MSDE.
2. Type osql -U sa -P and press Enter.
Note: The -U represents the SQL service account, for instance, sa. The -P is the password for the SQL service account. If the account does not have a password then do not enter one.
3. 1> Type use BESMgmt and press Enter.
4. 2> Type go and press Enter.
5. 1> Type exec sp_grantlogin 'DOMAIN\User' and press Enter.
Note: DOMAIN, as shown above, is the name of the Windows® domain. User, as shown above, is the name of the account that you would like to grant access to.
6. 2> Type go and press Enter.
7. 1> Type exec sp_grantdbaccess 'DOMAIN\User', 'User' and press Enter.
8. 2> Type go and press Enter.
9. 1> Type exec sp_addrolemember 'db_owner', 'User' and press Enter.
10. 2> Type go and press Enter.
11. 1> Type exec sp_defaultdb 'DOMAIN\User', 'BESMgmt' and press Enter.
12. 2> Type go and press Enter.
13. 1> Type quit and press Enter.