Solved

BESCAL Locked by Deleted User

Posted on 2009-05-15
11
324 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
Industry Leaders: 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It still surprises me how many businesses have many of their staff constantly away from the office needing reliable Internet, and without realising it, the answers been in their pocket the whole time! I’m talking, of course, about the phenomenon …
I've already touched on keyboard shortcuts that can be used in a BlackBerry to make navigation much more easy but there are also another set of commands which are hidden for different reasons. Standard users won't need these unless under exceptional…
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…

733 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