Installed 2000 Standard, but version is showing Personal

Question

Installed 2000 Standard, but version is showing Personal

ceberly

Grasshopper

Points: 17
More actions
November 10, 2008 at 1:44 pm

#94336

Hi,
I have a database app that is dying because I'm getting the "optimized for 8 concurrent queries, this limit has been exceeded".
I thought, I originally installed SQL 2000 Standard. It showed installed under Add/remove. But when I query the version, it shows Personal Edition. I through in the SQL 2000 disk, but there were no upgrade options.
Any ideas on how to get my server performing as SQL 2000 standard and not personal edition?
Thanks,
Craig

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

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

Lowell SSC Guru Points: 323546 More actions · Answer 1

in a nutshell, you can't.

you'll have to upgrade your operating system.... SQL 2000 standard or enterprise can only be installed on Server version operating systems...Win2000,2000 advanced server, 2003;

The cd gracefully installs the limited personal version if you install on xp/vista.

SQl2005 does not do that for you...it will only install the client tools if you use the server disk, and you'd have to separately download SQL 2005 Express or purchase the Developer version.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ceberly Grasshopper Points: 17 More actions · Answer 2

I'm sorry, I should have been more clear.

This install is on Windows Server 2003, so I should somehow be able to get my databases under 2000 standard and not personal edition, correct?

Lowell SSC Guru Points: 323546 More actions · Answer 3

yes you are right; and this is wierd;

if the OS is 2003, then it should install 2000 standard version; if it is saying personal edition, that is not right....

is it possible someone installed personal edition specifically, and you didn't notice that when you installed the standard version,maybe it created an instance instead of upgrading the default instance?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ceberly Grasshopper Points: 17 More actions · Answer 4

Possibly.

How can I tell this?

I don't know if it's the same, but I just uninstalled MSDE 2000, and the results say the same.

In services, I only see MSSQLSERVER, and SQLserverAgent services. I thought when there were instances, you could see seperate services for them.

Can I tell through Enterprise Manager at all?

If I do an uninstall/reinstall of SQL 2000, is there a way to keep my existing DATA?

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

Take backup of existing user databases or keep their mdf and ldf files before you do any changes to existing installation.

MJ