People were initially happy with the Articles of Confederation, mostly because they had just left the American Revolution War and feared a strong central government. The Articles provided that, they designed a weak central government with few or none powers at the same time it gave most of the power to the States government, which was a public demand.
The problem was that with time, the Articles showed its problems which eventually started to bother people with economic chaos and political confusion because of the weak central government. With Shay's Rebellion, people started to notice that a strong central government was needed and the Articles lost its supporters.
