Posts Tagged ‘BESMgmt’

If you’ve 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
Carlos Serpa
(1 rows affected)
  • Remove the desired user:
1> use BESMgmt
2> delete from UserConfig where DisplayName="Carlos Serpa"
3> go
Changed database context to 'BESMgmt'.
(1 rows affected)
  • Exit:
1> exit