x Want to participate? Join the group to interact
Sage CRM
Related
Recommended

Sage CRM 2021: Ooops! Coping with the Message "A number of Named Users need to be disabled to enable the System License".

1 minute read time.

I faced this message when I attempted to log-on to one of my training installs this morning. This was approximately 10 minutes before the start of a webinar but I am sure there are quite a few partners to whom this message has appeared in equally alarming circumstances! After a 3 second heart-sink moment I recovered and realised what I had done.

I had used a license key that was for 10 named users but I had the reinstalled my instance of Sage CRM and ticked the option to use demo data. Unfortunately the demo data contains 18 active users and so the license was 'blown out of the water'.

The recovery was pretty quick. I only had to open up my SQL Server Management Studio and run the following SQL against my CRM database.

update users
set user_resource = 'TRUE'
where user_userid !=1

The statement set as 'resources' all the users except the system administrator. I could then log-on with out a problem.

Once I had logged on I checked my license key for the legitimate number of users.

And then I selectively re-enabled the different users I needed for the training by marking them as resource false.

Note: I could also have set the users as disabled as neither resources nor disabled users consume a license.

Parents

  • Casey

    Have you sorted the issue out by this morning?

    You need to confirm the Admin ID in the database.

    The Admin is either going to be

    select * from users where user_logon ='Admin'

    or can be identified by their rights.

    select * from users where user_per_admin =3

    Once you have done that you need to go through the entries of the user checking their logon details.

    It may be that your Admin user has a password. This will be encrypted in the database. e.g.

    User_logon : Admin

    User_password: ^ACOABICKODIPJANBBLOGEHODDHGGFOGHPJCEDIBH

    If this is the case then you will not be able to guess it, if you don't know it.

    But you can set the password to null.

    update users

    set user_password = null

    where user_logon = 'Admin'

    You should then be able to logon.

Comment

  • Casey

    Have you sorted the issue out by this morning?

    You need to confirm the Admin ID in the database.

    The Admin is either going to be

    select * from users where user_logon ='Admin'

    or can be identified by their rights.

    select * from users where user_per_admin =3

    Once you have done that you need to go through the entries of the user checking their logon details.

    It may be that your Admin user has a password. This will be encrypted in the database. e.g.

    User_logon : Admin

    User_password: ^ACOABICKODIPJANBBLOGEHODDHGGFOGHPJCEDIBH

    If this is the case then you will not be able to guess it, if you don't know it.

    But you can set the password to null.

    update users

    set user_password = null

    where user_logon = 'Admin'

    You should then be able to logon.

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City