After the acquisition of Great Plains in the early part of this decade, Microsoft made the move to replace Pervasive SQL, the existing database for Great Plains, with the MSDE platform.  MSDE made sense at the time and allowed Microsoft to phase out the Pervasive SQL platform in a quick and easy fashion.  For users still on the MSDE platform, what was once free and easy has become a ticking time bomb that needs to be defused.

The MSDE or Microsoft SQL Desktop Engine Platform has restrictions on it that will cause issues for any company that has grown since it first installed the Great Plains/MSDE solution.  These limitations include:

• Support of up to 2GB of RAM
• 2GB database size limit
• 5 concurrent users or less
• Support for up to 2 CPU on a Windows NT or Windows 2000 server
• No publishing for transaction replication
• No Database Server Failover Support
• No full-text search
• No GUI interface
• No OLAP
• No English Query
• No SQL books online

Additionally, the current MSDE version has been discontinued and will soon be no longer supported.  As SQL is a back-end server, customers who have purchased this licensing probably are not aware of the serious issues that could affect their ERP application.  The bottom line is that if your existing Dynamics GP solution is utilizing this database you should make all necessary arrangements to upgrade and move off of this platform ASAP.

Since 1985, Micro Force has been serving the New York Metro region as the Largest and Most Experienced GP-Only Gold Certified Partner.

by Micro Force - Long Island, New York Microsoft Dynamics GP Partner

February 12, 2010 by Micro Force

Email | Print

Ask The Author

Tags: Dynamics GP, MSDE, sql
Posted in About Microsoft Dynamics GP, Microsoft Dynamics ERP Functionality | Comments Off on Does your Dynamics GP Accounting Software Contain a Ticking Time Bomb?

More Posts By Micro Force

1. Dynamics GP Positioned to Tame the Upcoming 1099 Nightmare
2. Dynamics GP v10 Quirk Fixed for Dynamics GP 2010
3. Vertical vs. Horizontal Solutions – Dynamics GP Goes Both Ways!
4. Scenario Planning For The Eventual Recovery – ERP Is The Key
5. Unifying Multiple-Entity Financials With GP And FRx

Related Posts

1. Microsoft Dynamics GP Affords Dashboards for Small and Mid-Size Businesses
2. Reprinting Accounts Payable Remittance Forms in Microsoft Dynamics GP 2013 Beta
3. When to Use Dexterity and When to Use Microsoft Dynamics GP Add-ins
4. Key Enhancements of Microsoft Dynamics GP 2013 R2
5. Account Rollups in Dynamics GP