Solved

BESCAL Locked by Deleted User

Posted on 2009-05-15
11
325 Views
Last Modified: 2012-05-07
I removed a user from the Blackbery Enterprise Server but they are still holding the license.  I want to add another user but the BES keeps telling me I don't have a license.  How do I refresh this to reflect the fact the user holding the CAL has been deleted?
0
Comment
Question by:broadway69
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24397373
If you have BlackBerry Enterprise Server and you are in the Users tab you will see a User Pending Delete tab, just select it and right mouse click on the users and select Purge.
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24397382
If you are using BlackBerry Professional it doesnt have a "Users Pending Delete" tab so you cant manually purge accounts. In order to purge a user when using BlackBerry Professional open the command prompt and type osql -E and then enter the following commands:

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

A list of users will now be displayed, note down the user that can't be removed or re-added e.g. Gary Cutri (This example name has been added to the next step). Then run the following commands if the affected user was listed:

1>use BESMgmt
2>delete from UserConfig where DisplayName="Gary Cutri"
3>go
1>exit
0
 

Author Comment

by:broadway69
ID: 24397475
I get a SQL server does not exist or access denied error.

I'm using MSDE, does that matter?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24397492
These are MSDE and SQL commands.  Is the database on another server?
0
 

Author Comment

by:broadway69
ID: 24397511
nope, definitely on this server.
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24397546
Logon as an Administrator and run the commands.
0
 

Author Comment

by:broadway69
ID: 24397658
Tried that already.  Do I have to list the database somehow?
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24397719
Using the BESadmin account go to Start > Run > Type svrnetcn.exe

You need to ensure TCP/IP and Named Pipes is in the Enabled Protocols field.  Now you need to restart the SQL Server service.
0
 
LVL 26

Accepted Solution

by:
Gary Cutri earned 500 total points
ID: 24406298
How did you go?

0
 

Author Comment

by:broadway69
ID: 24446268
Tried the last suggestion and same error below.  Sorry I went MIA, hadn't had chance to get back to this client till now.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\besadmin>osql -E
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

C:\Documents and Settings\besadmin>
0
 

Author Closing Comment

by:broadway69
ID: 31581997
Thanks for your help, had to add the -S [server]\[database] tag to the osql -E command to get it to work.  After that it was gravy.

Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever have trouble updating the ringtone settings on a Blackberry Curve? If so, here are the steps for changing your ringtone settings.  1. The Key is in the Profiles | Select 'Profiles' Icon The most interesting thing about changing your rington…
BlackBerry Enterprise Server (BES) 5 includes a new High Availability (HA) feature, which can be used to install a standby server that is failed over to in the event of maintenance or a disaster. This can be setup for auto failover, or simply used t…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question