Solved

installing different version

Posted on 2014-04-29
2
140 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
2 Comments
 
LVL 35

Assisted Solution

by:Bembi
Bembi earned 250 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 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Backup & Restore 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.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now