If you have ever removed a user off the BlackBerry Enterprise Server via the Administrator Web Console and have come to find that you’re no longer able to re-add the user this might help you:

• Connect to the database from within the BES server (where BLACKBERRY is the name of your database instance, note it could be something else depending on your setup.)

C:\> sqlcmd -S .\BLACKBERRY

• Dump a list of possible names:

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

• Changed database context to 'BESMgmt'.

DisplayName
Test1 User
Test2 User
Test3 User
(1 rows affected)

• Remove the desired user:

1> use BESMgmt
2> delete from UserConfig where DisplayName="Test2 User"
3> go

• Changed database context to 'BESMgmt'.

(1 rows affected)

• Exit:

1> exit