Jul 19, 2011

Microsoft CRM 4.0 ASP.NET Error 1309 - CRMException - maximum user quota

I was working on a Microsoft CRM 4.0 system the other day for one of my clients. It's mainly used for demo and testing purposes so it hadn't been used in a while.  The customer was unable to login to the server.  When they tried to login to CRM via the browser, they just got a message saying "Invalid User Authentication".

I spent quite a while checking security settings, IIS settings, etc.  Didn't really see anything CRM-related in the server event logs either. But I did see one error showing up at the exact moment the user was trying to login. But the source wasn't MSCRM, it was ASP.NET 2.0.50727.0.   Event ID 1309.

There was a long list of details on the error but the part that jumped out at me said this..
Exception type : CRMException
Exception message : You have reached the maximum number of user quota

So it sounded like they had more active user accounts than licenses. This is possible since the company was imported from another domain with different user accounts and probably not mapped appropriately. I think originally they were on a 30 trial installation and hadn't registered it so maybe that gave them an unlimited number of users during the trial period?  Since I had just registered it earlier to solve a different error, that might have kicked in the quota problem.  Though it seems like the browser login should have told them about being over quota, rather than having to dig into the server logs?

Anyway, I ended up going directly into the SQL tables and making some changes. I went into the SystemUserBase table. I was looking at the IsDisabled (bool) column.  Should be "True" for disabled users.  After counting the number of active users in the table, they were definitely over their 5 user license.  So I manually changed the IsDisabled value to "true" for all but 5 users.   Then I was able to login to CRM with no errors since they were now within their quota!

While you are there, you can also adjust the TYPE of user account via the AccessMode (int) field. 0 for full access, 1 for administrative access, 2 for read-only access. But this isn't necessary to fix the user quota error message.

I didn't see this error documented anywhere else so hopefully this post will show up in Google and help some other folks.

26 comments:

Anonymous said...

whooohooo. this solved my problem. thanks!

Arjun kumar said...

CRM are the best software that any company could rely on to maintain their relationship with their customers. Apart from other CRM in the market Salesforce offers a great interface to take care of these activities. They also offer in house interaction facility. Thanks to salesforce.

Salesforce crm training in chennai

Andrew Son said...

There are lots of information about latest technology, like Hadoop cluster is a special type of computational cluster designed specifically for storing and analyzing huge amounts of unstructured data in a distributed computing environment. This information seems to be more unique and interesting. Thanks for sharing.
Hadoop Training Chennai | Best Hadoop Training in Chennai | Big Data Training

Melisa said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
Regards,
SAP institutes in chennai|SAP Training in Chennai|SAP course in chennai|sap training in Chennai

Amirtha rao said...


I like your writing style, it was very clear to understanding the concept well; I hope you ll keep your blog as updated.
Regards,
Angularjs training in chennai|Angularjs training chennai|Angularjs course in chennai|Angularjs training center in Chennai

Jeanne Davies said...

A professional web design also trickle into your search engine rankings thanks for sharing keep sharing ..:) Company About Us

Fangyaya said...

cheap ray ban sunglasses
tory burch flats
abercrombie & fitch outlet
louis vuitton bags
celine outlet
michael kors outlet
ugg boots
mbt shoes
cheap beats headphones
coach outlet store online
louis vuitton
retro jordan shoes
lebron 13 shoes
kate spade outlet
jordan 3 powder blue
michael kors outlet online
ugg slippers
adidas factory outlet
michael kors outlet
michael kors handbags
rolex watches
louis vuitton purses
coach outlet clearance
timberland shoes
polo ralph lauren
canada goose jackets
louis vuitton outlet
ugg boots
ugg boot uk
ladies cartier watches
nike roshe one
gucci outlet online
ralph lauren polo
coach outlet store
cheap true religion
louis vuitton outlet
uggs on sale
timberlands
michael kors outlet online
christian louboutin outlet
20168.11chenjinyan

Nikshitha S said...

PHP provides the best option to build the website where we can design our website in a very interactive manner that provides better functioning in data management.
PHP Training in Chennai | PHP course in Chennai

Paul Miller said...

Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.
Regards,
PHP Training in Chennai | Best PHP training in Chennai

Nandhini said...

Thanks for sharing this informative content which provided me the required information about the latest technology.
Salesforce training in Chennai | Salesforce CRM training in Chennai

jhansi joe said...


Excellent post!!! In this competitive market, customer relationship management plays a significant role in determining a business success. That too, cloud based CRM product offer more flexibility to business owners to main strong relationship with the consumers. Salesforce Training Institutes in Chennai | Salesforce Training in Chennai

Jones Sathya said...

Thanks for posting this useful content, Good to know about new things here, Let me share this,
AngularJS Training in Chennai | AngularJS Training | Best AngularJS Training Institute in Chennai

Geetha Devi said...

Nice Blog to read
Android Training in chennai | Best Android Training in chennai|Android Training in chennai with placement | Android Training

Mohana M said...

Hi, you have given really informative post. Thanks for sharing this post to our vision. Learn Hadoop Online Training will helps you to reach your goal.Selenium Training

Evelin Harriet said...

The best thing is that your blog really informative thanks for your great information!
ERP Software Solutions in Chennai | ERP Providers in Chennai | ERP Software Solutions in Chennai | ERP Implementations in Chennai

josetrump said...

Superb article. I read really enjoyed article here.Selenium Training in Chennai It's really amazing article blog.And it hopes to you very helpful to me. Thanks a lot share this amazing post.
Selenium Training in Velachery
Selenium Training in Anna Nagar

Siva Seo said...

Nice Blog. Thank you for Sharing. Enterprise Resource Planning Software Solutions in Chennai. For more details contact us info@bravetechnologies.in
erp in Chennai | erp providers chennai

pradeepa tamilvanan said...

In recent days Angular plays vital role to loading your site content in a fastest way, so it’s a required skill for everyone, thanks for sharing this useful information to our vision keep blogging.
Regards,

Best Angularjs Training in Chennai
angularjs training center in chennai

Shivani Yuvanjalin said...

Really Nice Blog. Thank you for Sharing. We are the best erp software providers in chennai. For more details call +91 9677025199 or email us on info@bravetechnologies.in.
ERP Providers in Chennai

sivanesan said...

Excellent post. I have read your blog it's very interesting and informative. Keep sharing.
erp in chennai

Stephen Griffin said...

I never understood why everyone is using the system from Microsoft, this is not the best and most convenient way, especially for a small beginner. Often I use CRM plugins free crm for small business that are more easy to use and have a lot of interesting options. This is for those who know the price of time and does not want to have unnecessary problems and hassle.

vigneswaran said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
java training in chennai
angularjs 2 training institute in chennai

Paul Miller said...

Great post. It is really helpful and thanks for taking the time to share this post.
Regards,
AngularJS Training | AngularJS Training in Chennai | AngularJS course in Chennai

ninest123 said...

yeezy boost
adidas yeezy
fendi handbags
adidas nmd
birkenstock outlet
pandora jewelry
longchamp outlet
pandora
birkenstock shoes
red bottoms
mt0706

Krishna Veni said...

Interesting and very informative article... Thanks for sharing your information...
Angular JS Training in chennai | Angular JS Training in velachery

Sri Nithya said...

Thanks for sharing this web page. It was really helpful to me. I have about Microsoft CRM, keep sharing more like this.
AngularJS Training in Chennai | AngularJS course in Chennai