Manually Remove a User off the SQL Database in BlackBerry Enterprise Server Express 5.0

Posted: May 7, 2010 in Technology
Tags: , , ,

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
Advertisements
Comments
  1. Doni says:

    do you know how to add BES / BES Express user directly to database?

  2. Fred says:

    THANK YOU, THIS HELPED ME VERY VERY MUCH! 😀

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s