Solved

BESCAL Locked by Deleted User

Posted on 2009-05-15
11
323 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
  • 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

There are various sources that I've used for this process and I've used it many times and adapted it with my own findings. This process is not meant to be a definitive troubleshooting guide for BlackBerry installation. That needs to be handled elsew…
After going through the deployment of BlackBerry Device Service 10, and seeing a number of questions posted about it, this article addresses some of the issues and particulars of the installation. There have been a number of other questions posted, …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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