SQL Server 2000 Enterprise/Standard Edition on Windows XP?

Question

Post reply

SQL Server 2000 Enterprise/Standard Edition on Windows XP?

maersu

SSC Enthusiast

Points: 185
More actions
September 9, 2004 at 4:02 am

#86351

Hi Guys,
Are there any known problems with MSSQL Server 2000 Enterprise/Standard Editions installing/running on Windows XP?
Thanks a lot

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Yes, you can't run either of those on XP.

Here's the information from Microsoft:

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:

Windows Server 2003, Standard Edition¹
Windows Server 2003, Enterprise Edition¹
Windows Server 2003, Datacenter Edition¹
Windows® 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT® Server version 4.0 with Service Pack 5 (SP5) or later
Windows NT Server 4.0, Enterprise Edition, with SP5 or later

• SQL Server 2000 Evaluation Edition and Developer Edition can run on the following operating systems:

Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later

• SQL Server 2000 Personal Edition² and SQL Server 2000 Desktop Engine (MSDE) can run on the following operating systems:

Operating systems listed above for Enterprise, Standard, Evaluation, and Developer Editions
Windows Server 2003, Web Edition¹ (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)

-SQLBill

mipo Ten Centuries Points: 1286 More actions · Answer 2

Hi

We are running Personal Edition of SQL 2000 on a Windows 2000 Operating System.

In the meantime we moved on to Windows XP Proffessional.

Sometimes we get the message:

'This SQL Server has been optimized for 8 concurrent

queries. This limit has been exceeded by 2 queries and

performance may be adversely affected.

I understood that the Personal Edition degrades performance if the maximum of 5

Transact-SQL batches that are executed concurrently is exceeded.

But I understand as well that the Standard Edition is not running on a Windows 2000 Proffessional or Windows XP Workstation so therefore the Personal Edition has to be chosen.

Can anyone tell me what is correct?

Thanks

Mipo

gbn SSCertifiable Points: 6379 More actions · Answer 3

I'm curious as to why would you want to spend £4100 (GBP) for SQL Enterprise edition to run on a £130 desktop operating system (XP)?

It's "SQL Server" not "SQL Desktop"...

mipo Ten Centuries Points: 1286 More actions · Answer 4

Hi

I don't want to spend 4100 GBP but if you have limitations on the performance?

You agree with me that Standard Edition doesn't run on Windows 2000 Proffessional, right?

So we choose Personal Edition, then we have this stupid limitations!

What do we next? How can we get around this problem?

Thanks for your infos

mipo

gbn SSCertifiable Points: 6379 More actions · Answer 5

Use a server OS?

Any other method (such as running SQL Developer edition) will break MS licensing...

mipo Ten Centuries Points: 1286 More actions · Answer 6

Thanks

Isn't a bit stupid the difference between Personal Edition and the next better version

and there is no other version in between (to have a better performance) than the Personal Edition)?

We use a lot of Workstations running Windows 2000 or Windows XP and it doesn't make sense to buy SQL Developer Edition!

Why doesn't the Standard version run on the workstations? Because of marketing reasons?

Any other suggestions?

Mipo