Can 7.0 Enterprise Edition Install on XP Pro? 1

[jlgdeveloper]

A client wants to migrate a small piece of their db app to a desktop machine.

Is it possible to install SQL Server 7.0 Enterprise edition on an XP pro machine?

Thanks in advance.

Jonathan

Jonathan Galpin MCSD Õ¿Õ¬

http://www.iqzero.net

because software should be easy to use

 

[mrdenny]

Nope.

Developer, Personal and MSDE will install on non-server OS.

Standard and Enterprise Edition require a Server class OS.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com

 

[jlgdeveloper]

Denny

I appreciate your response, thanks.

I had once attempted an install and was stopped for some reason I could not recall. That was probably it.

Do you believe it is worth putting a database (now on the enterprise edition) onto the current MSDE? I do use stored procedures. It is not heavily used..... I have not fiddled with the MSDE, and understand that the SQL code etc will not be affected or the database modified in any way.

My question is... could the trouble of having to figure out how to use the MSDE, connect to it, move the db etc be a waste of time versus getting the correct OS and moving on at full speed?

Thanks

Jonathan

Jonathan Galpin MCSD Õ¿Õ¬

http://www.iqzero.net

because software should be easy to use

 

[mrdenny]

MSDE is just like SQL Server. You connect with the same tools that you would with SQL Server.

MSDE is crippled however. It will only allow 5 transactions at a time to process, and only allows databases of 1 or 2 gigs.

If it was me, I'd stick with the correct database on the correct platform.

If it's a small database why not use standard edition? Unless you need more than 2 Gigs of RAM, more than 4 processors, or need analysis services, federrated databases or clustering there isn't much point in using Enterprise Edition except to spend the money on the license.

Denny
MCSA (2003) / MCDBA (SQL 2000)

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

http://www.mrdenny.com