Solved

installing different version

Posted on 2014-04-29
2
145 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 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 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