Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

installing different version

Posted on 2014-04-29
2
Medium Priority
?
147 Views
Last Modified: 2014-04-30
in this box sql 2008 already installed as named instance
it also has 2012 ssis (no sql instance).

now to install the proper 2012 db engine as the default instance, is there any precautions to know/take while installing?
0
Comment
Question by:25112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Assisted Solution

by:Bembi
Bembi earned 1000 total points
ID: 40030814
First, i would not install different version of SQL on the same box. Nevertheless each instance of sql point to its own SQL server process. So that means, you can install several insances with different versions of SQL on the same box.
What you have to make sure is that the instances are speperated from each other, means diffenrent ports what need some additional configuration steps.

Every version of SQL install into different directories, but you have to make sure, there there are no port conflicts betwenn the services. So you may have to setp differnet listener ports for each SQL instance.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 1000 total points
ID: 40031056
Hi,

I have had no issues installing different versions of SQL on the same box since SQL 2000. Admittedly the box has generally been my desktop or other test system, rather than a production system.

The one caveat, is install in the order they were released in. ie SQL 2000, SQL 2005, etc.

The other caveat, is that if you attempt to install SQL 2008R2 with SQL 2008 it will update the tools to SQL 2008R2. Not sure what exactly will happen to the instance though.

HTH
  David
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question