SQL Server 2000 SP4 Fails

[satshergill]

Hi All


I'm trying to install SQL Server 2000 sp4 and I keep geting the
following error message


Setup Installation of the MicroSoft Data Access Components package
failed. (-1)


Any help anyone


Thanks

 

[mrdenny]

There are lots of possible fixes.
Download MDAC 2.8sp1 from Microsoft and try to install it manually. This will give you a better idea of the actual problem. Take a look in the c:\windows\dasetup.log file. See if it's got anything useful in there.

Let me know what happens when you install MDAC manually. If MDAC 2.8sp1 installs manually install SP4 in debug mode (setupsql.exe k=Dbg) from the command line. When it asks to install MDAC say no. Say yes for everything else. Only do this if MDAC installs by it self. If MDAC doesn't isntall post the error and I'll help you work through it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com