Roachys Weblog

We’re just trialling the Blackberry Professional software here, but with a change of heart as to the test user attempted to delete the user to re-add another.  Unfortunately although the Blackberry Professional Software allows you to delete users, it didn’t successfully purge the user from the database.  This meant that we couldn’t add an alternative user (the software comes with 1 user licence to trial with).

The solution is to manually remove the user from the database.  This can be done using the OSQL command line utility.

osql -E SERVERNAME\DATABASESERVERNAME
1>use BESMgmt
2>select DisplayName from UserConfig
3>go

This will show the DisplayName of the user.  For the sake of this document, we’ll call the user “testuser”.

To delete the user, then enter:

1>use BESMgmt
2>delete from UserConfig where DisplayName=“testuser”
3>go

1>exit

That should remove the user.  On checking within the Blackberry Professional software there is now no longer a user, releasing the licence.