• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

installing different version

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
25112
Asked:
25112
2 Solutions
 
BembiCEOCommented:
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
 
David ToddSenior DBACommented:
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now