error installing sql server 2000 on XP SP2

[AndyApp]

I get the following error after around 45%:
The specified file cannot be opened as read-only. Ensure the source file is present in the location specified and restart setup.

"File: C:\SQL_SE~1\x86\setup\..\Binn\sql iis admin.msc"

I've found another copy of the file from somewhere else but it didn't work. I've copied the CD to my hard drive and tried it from there but no joy.

Anyone any ideas?


"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[mrdenny]

That's a new one. Mabey an anti-virus problem? Try another CD? This is definetly a new one, though I haven't tried to install SQL on an XP SP2 machine yet. Still running 2k at the office.

Denny

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

 

[SQLBill]

What version of SQL Server 2000 are you trying to install?

-SQLBill

 

[AndyApp]

havent got another cd to try. its just sql server how would i know which version, ive got service pack 2 but obviously no good if the actuall product wont go on.

"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[SQLBill]

The install CD should say whether it is SQL Server 2000:
Enterprise Edition
Standard Edition
Developer Edition
MSDE (Microsoft SQL Server Desktop Edition)
Personal Edition

You CAN NOT install Enterprise or Standard Editions on Windows XP. Developer version can not be installed on Production systems (that's why it's called Developer Edition).

-SQLBill

 

[stef315]

Did you by chance set any sharing on your drive using NTFS permissions? Make sure the system account has full access to the drive.

 

[AndyApp]

it's enterprise edition. that would explain why it isn't working. So which version can I install on XP then? Just Personal and MSDE? What about SQL 7 is it the same with that?

I'm not aware of setting any sharing on my drive, the opposite if anything.

"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[SQLBill]

Personal, Developer and MSDE.

If you have a license for Enterprise or Standard, you can use the Personal edition that comes with those.

Developer is just for developing databases and can not be used for a production database.


Check Microsoft's SQL Server web site for more information on using the various editions.

-SQLBill