Unable to add users to a BlackBerry Professional Software (BPS) installation

ZTE Tania

ZTE Tania

Windows Phone Mango

Fully equipped

Great for business and pleasure

More...
BlackBerry Bold 9790

BlackBerry Bold 9790

BlackBerry OS7

Powerful & Fully Featured

Smooth performance for browsing the web, running apps, working with documents, and enjoying multimedia

More...
Motorola RAZR

Motorola RAZR

The RAZR is back

Faster, Thinner, Smarter, Stronger

Dual-core 1.2GHz processor, 7.1mm body, MotoCast, and KEVLAR strong.

More...
HTC Sensation XL

HTC Sensation XL

Feel every beat

With Beats Audio

A multimedia superstar with Beats earphones included.

More...
HTC Titan

HTC Titan

Unlike anything you've ever held before

Office on the move

Windows Phone 7.5 (Mango). With a 4.7-inch screen and big virtual keyboard, the Titan is perfect for both work and play.

More...
HTC Radar

HTC Radar

Real time close

Windows Phone 7.5 (Mango)

Pull all your contacts and social networks together into one place to stay connected with friends and share instantly.

More...
BlackBerry Bold 9900

BlackBerry Bold 9900

Slim yet powerful

Touch and Type in harmony

The Bold 9900 is RIM's thinnest BlackBerry smartphone yet and as lightweight and durable as it is feature-packed.

More...
BlackBerry Curve 9360

BlackBerry Curve 9360

Socially aware

Sleek and stylish

The 9360 feels just right in your hand and with a ton of accessories you can really make it your own.

More...
HTC ChaCha

HTC ChaCha

Facebook integrated

Full qwerty Android

Share virtually anything with just one touch.

More...
ZTE Libra

ZTE Libra

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
ZTE MF30/MF60

ZTE MF30/MF60

Portable Internet

USB & WiFi for Windows and Mac

High speed, portable Internet access in your pocket.

More...
Motorola Defy +

Motorola Defy +

Lifeproof

Faster, smarter, richer

Scratch, dust and water-resistant. 1GHz processor, 5MP camera and great pre-loaded apps.

More...
Motorola Pro +

Motorola Pro +

Works and plays as hard as you do

Faster, smarter, richer

A powerful smartphone optimised for business but fun enough to use for your personal life.

More...
BlackBerry Curve 9380

BlackBerry Curve 9380

BlackBerry OS7

The 1st all-touch Curve

Easily capture and share your favourite moments with family, friends and colleagues.

More...
Novatel MiFi 3352

Novatel MiFi 3352

Intelligent Personal Mobile Hotspot

Portable High-Speed Internet

Carry the Internet with you stream media wirelessly from your SD card.

More...
HTC Sensation XE

HTC Sensation XE

With Beats Audio

Designed to impress

With custom Beats headphones, engineered to deliver extraordinary sound.

More...
HTC Rhyme

HTC Rhyme

Accessories to fit your life

Stay connected with those closest to you

Stylish, effortless technology.

More...
ZTE Skate

ZTE Skate

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
HTC Explorer

HTC Explorer

A design that fits your lifestyle

Keep in touch with the people who matter

Jump right into what's most important to you thanks to an improved lockscreen design.

More...
ZTE Tureis

ZTE Tureis

Full Qwerty 2.6-inch touchscreen

Android Gingerbread

Business and social features in a slim package.

More...
Frontpage Slideshow (standalone) | Copyright © 2006-2011 JoomlaWorks Ltd.


Issue

When attempting to add a user to a BPS installation, an error is returned indicating that all available user licenses are already used, despite no users being listed in the BlackBerry Manager, or fewer users than licenses are available for.


Cause

This can be caused by the incorrect permissions being configured on the Exchange server: when a user account is removed from the BlackBerry server, this requires that information be removed from the user's Exchange mailbox, including AES encryption details among other things. Should the BesAdmin service account not have the ability to 'Administer the Information Store' this process will fail and despite the fact that the user is no longer listed within the BlackBerry Manager, that user will still have an entry in the underlying SQL database. This information is not removed from the database until it receives confirmation from the Exchange server that the information has been removed. If the permissions are not configured correctly, this database entry effectively becomes 'orphaned'.


Resolution

Ideally, the resolution is to configure the permissions correctly. For detailed information on how to do this view these articles:

Exchange 2003 - http://blog.brightpointuk.co.uk/bes-41x-50-exchange-2003-pre-requisites
Exchange 2007 - http://blog.brightpointuk.co.uk/bes-41x-50-exchange-2007-pre-requisites

The issue can be resolved by manually editing the SQL database to remove the orphaned database entry. This guide only applies to the MSDE database installation, not a separate SQL Server installation.

On the Blackberry Server, open a Command Prompt window and type in:

osql –E (enter)

A SQL command prompt will be displayed. Now type in the following commands:

1> use BESMgmt
2> select DisplayName from UserConfig
3> go

(the display name will be returned here) followed by the line
(1 row affected)

Now type in:

1> delete from UserConfig where DisplayName="James Liddiard"
2> go

(Note, here you will need to replace “James Liddiard” with the name of your user. DO use double quotes around the name)

Type quit to exit the SQL command instance. That should resolve the problem. A reboot may be in order for good measure.



UPDATE - the same procedure can be followed on a BlackBerry Enterprise Server Express installation. Follow the same steps, but to access the SQL command prompt, use:

sqlcmd -S .\BLACKBERRY