Can I install MSSQL 2000 and 2012 in the same PC?

Question

0.00/5 (No votes)

See more:

SQL-server-2000

, +

Hi, I have installed SQL server 2012 on my current machine as backend for new systems projects that are lined up for my company. However, I also need to support legacy systems that is using SQL Server 2000. I have seen threads stating that there would be no problem as long as I am using named instances for each versions. I just wanna make sure if installing 2000 after 2012 is already in my machine would not pose a problem. Thanks in advance for your feedback! :)

What I have tried:

I have seen threads stating that there would be no problem as long as I am using named instances for each versions. I just wanna make sure if installing 2000 after 2012 is already in my machine would not pose a problem.

Posted 25-Aug-16 15:35pm

Sys Dev

Updated 25-Aug-16 22:45pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sys Dev · Answer 1 · 2016-08-25T22:45:00

Solution 3

Found the solution thru trial and error. I reinstalled MSSQL2K as a default instance instead of installing them both as named instance as I previously did. Still, thanks for the feedback guys! :)

Posted 25-Aug-16 22:45pm

Sys Dev

Comments

Maciej Los 26-Aug-16 5:10am

5ed!

The Praveen Singh · Answer 2 · 2016-08-25T20:15:00

Solution 1

Go through msdn Link
Work with Multiple Versions and Instances of SQL Server[^]

Posted 25-Aug-16 20:15pm

The Praveen Singh

Maciej Los · Answer 3 · 2016-08-25T20:16:00

Solution 2

As per MSDN documentation[^], you cannot install MS SQL Sever 2k on the same machine where MS SQL Server 2k12 is installed.
If i'm not wrong, your company can use MS SQL Server 2012 Express version for free. Check this: Download Microsoft® SQL Server® Express License Terms for Redistribution and Hosting from Official Microsoft Download Center[^]

Posted 25-Aug-16 20:16pm

Maciej Los

Comments

Sys Dev 26-Aug-16 4:44am

Well, actually I just did installed both versions on the same machine and both are now working fine. What I did is I reinstalled MSSQL2K as a default instance instead of installing them both as named instance as I previously did. Thank you guys for the feedback though! :)

Maciej Los 26-Aug-16 4:50am

Great! Good to know...