Solved

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

Posted on 2008-06-26
4
183 Views
Last Modified: 2010-04-18
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.

0
Comment
Question by:bobsocks
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:jfields71
ID: 21875487
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
0
 

Author Comment

by:bobsocks
ID: 21875852
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.
0
 
LVL 11

Accepted Solution

by:
jfields71 earned 50 total points
ID: 21875879
Then I would go with Standard.  It removes some of the arbitrary limitations of Workgroup edition (RAM) and gives you some upgrade options.  Should you add more RAM to the system, add more CPUs, or upgrade to a 64-bit OS, Standard will give you better performance.  Basically, it gives you more room to grow if you ever need more than what you have today.
0
 

Author Comment

by:bobsocks
ID: 21877355
Now where do I find info on an upgrade from 2000 to 2005?  Specifically, the best price.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question