Solved

BESCAL Locked by Deleted User

Posted on 2009-05-15
11
321 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
 
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

A little while ago I had a need to reinstall a Blackberry Enterprise server in order to fix a particular problem.  As I did not know the existing certificate password I entered a new one which resulted in the Administration page displaying that it "…
Have you ever wondered if there is a way to get a message delivery receipt without interrogating the BlackBerry log files or using the Resource Kit tools? It is possible using this tip: When troubleshooting whether a BlackBerry is receiving email…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now