SMBs should consider using SQL Server Express as much as possible because it's free and has many of the same features as the other editions of SQL Server. However, as your client's trusted partner, you should be aware of the limitations of SQL Server Express.
If the needs of an SMB database exceed the limitations of SQL Server Express, the client should consider some of the other editions of SQL Server. The official Microsoft site linked above provides a list of limitations and features of the other editions of SQL Server.
Clients with a large number of users must purchase a per processor license for SQL Server, which can be more expensive than the hardware they are using. In general, I recommend that SMBs use database servers that will allow them to grow into and will provide optimal service for the lifetime of the applications using SQL Server. I normally recommend the 64-bit Enterprise Edition of SQL Server because its feature set scales to meet growing needs.
Dig Deeper on Database software management
Related Q&A from Hilary Cotter
In order for SQL Server capacity planning to be affective, resellers must plan the hardware to last the life of the server. Continue Reading
SQL Server database security is as important to a customer as ensuring their servers don't encounter any downtime. These tools will help keep your ... Continue Reading
Rather than throwing hardware to configure a database to support web-based applications with large dynamic datasets, VARs can use architectural ... Continue Reading