When licensed 'per server + CAL', a CAL must be purchased for each user and/or device accessing the SQL Server.These versions of SQL can vary in licensing options and pricing.Īccounting CS with Firm-Hosted Client Access requires Microsoft Volume Licensing that can be based on a 'per server + Client Access License (CAL)' or 'per core' basis. Many of these limitations are removed with the paid versions of SQL.

However, the Express edition of SQL does have limitations (see SQL Server version comparisons table below). The Express edition of SQL Server is free and is included in the installation each of the CS Professional Suite applications that use SQL databases. Microsoft provides a variety of versions and editions of SQL Server to correspond with differing needs. While we find that SQL Server Express is sufficient for most firms, factors such as the number of concurrent users, the amount of data, any additional applications needed within your firm, and so forth, may require that you install and use an upgraded version of SQL Server.ĭue to the complexity of setting up and maintaining a SQL Server environment, it is recommended that you consult with your firm's qualified IT professional or a SQL certified technician before you do so.

Sql server enterprise edition