Link to home
Start Free TrialLog in
Avatar of bobsocks
bobsocks

asked on

which version of sql server 2005 for a single cpu Windows 2003 server

I will have multiple domains on a Windows 2003 Standard system with 1 cpu.

Which version of Sql Server 2005 should i use?  And this will be an upgrade from Sql Server 2000.

Avatar of jfields71
jfields71

That depends on what you want or need to do with it.  It appears as if you could actually use the free Express version.  However, it has many limitations.  How much RAM you have and if you need features such as clustering would determine which edition to get.  We ended up buying Standard Edition for our severs.  I used this chart here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Avatar of bobsocks

ASKER

I looked at that chart.  My guess was workgroup or standard.

Problem with express is the 1 gig limit on memory.  The system has 4 gig.  There will be no clustering.
ASKER CERTIFIED SOLUTION
Avatar of jfields71
jfields71

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Now where do I find info on an upgrade from 2000 to 2005?  Specifically, the best price.