Install SQL Server 2005 on same machine with 2012...

Question

3.67/5 (2 votes)

See more:

SQL-Server-2005

, +

Hi,
I have already installed sqlserver 2012 on my system,now my client project database is sqlserver 2005 ..Is it possible to install sqlserver 2005 after installing sqlserver 2012?

Posted 2-Mar-14 4:00am

Member 10170389

Updated 2-Mar-14 4:02am

Kornfeld Eliyahu Peter

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 2-Mar-14 10:01am

Why to do that? 2012 can handle 2005 databases with no problem...

Andrius Leonavicius 2-Mar-14 17:27pm

*If the solution to your question solves your problem, please mark it as solved. ;)

2 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)

Krunal Rohit · Answer 1 · 2014-03-02T04:58:00

Solution 1

Well yeah, why to do that, there might be possibility that it could not support backward compatibility.
Solution towards your problem is simply on Google[^]. ;)

-KR

Posted 2-Mar-14 4:58am

Krunal Rohit

Andrius Leonavicius · Answer 2 · 2014-03-02T10:56:00

Hi,

First of all, SQL Server 2012 can handle 2005 databases easily (as Kornfeld already said this). But if you need SQL Server 2012 and 2005 instances running on the same operating system (because of backward compatibility or other reasons), then I can say this:

1. If your operating system is Windows Server 2012 or Windows 8, then the answer is maybe. Why? According to Microsoft: "SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8."
But I have seen some workarounds for this (I haven't tried them). Links:
a. Install SQL 2005 Developer on Windows 8[^]
b. How to install SQL Server 2005 Express in Windows 8[^]

2. Well, if your operating system is not Windows Server 2012 or Windows 8, you can do that. Microsoft confirms that if you have installed SQL Server 2012, you can install SQL Server 2005 and run them side-by-side. SQL Server 2005 and 2012 instances can run at the same time and I can confirm that from my own experience. In your case, you may get some error messages during installation. If that would happen, you need to deal with them.

By the way, I would advise you to install SQL Server 2005 database engine only and use SQL Server 2012 Management Studio to manage both instances (2012 and 2005).

Please let me know if you need further help.