• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Install SQL Server 2000 on SQL Server 2005

I had a SQL Server 2000 client installed on my pc then I installed SQL Server 2005 on the same pc, everything was working fine and then a need arose for me to install the SQL Server 2000 on the machine and the setup does not allow me to do so. In the setup I only see that the client tools options are enabled and the server installation options are disabled. Any ideas how to install 2000 over 2005
0
srafi78
Asked:
srafi78
  • 3
  • 2
  • 2
1 Solution
 
David ToddSenior DBACommented:
Hi,

In the interests of expediency, can you uninstall SQL 2005, install SQL 2000, install SQL 2005 and reattach databases?

Regards
  David
0
 
srafi78Author Commented:
Thanks, I had thought about that earlier but would not like to go that route. There's got to be a way to do this...
0
 
SwindleCommented:
Are you sure you chose the "upgrade" option, or did you install it as a new instance?  In other words, are you sure that SQL 2000 isn't still installed on that machine?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
srafi78Author Commented:
No it is not!
0
 
David ToddSenior DBACommented:
Hi,

What version/edition of Windows is on your machine, and what edition of SQL 2000 are you trying to install? Enterprise and Standard for instance wont install on non-server OS's.

While not completing the install, I've jsut tried with SQL 2000 Developer, and it went through the setup to the point where the Next button is the Install button.

I've got SQL 2000 Developer, SQL 2005 Developer, SQL Express all installed and running alongside each other. Some of the engines are on manual start, as I need them only occassionally.

All that to say: Should work.

Regards
  David
0
 
srafi78Author Commented:
I am running a windows xp pro sp2 on my machine.
I was recently assigned a new machine and had installed only the sql client on the machine.
Then I got my hands on a sql server 2005 Developer disk and installed it.
To test some functionality I wanted to install the SQL Server 2000 on it ans each time I get a message
Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for installation.
May be this is the problem that I am trying to install on windows xp and not on windows server.
0
 
SwindleCommented:
That would definitely be the problem then.  Enterprise Edition is not supported on Windows XP.  Here is a link to the SQL Server 2000 system requirements:

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now