Installing Express2005 SQL

I am trying to setup a new server for a non-profit i donate my services to.

I want to have SQL for an intranet based program that will be converted from a currently used Access database.

I can not get Express (any version to install). Below are the specs of the server and the log from the install.

Any suggestions and thanks in advance,

Lynn

Operating System

System Model

Windows 2000 Advanced Server Service Pack 4 (build 2195)

COMPAQ PROLIANT 800

Processor ^a

Main Circuit Board ^b

500 megahertz Intel Pentium III
32 kilobyte primary memory cache
512 kilobyte secondary memory cache

BIOS: 12/31/99

Drives

Memory Modules ^c,d

27.05 Gigabytes Usable Hard Drive Capacity
23.01 Gigabytes Hard Drive Free Space

COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]

IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0

192 Megabytes Installed Memory

Local Drive Volumes

c: (NTFS on drive 0)

18.19 GB

14.45 GB free

f: (NTFS on drive 3)

4.54 GB

4.26 GB free

g: (NTFS on drive 1)

4.33 GB

4.30 GB free

Network Drives

None detected

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Mon Nov 06 15:23:26 2006

Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:

Pentium III-compatible processor or higher required

Minimum: 600 MHz

Recommended: 1 GHz or higher

Minimum: 192 MB

Recommended: 512 MB or more

Maximum: OS maximum

--
SvenC

|||

The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.

Once you take care of that, you should be able to attempt another Express install again.

|||

Thanks for all your help.

You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.

Thanks for your keen eye R. Green

|||

hi

if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?