Triva isn't available right now.
Check out the support page for our phone number and hours
Legal
Recommended Products
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
-
HighQ
A business management tool for legal professionals that automates workflow. Simplify project management, increase profits, and improve client satisfaction.
Questions? We are here to help
Tax & Accounting
Recommended Products
-
Checkpoint Edge
A powerful tax and accounting research tool. Get more accurate and efficient results with the power of AI, cognitive computing, and machine learning.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
SurePrep 1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Determine which version of SQL server is right for your firm
Microsoft provides a variety of versions and editions of SQL Server to correspond with differing needs. While we find SQL Server Express sufficient for most firms, things such as the number of concurrent users, the amount of data, any additional applications needed within your firm may necessitate an upgraded version of SQL Server.
important
Due to the complexity of setting up and maintaining a SQL Server environment, we recommend you consult with your firm's qualified IT professional or a SQL certified technician.
Cost and licensing
The Express edition of SQL Server is free and included in the installation each of the CS Professional Suite applications that use SQL databases. However, the Express edition of SQL does have limits (see SQL Server version comparisons table further). Many of these limits are removed with one of the paid versions of SQL, which vary in licensing options and pricing.
Accounting 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.
- When licensed “per server + CAL”, you have to purchase a CAL for each person and/or device accessing the SQL Server.
- When licensed “per core”, there is not a limit on the number of people and/or devices that can access the SQL Server.
All other CS Professional Suite applications don’t need specific SQL Licensing and Support can't advise on SQL Licensing. For more information, refer to Microsoft's SQL Server Pricing. 
SQL Server version comparisons
Refer to the following tables for a comparison of the different versions and editions of SQL Server.
Microsoft SQL Server 2019
Review Features Supported by the Editions of SQL Server 2019 for full details.
for full details.Feature | Enterprise | Standard | Express |
|---|---|---|---|
Number of CPUs/computing capacity | Operating system maximum | Limited to the lesser of 4 sockets or 24 cores | Limited to the lesser of 1 socket or 4 cores |
Maximum memory used | Operating system maximum | 128 GB | 1,410 MB |
Maximum database size | 524 PB | 524 PB | 10 GB |
Microsoft SQL Server 2017
Review Features Supported by the Editions of SQL Server 2017 for full details.
for full details.Feature | Enterprise | Business Intelligence | Standard | Express |
|---|---|---|---|---|
Number of CPUs/computing capacity | Operating system maximum | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 1 socket or 4 cores |
Maximum memory used | Operating system maximum | 128 GB | 128 GB | 1 GB |
Maximum database size | 524 PB | 524 PB | 524 PB | 10 GB |
Microsoft SQL Server 2016
Review Features Supported by the Editions of SQL Server 2016 for full details.
for full details.Feature | Enterprise | Business Intelligence | Standard | Express |
|---|---|---|---|---|
Number of CPUs/computing capacity | Operating system maximum | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 1 socket or 4 cores |
Maximum memory used | Operating system maximum | 128 GB | 128 GB | 1 GB |
Maximum database size | 524 PB | 524 PB | 524 PB | 10 GB |
Microsoft SQL Server 2014
Review Features Supported by the Editions of SQL Server 2014 for full details.
for full details.Feature | Enterprise | Business Intelligence | Standard | Express |
|---|---|---|---|---|
Number of CPUs/computing capacity | Operating system maximum | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 4 sockets or 16 cores | Limited to the lesser of 1 socket or 4 cores |
Maximum memory used | Operating system maximum | 128 GB | 128 GB | 1 GB |
Maximum database size | 524 PB | 524 PB | 524 PB | 10 GB |
Performance
- While there is no SQL Server limit related to user threshold, you should consider using an edition of SQL higher than Express (which requires a paid license from Microsoft) for firms with 15 or more concurrent users.
- Larger firms may benefit from a full version of SQL Server because of the enhanced features and management tools that aren't available with SQL Express.
- Some of these features include enhanced synchronization and terminal server clustering.
- Some of these tools include SQL Server Management Studio, SQL Server Profiler, and SQL Analyzer.
- Another factor to consider is whether your firm uses other applications that require SQL databases.
- For example, if your firm already uses Accounting CS on a full version of SQL Server, then it could be beneficial to use SQL Server for FileCabinet CS since you've already purchased licenses for SQL Server.
Product-specific considerations
Accounting CS and Workpapers CS
While we find that SQL Express is suitable for Accounting CS and Workpapers CS, keep in mind that the type of data usually stored in an engagement/workpapers environment causes databases to grow rather quickly and could result in a need for a full (paid) version of SQL Server.
note
Note:
For performance reasons, we don't recommend using SQL Server Express for Accounting CS with Firm-Hosted Client Access.Practice CS
The average database size for Practice CS ranges from 100 MB to 2 GB, though in isolated examples, firms have had larger databases. In most cases, as long as you're following best practices to ensure optimal performance, SQL Express will be sufficient to use with Practice CS.
FileCabinet CS
While the database limit for MS SQL Server Express is 10 GB, FileCabinet CS is structured such that up to 100 GB of data can be supported with the Express edition.
This article applies to:
- Product: Accounting CS
- Subject: SQL
Related content
-
Upgrade or install a Microsoft SQL Server instance
Format:
Article,
8 min read