Wednesday, March 4, 2009

Blackberry troubleshooting with SQL issues

Today, I dealt with an issue where I ended up rebuilding my entire Blackberry Professional Express server on an SBS 2003 box.  Here is my nightmare and what I did to address it.

First, I had an existing user that got a new Blackberry.  I deleted the user from Blackberry Manager, as I had done many times before.  But this time, I could not add him bacl.  It kept telling me "User 'username' is in delete pending state on server 'servername', please recover the user before adding user to server"

As far as I can tell, there is no option to recover a user in Blackberry Professional, only in Blackberry Enterprise.  So then I read about options to delete the user from the SQL database.  I saw this for MDSE:

And I was advised to do this in SQL Express 2005:
Log on as your besadmin account and select Windows trust authentication.
Open table "dbo.UserConfig" and delete the entry where appear your old BlackBerry user.

But that didn't help either.  But somehow when I was in SQL Express in the appropriate database for the Blackberry, something got corrupted and now none of my Blackberries were working.  

To make a long story short - what I eventually did was redownload and reinstall the Blackberry Professional Express software, create a new SQL instance, and install it there.  The steps needed an SBS box are documented here and here.

No comments: