We help IT Professionals succeed at work.

SQL 2005 installation minimum hardware requirements

2,678 Views
Last Modified: 2012-06-22
trying to install standard edition of SQL 2005.  my machine has
 - Intel R Pentium CPU 1.7Ghz
 - 600Mhz 504Mb RAM
- loads of disc space remaining
 - Windows XP Professional SP2 version 2002

When i get to the System Configuration Check, i get minimum hardware requirement warning
even though the minimum RAM is 512Mb , I can't believe 504Mb is not sufficient.

I do have SQL 2000, but side by side is acceptable according to the help files

This prevents me from loading Database Engine

Does anybody have any other ideas why this check falis.


 
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2004

Commented:
I'd be more concerned with finding out why your memory is registering 8mb short.  Software developers make the minimum recommendations.  Some will let you install anyways, others a bit more strict about it.  

Check/replace your memory, then try again.
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

Is this a hard error or just a warning?

I've gotten a warning in the past at this point with similar specs to yours - 512MB ram with on-board video sharing memory, so OS reports 480MB.

But for me, it was a warning that I could get past.

I was loading developer edition. What edition are you trying to install?

Regards
  David

PS If you have a cheaper machine with on-board video, then the 504MB might be as good as 512 is going to appear. Anyway, memory is cheap, so if that is all the problem is, get some more ram. And if you really want both SQl 2000 and SQL 2005 engines running, I think more memory is going to make life more pleasent for you.

Commented:
When using SQL 2005 you should have aleast 1G of ram because sql server any edition is very resource intensive and you will have performance issues if you dont have 1G and above.

Author

Commented:
turns out the warning was a red herring

as i had sql 2000 installed , with a default instance name, the sql 2005 installation would not allow me to use a default instance again- this is explained in the installation document under side-by-side installtion - but i must admit i didn't understand this the first time round

so closing this query

Commented:
How is the last comment related to your original question. When you try to intall SQL 2005 it would have notified you that a default instance is already installed. This has nothing to do with memory.

Author

Commented:
CLOSE QUESTION PLEASE
Senior Database Administrator
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

I would suggest at least PAQ rather than a delete, and that perhaps a points split between dtodd and Julianva would be fairer - the orginal question was answered.

Regards
  David

Author

Commented:
fair comment Vee Mod.  found the FAQ section after typing the comment.  Also didn;t realise upper case meant shouting, but now i know.

To answer the question posed.  There was confusion when loading SQL server failed and the feedback provided by the installation was
                       'SQL 2005 installation minimum hardware requirements'
that sent me barking up the wrong tree

now i'm getting the hang of this community, I should send thanks to Julianva: for his reply. The help files explain that a minimum RAM requirement of 512Mb is sufficient but 1Gb is desirable.  Turns out that the SQL 2005  is running fine for my requirements with 512Mbs of RAM

The reason the installation did not complete was because of conflicting SQL server instances in a SQL 2000 installation on the machine.  During the SQL 2005 installation, it offered to use the same name instance, which is why i initially didn't think this was an issue.



Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.