Skip to main content

Can we install Multiple Versions of SQL Server in same Machine?

I was asked from so many people by one question, "Can we installed multiple versions of SQL Server in same machine?" and complained about about errors while installation of multiple versions.

What's your answer? My answer is Yes.

Here is the snap which my machine running multiple versions of SQL Server 2005, SQL Server 2008 and SQL Server Denali.

Let's look on below shot
1.



2.


Please share your experience for this , if you got any errors or issues.

Comments

  1. That's pretty good if it can be running well. Cool

    ReplyDelete
  2. yes,we can install different versions of sql server on same machine. I tried with SQL server 2000 developer edition and SQL server 2008 developer edition.We need to take care of instance name while installation.

    ReplyDelete
  3. Yes definitely. We can install different and multiple versions of sql on the same machine. i have installed sql server 205 and 2008 on my machine.At the time of second installation it will not ask for default instance name , if you have given first instance default name.Second instance will be named instance.

    ReplyDelete
  4. To check if there are multiple instances installed on your machine you should select local servers tab in that under database engine if you find multiple instances of sql server then there are multiple instances installed on your machine.If you are selecting Network servers tab then it will show servers installed on entire network as well as on your host machine.

    ReplyDelete
  5. So does this include the Express edition also?

    ReplyDelete
  6. Yes. We can install different versions in the same server. I installed 2000.2005 and 2008 in the same machine with different instances. by my question is can we install 2008 and 2008 R2 in the same machine ?
    Actually I developed a report in r2 with data bars in different machine. When I am copying that report to my machine its giving error. then I came to know SQL server 2008 not having data bars.

    ReplyDelete
  7. Can I installed the same versions of SQL server 2008 R2 on same server ?

    ReplyDelete

Post a Comment