QuickBooks® Inventory
Control and Business
Management Software

ACCTivate! installs include SQL Server 2005 Express
Existing users can decide whether or not to upgrade from MSDE 2000

ACCTivate! is now going to include SQL Server 2005 Express for all new installations, but existing users will need to evaluate it and decide if they want to upgrade from Microsoft SQL Server 2000 Desktop Engine (MSDE).

SQL Server 2005 Express can be installed from an ACCTivate! CD (version 6.2.6 or later), but it will not be automatically installed from an ACCTivate! web update.

ACCTivate! has supported all editions of Microsoft SQL Server 2005 database since January of 2007, but the ACCTivate! CD continued to include MSDE 2000.

SQL Server 2005 Express is a free version of Microsoft SQL Server 2005. ACCTivate! will continue to support MSDE 2000 along with SQL Server 2005 Workgroup and Standard editions.

SQL Server 2005 Express versus MSDE
In comparison to MSDE, SQL Server 2005 Express includes several enhancements. The maximum database size was increased from 2GB to 4GB. The "Workload Governor" has been removed, so there is no limit to the number of concurrent operations in SQL Server 2005 Express. The new SQL Server Management Studio has been included, which is a graphical user interface utility for managing the database server.

However, the amount of system memory (RAM) that can be utilized was reduced from 2GB to 1GB and the number of processors from two to one.

Find out more
The following links provide further insight into upgrading:

Upgrading MSDE 2000 to SQL Server 2005 Express

Feature comparison of MSDE and SQL Server 2005 Express

Step-by-step instructions on upgrading to SQL Server 2005 Express

Back to top