Ron Kunce (7/3/2008)
jim.powers (7/3/2008)
This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
In the Workgroup column on the row for RAM, the limit is clearly stated at 3GB.
This has nothing to do with the OS installed on or the amount of installed memory in the system.
You are absolutely right, the link you provided clearly states the 3GB limit! However, as many of the others already complained about, the BOL page for SQL Server 2005 clearly states for :
"SQL Server 2005 Workgroup Edition
Pentium III-compatible processor or higher
Minimum: 600 MHz
Recommended: 1 GHz or higher
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: Operating system maximum"
Clearly, a conflict in which documentation link to believe!
Ron, you're missing the point that the BOL page that states this is the hardware requirements for installation, NOT a page that states how much RAM is supported by Workgroup. If you read up the thread you will see what I mean....
I agree it is confusing, and why MS would specify a maximum amount of RAM for installation is still a mystery.....
I suppose it's like a car manufacturer saying that their vehicle could withstand a speed of 200mph without falling apart, but then saying the top speed is 130mph - the two maximums have no relation 🙂
Kev