Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Experiences running SQL-based ERP on SBS 2003?
Message
From
22/09/2006 15:06:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Experiences running SQL-based ERP on SBS 2003?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Miscellaneous
Thread ID:
01156599
Message ID:
01156599
Views:
66
A client is evaluating 2 ERP programs for their business:
- SAP Business One
- SysPro Version 6.0

Both of these require a SQL Server backend.

The client is also interested in getting into MS Exchange Server. They are a relatively small firm (about 15 employees) and it looks as though Exchange Standard Edition will work well for them.

MS offers a bundle of server software products called Small Business Server (SBS) 2003 R2. It comes in two versions:

- Standard Edition: includes Windows Server 2003 R2 Standard and Exchange Server 2003 SP2 Standard
- Premium Edition: adds SQL Server 2005 Workgroup Edition to the above

We've asked the vendors, and apparently SQL Server Workgroup Edition is sufficient to run the ERP offerings. It supports 3GB RAM, 2 physical CPUs.

SBS 2003 R2 has some limitations:
- All its components must be installed on a single computer. You can't, for example, install the SQL Server component on a separate computer
- Max hardware it supports is 2 physical CPUs (can be multicore), and 4GB RAM.

So, there are 2 options:

1. Buy SBS Premium and install everything on one server
2. Buy SBS Standard and some separate SQL Server license (Workgroup or Standard) and set SQL up on a separate box

I know that Option 2 will perform better, have less contention and more headroom for future expansion. However, maybe Option 1 is "good enough" for my client. Does anyone have any experience running a decent-sized ERP system directly on the SBS server, or does everyone go straight to Option 2?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Next
Reply
Map
View

Click here to load this message in the networking platform